Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQLException with service pack 2

0 views
Skip to first unread message

farnaz

unread,
Mar 4, 2003, 2:04:44 PM3/4/03
to

I am using weblogic 6.1 with jdbc connections to sybase database. With service
pack 1, I have no problem connecting.
The only thing that I change is pointing to service pack 2 instead of service
pack 1 and i get the following exception:
Please Help!

<Mar 4, 2003 10:48:43 AM PST> <Error> <JDBC> <Cannot startup connection pool "BackupDatabase"
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 com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.jdbc.MdaManager.loadMetaData(MdaManager.java)
at com.sybase.jdbc.MdaManager.<init>(MdaManager.java)
at com.sybase.jdbc.MdaManager.<init>(MdaManager.java)
at com.sybase.jdbc.SybConnection.checkMDA(SybConnection.java)
at com.sybase.jdbc.SybConnection.getMDA(SybConnection.java)
at com.sybase.tds.Tds.getIntOption(Tds.java)
at com.sybase.jdbc.SybConnection.getTransactionIsolation(SybConnection.java)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:135)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:698)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:282)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:623)
at weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:107)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:329)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:279)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:233)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:193)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:636)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:621)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:359)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:468)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:209)
at $Proxy35.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:2761)
at weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManager.java:370)
at weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:160)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:636)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:621)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:359)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:468)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:209)
at $Proxy46.start(Unknown Source)
at weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationManagerMBean_CachingStub.java:480)
at weblogic.management.Admin.startApplicationManager(Admin.java:1180)
at weblogic.management.Admin.finish(Admin.java:590)
at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:518)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:203)
at weblogic.Server.main(Server.java:35)
>
<Mar 4, 2003 10:48:45 AM PST> <Error> <JDBC> <Cannot startup connection pool "MasterDatabase"
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 com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.jdbc.MdaManager.loadMetaData(MdaManager.java)
at com.sybase.jdbc.MdaManager.<init>(MdaManager.java)
at com.sybase.jdbc.MdaManager.<init>(MdaManager.java)
at com.sybase.jdbc.SybConnection.checkMDA(SybConnection.java)
at com.sybase.jdbc.SybConnection.getMDA(SybConnection.java)
at com.sybase.tds.Tds.getIntOption(Tds.java)
at com.sybase.jdbc.SybConnection.getTransactionIsolation(SybConnection.java)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:135)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:698)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:282)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:623)
at weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:107)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:329)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:279)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:233)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:193)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:636)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:621)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:359)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:468)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:209)
at $Proxy35.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:2761)
at weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManager.java:370)
at weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:160)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:636)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:621)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:359)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:468)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:209)
at $Proxy46.start(Unknown Source)
at weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationManagerMBean_CachingStub.java:480)
at weblogic.management.Admin.startApplicationManager(Admin.java:1180)
at weblogic.management.Admin.finish(Admin.java:590)
at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:518)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:203)
at weblogic.Server.main(Server.java:35)
>

Joseph Weinstein

unread,
Mar 4, 2003, 2:39:11 PM3/4/03
to farnaz

farnaz wrote:

> I am using weblogic 6.1 with jdbc connections to sybase database. With service
> pack 1, I have no problem connecting.
> The only thing that I change is pointing to service pack 2 instead of service
> pack 1 and i get the following exception:
> Please Help!

Hi. We have added more safety code in our pooling to make sure the pool connections
are returned to a known, standard state before being allowed to be re-used. This involves
making some standard JDBC metadata calls. Unfortunately Sybase has decided to implement
some calls in it's driver, to require some stored procedures in the DBMS, that are not there
in the standard DBMS! Sybase provides a sql script to install the needed procedures in the
DBMS. You should download that script, and ask your DBA to run it to install the procedures,
so the Sybase JDBC driver will work completely.
thanks,
Joe

farnaz

unread,
Mar 4, 2003, 3:29:44 PM3/4/03
to

Are the future service packs (4 or above for 6.1) or future versions of weblogic
also requiring this? Or is it only with sp2
on wls6.1? I am trying to find out if i can get away without
applying the stored procedures and move to a new version.

Joseph Weinstein

unread,
Mar 4, 2003, 3:50:35 PM3/4/03
to farnaz

farnaz wrote:

> Are the future service packs (4 or above for 6.1) or future versions of weblogic
> also requiring this? Or is it only with sp2
> on wls6.1? I am trying to find out if i can get away without
> applying the stored procedures and move to a new version.

All future WLS versions will be making these standard JDBC calls. For example,
we have to check the connection's default transaction isolation level so that if
any application code changes it, we will know what to reset it to.
Joe

farnaz

unread,
Mar 4, 2003, 4:17:35 PM3/4/03
to

Thanks for the info. I am looking on sybase download website, and it's not so
easy to look for the script. how should i search for it, or can u point me to
the link, please? thanks!

Joseph Weinstein

unread,
Mar 4, 2003, 5:39:10 PM3/4/03
to farnaz

farnaz wrote:

> Thanks for the info. I am looking on sybase download website, and it's not so
> easy to look for the script. how should i search for it, or can u point me to
> the link, please? thanks!

Just download the latest driver. The script is contained in the package.

farnaz

unread,
Mar 5, 2003, 12:34:32 PM3/5/03
to

then what is the version of sybase driver that is provided in weblogic 6.1 sp 2?

farnaz

unread,
Mar 5, 2003, 1:11:00 PM3/5/03
to

Another road block... jconnect for jdbc is not available for
download on the sybase website. this means that we would need to
purchase it. is there any other way for me to get a hold of this script?

Joseph Weinstein

unread,
Mar 5, 2003, 1:22:36 PM3/5/03
to farnaz

farnaz wrote:

> Another road block... jconnect for jdbc is not available for
> download on the sybase website. this means that we would need to
> purchase it. is there any other way for me to get a hold of this script?

No, it's free. You may have to register on their site (should also be free)
in order to get to the download page. Sybase driver-specific help can
also be gotten at news://forums.sybase.com, in the sybase.public.jconnect50
newsgroup. Someone there might just post the sql script for you.
Joe

Joseph Weinstein

unread,
Mar 5, 2003, 1:20:26 PM3/5/03
to farnaz

farnaz wrote:

> then what is the version of sybase driver that is provided in weblogic 6.1 sp 2?

An older one. Sybase has a later one (they change often), so you should definitely
get the latest.

0 new messages