I am having a problem using a tomcat 5.5.17 datasource with Sybase 9.0.2 and jconn2.jar (have also tried jconn3)
I can connect using:
However when I try the same thing through the datasource
I get the error:
Cannot create PoolableConnectionFactory (JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation.)
Seems like these tables must be there if I can connect as above. Any ideas? Can I tell tomcat not to use a poolable connection and will that eliminate the error?