This is pretty bizarre. We call setAutoCommit(false) on a
connection, and the Sybase JDBC driver converts that to a
PreparedStatement, which it then tries to run and fails to process
corrrectly?
Are you sure the jConnect script you ran was totally successfull?
Are there issues with the version of jConnect vs. the version of Sybase,
or the script vs. the product? I seem to remember that there were
different scripts for different products (ASA vs ASE and version
differences too). I tested jConnect 5.2 with Sybase Adaptive Server
Enterprise 11.9.2 for Linux, and didn't have this problem.
Aaron
On Thu, 9 Nov 2000, Dubchak, John wrote:
> While trying to configure my Sybase driver, after having run the .sql script
> from jConnect in order to setup the XADataSource connection pooling, I am
> getting the following Exception:
>
> [DefaultDS] java.sql.SQLException: JZ006: Caught IOException:
> java.io.IOExceptio
> n: JZ0I6: An error occured converting UNICODE to the charset used by the
> server.
> Error message: java.io.CharConversionException:
> java.io.UnsupportedEncodingExc
> eption: Cp850
> [DefaultDS] at
> com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.ja
> va:426)
> [DefaultDS] at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2794)
> [DefaultDS] at com.sybase.jdbc2.tds.Tds.language(Tds.java:635)
> [DefaultDS] at
> com.sybase.jdbc2.jdbc.SybStatement.sendQuery(SybStatement.jav
> a:1315)
> [DefaultDS] at
> com.sybase.jdbc2.jdbc.SybPreparedStatement.sendQuery(SybPrepa
> redStatement.java:913)
> [DefaultDS] at
> com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement
> .java:1458)
> [DefaultDS] at
> com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybP
> reparedStatement.java:88)
> [DefaultDS] at com.sybase.jdbc2.tds.Tds.setOption(Tds.java:1012)
> [DefaultDS] at
> com.sybase.jdbc2.jdbc.SybConnection.setAutoCommit(SybConnecti
> on.java:577)
> [DefaultDS] at
> org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataS
> ourceImpl.java:128)
> [DefaultDS] at
> org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataS
> ourceImpl.java:155)
> [DefaultDS] at
> org.jboss.minerva.factories.XAConnectionFactory.createObject(
> XAConnectionFactory.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(X
> APoolDataSource.java:169)
> [DefaultDS] at
> org.jboss.jdbc.XADataSourceLoader.initializePool(XADataSource
> Loader.java:288)
> [DefaultDS] at
> org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo
> ader.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(Dependenc
> yManager.java:284)
> [DefaultDS] at
> org.jboss.dependencies.DependencyManager.loadService(Dependen
> cyManager.java:261)
> [DefaultDS] at
> org.jboss.dependencies.DependencyManager.processService(Depen
> dencyManager.java:243)
> [DefaultDS] at
> org.jboss.dependencies.DependencyManager.processService(Depen
> dencyManager.java:238)
> [DefaultDS] at
> org.jboss.dependencies.DependencyManager.startMBeans(Dependen
> cyManager.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)
>
> Has anyone else experienced this?
>
> Thanks,
> John
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
