Hi,
I am trying to connect Sybase 11.x with sybase jconnect driver from
weblogic6.0, its giving the following error when i start the server.
But from my bean class, i'm able to execute a sample query using this
connection pool.
Are these exceptions irrelevant?
Any help on this topic will be greatly appreciated.
-------------------------------------------------------------
JDBC log stream started at Tue Jan 02 12:16:04 GMT+05:30 2001
-------------------------------------------------------------
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=com.sybase.jdbc.SybDriver,com.sybase.jdbc.SybDriver@60f0ad]
DriverManager.deregisterDriver: com.sybase.jdbc.SybDriver@60f0ad
registerDriver:
driver[className=com.sybase.jdbc.SybDriver,com.sybase.jdbc.SybDriver@3dd208]
DriverManager.deregisterDriver: com.sybase.jdbc.SybDriver@3dd208
registerDriver:
driver[className=com.sybase.jdbc.SybDriver,com.sybase.jdbc.SybDriver@28402c]
SQLWarning: reason(Password required to set role 'testrole' on.
) SQLstate(01ZZZ) vendor code(11141)
SQLWarning: reason(Password required to set role 'testrole' on.
) SQLstate(01ZZZ) vendor code(11141)
SQLException: SQLState(ZZZZZ) vendor code(249)
com.sybase.jdbc.SybSQLException: Syntax error during explicit conversion of
VARCHAR value 'A' to a INT field.
at com.sybase.tds.Tds.processEed(Tds.java)
at com.sybase.tds.Tds.nextResult(Tds.java)
at com.sybase.jdbc.ResultGetter.nextResult(ResultGetter.java)
at com.sybase.jdbc.SybStatement.nextResult(SybStatement.java)
at com.sybase.jdbc.SybStatement.queryLoop(SybStatement.java)
at
com.sybase.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.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.<init>(SybConnection.java)
at com.sybase.jdbc.SybDriver.connect(SybDriver.java)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:148)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:107)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:590)
at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:233)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:318)
at weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:91)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:283)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:233)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:194)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:158)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:559)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:545)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
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:431)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:172)
at $Proxy30.updateDeployments(Unknown Source)
at
weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:2299)
at
weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManager.java:239)
at
weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:121)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:559)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:545)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
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:431)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:172)
at $Proxy29.start(Unknown Source)
at
weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationManagerMBean_CachingStub.java:435)
at weblogic.management.Admin.startApplicationManager(Admin.java:959)
at weblogic.management.Admin.finish(Admin.java:459)
at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:429)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:170)
at weblogic.Server.main(Server.java:35)
SQLException: SQLState(ZZZZZ) vendor code(509)
com.sybase.jdbc.SybSQLException: User name 'dba' not found.
at com.sybase.tds.Tds.processEed(Tds.java)
at com.sybase.tds.Tds.nextResult(Tds.java)
at com.sybase.jdbc.ResultGetter.nextResult(ResultGetter.java)
at com.sybase.jdbc.SybStatement.nextResult(SybStatement.java)
at com.sybase.jdbc.SybStatement.queryLoop(SybStatement.java)
at
com.sybase.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.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.<init>(SybConnection.java)
at com.sybase.jdbc.SybDriver.connect(SybDriver.java)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:148)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:107)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:590)
at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:233)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:318)
at weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:91)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:283)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:233)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:194)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:158)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:559)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:545)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
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:431)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:172)
at $Proxy30.updateDeployments(Unknown Source)
at
weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:2299)
at
weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManager.java:239)
at
weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:121)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:559)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:545)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
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:431)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:172)
at $Proxy29.start(Unknown Source)
at
weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationManagerMBean_CachingStub.java:435)
at weblogic.management.Admin.startApplicationManager(Admin.java:959)
at weblogic.management.Admin.finish(Admin.java:459)
at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:429)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:170)
at weblogic.Server.main(Server.java:35)
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.<init>(SybConnection.java)
at com.sybase.jdbc.SybDriver.connect(SybDriver.java)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:148)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:107)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:590)
at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:233)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:318)
at weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:91)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:283)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:233)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:194)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:158)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:559)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:545)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
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:431)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:172)
at $Proxy30.updateDeployments(Unknown Source)
at
weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:2299)
at
weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManager.java:239)
at
weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:121)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:559)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:545)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
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:431)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:172)
at $Proxy29.start(Unknown Source)
at
weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationManagerMBean_CachingStub.java:435)
at weblogic.management.Admin.startApplicationManager(Admin.java:959)
at weblogic.management.Admin.finish(Admin.java:459)
at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:429)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:170)
at weblogic.Server.main(Server.java:35)
SQLException: SQLState(JZ0SJ)
SQLWarning: reason(010MX: Metadata accessor information was not found on
this database. Please install the required tables as mentioned in the
jConnect documentation. Error encountered while attempting to retrieve
metadata information: java.sql.SQLException: JZ0SJ: Metadata accessor
information was not found on this database. Please install the required
tables as mentioned in the jConnect documentation.) SQLState(010MX)
registerDriver:
driver[className=weblogic.jdbc.jts.Driver,weblogic.jdbc.jts.Driver@735b26]
registerDriver:
driver[className=weblogic.jdbc.pool.Driver,weblogic.jdbc.pool.Driver@4e21db]
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
