Hi,
I am tearing my hair out at this one! I am attempting to set up JDBCRealm
for my tomcat installation (vers 4.1) and I keep getting the:
Catalina.start: LifecycleException: Exception Opening Database Connection:
Java.sql.SQLException: Com.ibm.db2.jdbc.app.DB2Driver
when I try and start tomcat.
My server.xml looks like:
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="COM.ibm.db2.jdbc.app.DB2Driver"
connectionURL="jdbc:db2:antech"
connectionName = "ausername"
connectionPassword ="apassword"
userTable="user"
userNameCol="userid"
userCredCol="pwd"
userRoleTable="user_roles"
roleNameCol="user_role" />
Things I have done include:
Put db2java.jar in : %CATALINA_HOME%/lib/ , /server/lib/, /common/lib/,
../web-inf/lib
Set JDBC_HOME to point to /server/lib/db2java.jar (also tried pointing
db2java.jar in sqllib/java directory for DB2)
Connecting to the database using the above driverName and connectionURL from
a java app - works no problem
Sacrificed an old mobile phone to the code gods!
This covers every other answer I have found to this problem on the internet,
if anyone can come up with any other solutions I would be a happy chappy!
Cheers
Richard
