Tomcat 4.1.12 - JDBCRealm with Oracle 8i, Null Point Exception

[krzysztofm]

After I have configured JDBC Realm - tomcat does not startup.

[INFO] Registry - -Creating new Registry instance
[INFO] Registry - -Creating MBeanServer
[INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080
Starting service Tomcat-Standalone
Apache Tomcat/4.1.12
java.lang.NullPointerException
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:617)
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.StandardEngine.start(StandardEngine.java:347

The config line in server.xml

<Realm className=&quot;org.apache.catalina.realm.JDBCRealm&quot; debug=&quot;0&quot;
connectionURL=&quot;jdbc.oracle.oci8stadion&quot;
driverName=&quot;oracle.jdbc.driver.OracleDriver&quot;
connectionName=&quot;dbo&quot; connectionPassword=&quot;password&quot;
userTable=&quot;users_test&quot; userNameCol=&quot;user_name&quot; userCredCol=&quot;user_pass&quot;
userRoleTable=&quot;test_roles&quot; roleNameCol=&quot;role_name&quot; />

The oracle driver jar file is id ../common/lib directory.

Thanks for any help.

 

[jsimonton]

I've just encountered the same problem. Did you ever determine the problem. I notice there were no replies.

j

 

[rclarence]

Looks to me like your connection URL may be invalid. A typical Oracle JDBC URL would be something like this:

connectionURL=&quot;jdbc.oracle.thinmyserverort#:SID&quot;

where myserver = name of the server Oracle is running on
port# = port Oracle listens on (typically 1521)
SID = Oracle instance identifier (ORCL by default).

I'm not sure if you can use the OCI driver with Tomcat (I use the thin driver and it works fine).

Hope that helps

RHC

 

[jby1]

You can use the OCI driver with Tomcat, cos I have managed to!