tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chad Perry" <chadhpe...@hotmail.com>
Subject JDBCRealm and Oracle Not working
Date Sun, 19 May 2002 03:20:42 GMT
Trying to get Oracle 8i to work with with the JDBCRealm:
Tomcat 4.0.4b3
JDK 1.4.0
OS Win2000 Server



I guess tomcat-JDBCRealm doesn't work with Oracle? It would be AWESOME if I 
could get this
to work! Could somebody verify that I'm not dorking out? Thanks!!


Here is my Realm element:

      <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"

      	       driverName="oracle.jdbc.driver.OracleDriver"

      	       connectionURL="jdbc:oracle:thin:@192.168.0.10:1521:TestDB"

      	       connectionName="XXXXX"

      	       connectionPassword="XXXXX"

      	       userTable="GOLDEN.APP_USER" userNameCol="USER_NAME" 
userCredCol="PASSWORD_TXT"

               userRoleTable="GOLDEN.APP_ROLE" roleNameCol="ROLE_NAME"/>


EXCEPTION BELOW - Occurs on Start up:

Starting service Tomcat-Standalone
Apache Tomcat/4.0.4-b3
Starting service Tomcat-Apache
Apache Tomcat/4.0.4-b3
Catalina.start: LifecycleException:  Exception opening database connection:  
java.sql.SQLException:
oracle.jdbc.driver.OracleDriver
LifecycleException:  Exception opening database connection:  
java.sql.SQLException: oracle.jdbc.driv
er.OracleDriver
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
        at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
        at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
        at 
org.apache.catalina.core.StandardService.start(StandardService.java:388)
        at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        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:243)
----- Root Cause -----
java.sql.SQLException: oracle.jdbc.driver.OracleDriver
        at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538)
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
        at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
        at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
        at 
org.apache.catalina.core.StandardService.start(StandardService.java:388)
        at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        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:243)



MISC RESEARCH:

The bug report belows makes me think this is still an issue even
in Apache Tomcat/4.0.4-b3:
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=5660

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message