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
I get the UnsatisfiedLinkError Full stacktrace.
Sorry for the length of that stacktrace Thanks Mark
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.