java.sql.SQLException: JZ0SJ: Metadata accessor ...

[Victor Batista]

Hello, I am running some servlets, which use jConnect 5.0. I am having
the following exceptions several times:

java.sql.SQLException: JZ0SJ: Metadata accessor information was not
found on this database. Please install the required tables as mentioned
in the jConnect documentation.
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.<init>(Throwable.java:94)
at java.lang.Exception.<init>(Exception.java:42)
at java.sql.SQLException.<init>(SQLException.java:64)
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:436)

at com.sybase.jdbc2.jdbc.MdaManager.loadMetaData(MdaManager.java:393)
at com.sybase.jdbc2.jdbc.MdaManager.<init>(MdaManager.java:135)
at com.sybase.jdbc2.jdbc.MdaManager.<init>(MdaManager.java:120)
at
com.sybase.jdbc2.jdbc.SybConnection.checkMDA(SybConnection.java:1535)
at
com.sybase.jdbc2.jdbc.SybConnection.checkDBMD(SybConnection.java:1551)
at
com.sybase.jdbc2.jdbc.SybConnection.getMetaData(SybConnection.java:755)
....
....

Some times I can access the databases, others the previous exception is
raised.
Can anyone help me, please.

Thank you in advance,
Victor Batista

[Lance Andersen]

Make sure you have installed the sprocs and tables needed by the driver
by running the sql_server.sql (ASE) or sql_asa.sql (ASA).

And make sure this is done as sa for ASE or DBA for ASA.

Lance

--
===============================================================================
Lance J. Andersen Email: lan...@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================