Help! Can't Connect to Oracle Database Using Tomcat

[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@server:1521:testDB?user=test;password=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)

[ February 20, 2002: Message edited by: Rich Knight ]

[martin samm]

i had a similar problem with tomcat 3-3. Are you using classes12.zip (as supplied by Oracle) for the Oracle JDBC classes? Try renaming the file to .jar rather than .zip - seems Tomcat (at least with 3-3) has a mysterious problem with the .zip extension. Hope that helps

[Rich Knight]

Thanks for the reply,
Yes I am using classes12.zip, and I renamed it to .rar. Same results .

[Rich Knight]

I'm able to boot up fine now, but when I try to login to my JSP I get the following error generated in my log file. The error is only generated if the user actually exists in the database, so I'm sure I'm connecting and accessing the info. Thanks :

JDBCRealm[/myApp]: Exception performing authentication
java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:829)
at oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:1746)
at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(DBConversion.java:1585)
at oracle.jdbc.dbaccess.DBConversion.utf8BytesToString(DBConversion.java:1445)
at oracle.jdbc.dbaccess.DBConversion.CharBytesToString(DBConversion.java:384)
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:2571)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:305)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:379)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:326)
at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:263)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)

[ February 20, 2002: Message edited by: Rich Knight ]