This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Sybase datasource without metadata Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Sybase datasource without metadata" Watch "Sybase datasource without metadata" New topic
Author

Sybase datasource without metadata

Gary Bold
Greenhorn

Joined: Jan 04, 2007
Posts: 1
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

Joined: Dec 20, 2006
Posts: 2543
    
  10

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


OCUP UML fundamental and ITIL foundation
 
Have you checked out Aspose?
 
subject: Sybase datasource without metadata
 
It's not a secret anymore!