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