Help! Can't Connect to Oracle USing Tomcat 4

[Rich Knight]

Hi,
I'm trying to use Tomcat 4's JDBCRealm to authenticate users. When I ran
tests with mySQL, everything went fine. However now that I need to move the
JSP application to production I have to connect to an Oracle 8i database. I
set everthing up the same way by editing the server.xml file, but now Tomcat
won't start. I even tested getting the connection and accessing the
database in one of my jsp's and it works fine, so I don't believe it's the
connectionURL. It gives me the error that I pasted below. Please help,
this unforseen dip has placed me behind schedule at work.
Code added to server.xml (worked fine using mySQL):

  
<Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
              driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc :-o	 racle:thin:test/test@lumbar:1521:testDB?user=test;passw
ord=test"
               userTable="users" userNameCol="login" userCredCol="pass"
            userRoleTable="roles" roleNameCol="admin" />

Error when I attempt to launch Tomcat:

  
Catalina.start: LifecycleException:  Exception opening database connection:
jav
a.sql.SQLException: oracle.jdbc.driver.OracleDriver
LifecycleException:  Exception opening database connection:
java.sql.SQLExcepti
on: oracle.jdbc.driver.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.StandardContext.start(StandardContext.java:3
345)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
        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 java.lang.reflect.Method.invoke(Native Method)
        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.StandardContext.start(StandardContext.java:3
345)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
        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 java.lang.reflect.Method.invoke(Native Method)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)

[Tim Holloway]

Nothing obvious here. All it says was that there was allegedly something wrong with an SQL request.
I'd double-check the URL connection string and see if I could get a log of the actual SQL requests being made at the time of failure.

[Mike Curwen]

Have you tried the following? (this works for me)

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
  driverName="oracle.jdbc.driver.OracleDriver"
  connectionName="test"
  connectionPassword="test"
  connectionURL="jdbc:oracle:thin:@umbar:1521:testDB"
  userTable="users" userNameCol="user_name"
  userCredCol="user_pass"
  userRoleTable="user_roles" 
  roleNameCol="role_name" />

[ February 20, 2002: Message edited by: Mike Curwen ]