I have Tomcat 4. I have classes12.jar in the common/lib directory. The following code in a Java Class that my servlet calls is:
There is a couple more lines following. However my error occurs in the getConnection call. I changed the url, user and password to say above to protect the innocent. This code runs fine through java itself, without Tomcat or Servlet. The Servlet call is
Try changing oci8 in the db connection URI, to thin
So it should be: jdbcracle:thin:@db_test_serv:1521:db_test_t
I can't think of a good reason to be using the oci driver outside of an application server. The thin driver requires less system resources, but the flip side is perhaps a slight performance hit.
If you are *required* to use the OCI drivers, then you need to make sure that the driver can find the native libraries it needs, which might require a few more things installed on your box than just the 'thin' driver requires.