着急。。。Mysql连接错误,各位大虾帮帮忙!

o_kxj 2011-04-12 10:31:07
2011-04-12 10:23:22,203 [com.mchange.v2.log.MLog]-[INFO] MLog clients using log4j logging.
2011-04-12 10:23:22,375 [com.mchange.v2.c3p0.cfg.C3P0Config]-[WARN] XML configuration disabled! Verify that standard XML libs are available.
java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence.
at org.apache.xerces.impl.io.UTF8Reader.invalidByte(Unknown Source)
at org.apache.xerces.impl.io.UTF8Reader.read(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.peekChar(Unknown Source)
at org.apache.xerces.impl.XMLScanner.scanComment(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanComment(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:124)
at com.mchange.v2.c3p0.cfg.C3P0ConfigXmlUtils.extractXmlConfigFromInputStream(C3P0ConfigXmlUtils.java:136)
at com.mchange.v2.c3p0.cfg.C3P0ConfigXmlUtils.extractXmlConfigFromDefaultResource(C3P0ConfigXmlUtils.java:119)
at com.mchange.v2.c3p0.cfg.DefaultC3P0ConfigFinder.findConfig(DefaultC3P0ConfigFinder.java:49)
at com.mchange.v2.c3p0.cfg.C3P0Config.<clinit>(C3P0Config.java:92)
at com.mchange.v2.c3p0.impl.PoolBackedDataSourceBase.<init>(PoolBackedDataSourceBase.java:46)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.<init>(AbstractPoolBackedDataSource.java:62)
at com.mchange.v2.c3p0.ComboPooledDataSource.<init>(ComboPooledDataSource.java:109)
at com.mchange.v2.c3p0.ComboPooledDataSource.<init>(ComboPooledDataSource.java:105)
at com.union.framework.dao.DBConnectionFactory.<clinit>(DBConnectionFactory.java:24)
at com.union.framework.dao.BaseDao.<init>(BaseDao.java:50)
at com.union.nbfw.user.dao.UserDao.<init>(UserDao.java:48)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at com.union.framework.service.BaseService.getDao(BaseService.java:40)
at com.union.framework.service.BaseService.getModelBySqlWhere(BaseService.java:235)
at com.union.nbfw.user.action.LoginAction.login(LoginAction.java:39)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.union.framework.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
2011-04-12 10:23:22,500 [com.mchange.v2.c3p0.C3P0Registry]-[INFO] Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
2011-04-12 10:23:22,765 [com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource]-[INFO] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge23m8fjue9sm1d6gdlb|3f7c9e, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> null, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge23m8fjue9sm1d6gdlb|3f7c9e, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
2011-04-12 10:23:51,765 [com.mchange.v2.resourcepool.BasicResourcePool]-[WARN] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@a71a80 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
at java.sql.DriverManager.getDriver(DriverManager.java:253)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
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)
...全文
107 12 打赏 收藏 转发到动态 举报
写回复
用AI写文章
12 条回复
切换为时间正序
请发表友善的回复…
发表回复
o_kxj 2011-04-13
  • 打赏
  • 举报
回复
[Quote=引用 11 楼 richer1015 的回复:]
那个你看一下mySQL配置文件my中是不是把编码方式设置为utf8了,如果没有就改一下就其中两行default-character-set=utf8;character-set-server=utf8,然后保存后将mysql服务器关掉重启,不知道行不行,希望对你有帮助
[/Quote]
mysql中的配置全部都是utf-8的
o_kxj 2011-04-12
  • 打赏
  • 举报
回复
[Quote=引用 1 楼 acherat 的回复:]

XML configuration disabled! Verify that standard XML libs are available.
java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence.

XML配置文件问题,编码格式设置为UTF-8,仔细看看你数据库的连接语句和XML配置,再一点可以到……
[/Quote]
编码格式本身就是UTF-8的,XML配置也没什么问题,至于数据库的连接语句,是使用的已经写好的框架。这里附上XMl的配置:
<property name="jdbcUrl">
jdbc:mysql://localhost:3306/nbfw?useUnicode=true&characterEncoding=utf8
&autoReconnect=true
</property>
<property name="user">root</property>
<property name="password">root</property>
<!--当连接池用完时客户端调用getConnection()后等待获取新连接的时间,超时后将抛出
SQLException,如设丄1�7�无限期等待。单位毫秒�1�7�Default: 0 -->
<property name="checkoutTimeout">10000</property>

<!--毄1�7秒检查所有连接池中的空闲连接。Default: 0 -->
<property name="idleConnectionTestPeriod">30</property>

<property name="initialPoolSize">2</property>

<!--朄1�7大空闲时闄1�7,30秒内未使用则连接被丢弃�1�7�若丄1�7�永不丢弃�1�7�Default: 0 -->
<property name="maxIdleTime">3600</property>


<property name="maxPoolSize">10</property>
<property name="minPoolSize">1</property>
<property name="maxStatements">100</property>

<!--当连接池中的连接耗尽的时候c3p0丄1�7次同时获取的连接数�1�7�Default: 3 -->
<property name="acquireIncrement">3</property>

<!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
<property name="acquireRetryAttempts">30</property>

<!--两次连接中间隔时间,单位毫秒。Default: 1000 -->
<property name="acquireRetryDelay">1000</property>

<!--连接关闭时默认将扄1�7有未提交的操作回滚�1�7�Default: false -->
<property name="autoCommitOnClose">false</property>

<!--c3p0是异步操作的,缓慢的JDBC操作通过帮助进程完成。扩展这些操作可以有效的提升性能
通过多线程实现多个操作同时被执行。Default: 3-->
<property name="numHelperThreads">5</property>
dawugui 2011-04-12
  • 打赏
  • 举报
回复
MYSQL,不懂,帮顶.
建议去mysql版.
AcHerat 2011-04-12
  • 打赏
  • 举报
回复
XML configuration disabled! Verify that standard XML libs are available.
java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence.


XML配置文件问题,编码格式设置为UTF-8,仔细看看你数据库的连接语句和XML配置,再一点可以到相应的版块问,MYSQL或JAVA版块!
richer1015 2011-04-12
  • 打赏
  • 举报
回复
那个你看一下mySQL配置文件my中是不是把编码方式设置为utf8了,如果没有就改一下就其中两行default-character-set=utf8;character-set-server=utf8,然后保存后将mysql服务器关掉重启,不知道行不行,希望对你有帮助
richer1015 2011-04-12
  • 打赏
  • 举报
回复
那个你看一下mySQL配置文件my中是不是把编码方式设置为utf8了,如果没有就改一下就其中两行default-character-set=utf8;character-set-server=utf8,然后保存后将mysql服务器关掉重启,不知道行不行,希望对你有帮助
o_kxj 2011-04-12
  • 打赏
  • 举报
回复
[Quote=引用 5 楼 mysqldbd 的回复:]

是接口程序包的问题。
[/Quote]
接口程序包?是说引用的包吗?
--小F-- 2011-04-12
  • 打赏
  • 举报
回复
[Quote=引用 2 楼 dawugui 的回复:]
MYSQL,不懂,帮顶.
建议去mysql版.
[/Quote]
.
Mr_Nice 2011-04-12
  • 打赏
  • 举报
回复
[Quote=引用 2 楼 dawugui 的回复:]

MYSQL,不懂,帮顶.
建议去mysql版.
[/Quote]

+
mysqldbd 2011-04-12
  • 打赏
  • 举报
回复
是接口程序包的问题。
mysqldbd 2011-04-12
  • 打赏
  • 举报
回复
不是数据库的问题!

22,209

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧