tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Diaz <david.d...@leals.com>
Subject LifecycleException, Oracle's Realm
Date Mon, 06 Oct 2003 21:20:39 GMT
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


Mime
View raw message