Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Sybase datasource without metadata

 
Gary Bold
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Jan Cumps
Bartender
Posts: 2619
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Gary Bold:

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?


From the product's installation manual:
For jConnect to function properly, you must install stored procedures and tables ...

You need to verify if you have completed the installation procedure of the product.

Regards, Jan
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!