You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by David Diaz <da...@leals.com> on 2003/10/06 23:20:39 UTC
LifecycleException, Oracle's Realm
After downloading and installing a clean tomcat 4.1.27, I just add the below
realm to the server.xml file and I get the below exception at start time:
REALM
-----
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:user/passwd@host:1524:bdtb1a"
connectionName="gestmon"
connectionPassword="acemon"
userTable="ttm_usuario" userNameCol="id_usuario"
userCredCol="id_paso"
userRoleTable="ttm_usuariorole"
roleNameCol="id_role"/>
EXCEPTION
---------
Catalina.start: LifecycleException: Excepcion abriendo la conexion a la base
de datos: java.sql.SQLException: oracle.jdbc.driver.OracleDriver
LifecycleException: Excepcion abriendo la conexion a la base de datos:
java.sql.SQLException: oracle.jdbc.driver.OracleDriver
NOTES
-----
* JAVA_HOME, CATALINA_HOME, PATH, etc. are right.
* The Oracle's tnsnames.ora file is right.
I have been able to connect to that database from the same machine where
tomcat is installed; it was checked with both TOAD and sqlplus.
* I have added the needed Oracle drivers to the both common/lib and server/lib
directory. If I remove that drivers the exception is exactly the same!!!
Any tip which can help me?.
APPENDIX - The full output. Platform: Windows 2000 Profesional.
--------
C:\jakarta-tomcat-4.1.27\bin>catalina run
Using CATALINA_BASE: C:\jakarta-tomcat-4.1.27
Using CATALINA_HOME: C:\jakarta-tomcat-4.1.27
Using CATALINA_TMPDIR: C:\jakarta-tomcat-4.1.27\temp
Using JAVA_HOME: C:\j2sdk1.4.1_02
06-oct-2003 17:41:02 org.apache.commons.modeler.Registry loadRegistry
INFO: Loading registry information
06-oct-2003 17:41:02 org.apache.commons.modeler.Registry getRegistry
INFO: Creating new Registry instance
06-oct-2003 17:41:03 org.apache.commons.modeler.Registry getServer
INFO: Creating MBeanServer
06-oct-2003 17:41:04 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on port 8080
Starting service Tomcat-Standalone
Apache Tomcat/4.1.27
Catalina.start: LifecycleException: Excepcion abriendo la conexion a la base
de datos: java.sql.SQLException: oracle.jdbc.driver.OracleDriver
LifecycleException: Excepcion abriendo la conexion a la base de datos:
java.sql.SQLException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:681)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:738)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
at
org.apache.catalina.core.StandardService.start(StandardService.java:497)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
----- Root Cause -----
java.sql.SQLException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:606)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:679)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:738)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
at
org.apache.catalina.core.StandardService.start(StandardService.java:497)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
Stopping service Tomcat-Standalone
Catalina.stop: LifecycleException: Coyote connector has not been started
LifecycleException: Coyote connector has not been started
at
org.apache.coyote.tomcat4.CoyoteConnector.stop(CoyoteConnector.java:1199)
at
org.apache.catalina.core.StandardService.stop(StandardService.java:546)
at
org.apache.catalina.core.StandardServer.stop(StandardServer.java:2225)
at org.apache.catalina.startup.Catalina.start(Catalina.java:543)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
C:\jakarta-tomcat-4.1.27\bin>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org