Sybase datasource without metadata

[Gary Bold]

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:

    Class.forName("com.sybase.jdbc2.jdbc.SybDriver"); 
    String url = jdbc:sybase:Tds:HOST:2638/DATABASE"; 
    Statement stmt = conn.createStatement();

However when I try the same thing through the datasource

<Context path="/TEST" docBase="BU_TEST" crossContext="true">
  <Resource name="jdbc/TEST" auth="Container" type="javax.sql.DataSource"
    username="USER" password="PASSWORD"
    driverClassName="com.sybase.jdbc2.jdbc.SybDriver"   url="jdbc:sybase:Tds:HOST:2638/DATABASE"
/>
    <!-- Disables restart persistence of sessions -->
    <Manager pathname=""/>
</Context>
    

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]

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