Hi all
I'm using Sybase SQL Anywhere Database Engine Version 5.5.04 Build #1982 and
jConnect 5.2, and getting errors on startup (log at the the end of this
email).
I have read and (I believe followed) the Sybase configuration instructions
outlined in the jBoss documentation. Basically I have merely added the
Sybase config details to the "with tomcat" config files. From the error
message, it seems like I haven't installed the metadata stored procedures.
I did run sql_asa.sql (not sql_anywhere.sql as stated in the Sybase doco -
this does not exist), which I reckon should have done this. I can get a
small Java app to work with jConnect, with no errors or warnings. Before I
installed sql_asa.sql my Java app caused mutterings in the Open Server
Gateway, which went away when I ran sql_asa.sql.
Many thanks
Steve Slatcher
[DefaultDS] Starting
[DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
DriverManager.getConnection("jdbc:sybase:Tds:harris:5000/sdb")
trying
driver[className=com.sybase.jdbc2.jdbc.SybDriver,com.sybase.jdbc2.jdbc.SybDr
iver@7a84e4]
[DefaultDS] java.sql.SQLException: JZ0SJ: Metadata accessor information was
not found on this database. Please install the required tables as mentioned
in the jConnect documentation.
[DefaultDS] at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:439)
[DefaultDS] at
com.sybase.jdbc2.jdbc.MdaManager.getMetaDataAccessor(MdaManager.java:292)
[DefaultDS] at
com.sybase.jdbc2.jdbc.MdaManager.getMetaDataAccessor(MdaManager.java:265)
[DefaultDS] at
com.sybase.jdbc2.jdbc.MdaManager.getMetaDataAccessor(MdaManager.java:256)
[DefaultDS] at com.sybase.jdbc2.jdbc.MdaManager.<init>(MdaManager.java:151)
[DefaultDS] at com.sybase.jdbc2.jdbc.MdaManager.<init>(MdaManager.java:120)
[DefaultDS] at
com.sybase.jdbc2.jdbc.SybConnection.checkMDA(SybConnection.java:1572)
[DefaultDS] at
com.sybase.jdbc2.jdbc.SybConnection.init(SybConnection.java:269)
[DefaultDS] at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnec
tion.java:193)
[DefaultDS] at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:169)
[DefaultDS] at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:122)
[DefaultDS] at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:175)
[DefaultDS] at java.sql.DriverManager.getConnection(Unknown Source)
[DefaultDS] at java.sql.DriverManager.getConnection(Unknown Source)
[DefaultDS] at
org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:
121)
[DefaultDS] at
org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:
155)
[DefaultDS] at
org.jboss.minerva.factories.XAConnectionFactory.createObject(XAConnectionFac
tory.java:232)
[DefaultDS] at
org.jboss.minerva.pools.ObjectPool.createNewObject(ObjectPool.java:801)
[DefaultDS] at
org.jboss.minerva.pools.ObjectPool.getObject(ObjectPool.java:549)
[DefaultDS] at
org.jboss.minerva.datasource.XAPoolDataSource.getConnection(XAPoolDataSource
.java:169)
[DefaultDS] at
org.jboss.jdbc.XADataSourceLoader.initializePool(XADataSourceLoader.java:288
)
[DefaultDS] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:252)
[DefaultDS] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:92)
[DefaultDS] at java.lang.reflect.Method.invoke(Native Method)
[DefaultDS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[DefaultDS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[DefaultDS] at
org.jboss.dependencies.DependencyManager.startMBean(DependencyManager.java:2
84)
[DefaultDS] at
org.jboss.dependencies.DependencyManager.loadService(DependencyManager.java:
261)
[DefaultDS] at
org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
va:243)
[DefaultDS] at
org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
va:238)
[DefaultDS] at
org.jboss.dependencies.DependencyManager.startMBeans(DependencyManager.java:
117)
[DefaultDS] at org.jboss.Main.<init>(Main.java:162)
[DefaultDS] at org.jboss.Main$1.run(Main.java:87)
[DefaultDS] at java.security.AccessController.doPrivileged(Native Method)
[DefaultDS] at org.jboss.Main.main(Main.java:83)
SQLException: SQLState(JZ0SJ)
SQLWarning: reason(010SK: Database cannot set connection option
SET_CATALOG.) SQLState(010SK)
getConnection returning
driver[className=com.sybase.jdbc2.jdbc.SybDriver,com.sybase.jdbc2.jdbc.SybDr
iver@7a84e4]
[DefaultDS] Started
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
