我用c3p0连接sybase数据库,结果c3p0报错了,错误如下:
SQLWarnings - Character set conversion is not available between client character set 'eucgb' and server character set 'cp850'.java.sql.SQLWarning: Character set conversion is not available between client character set 'eucgb' and server character set 'cp850'. at net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2979)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2264)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:610)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
C3P0PooledConnectionPool - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@16e8707.acquireResource() returning. 
SQLWarnings - Character set conversion is not available between client character set 'eucgb' and server character set 'cp850'.我的url写的是:jdbc:jtds:sybase://192.168.0.63:5000/test;charset=eucgb
请问这是错误在哪里呢?

解决方案 »

  1.   

    额 把charset换成cp850  jdbc:jtds:sybase://192.168.0.63:5000/test;charset=cp850  反正两个字符集一样就行了
      

  2.   

    用cp850不行啊,查出的中文会有乱码,我原来用charset=eucgb时在dbcp下没报错,直接用jdbc的方式也没报错,但是到了c3p0下就报错,请问这是什么问题呢?
      

  3.   

    那就还用dbcp吧,不要听网上说的什么dbcp bug多,只要配置好了,没什么问题的。