Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

LifecycleException, Oracle's Realm

David Diaz

2003-10-06


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@(protected)"
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@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)


©2008 junlu.com - Jax Systems, LLC, U.S.A.