关于jdbc连接mysql的问题bug
如果数据库名称出现了下杠“_”。连接数据库时会出现如下异常信息 Exception in thread "main" org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unable to connect to any hosts due to exception: java.lang.ArrayIndexOutOfBoundsException: 49)at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.uland.dataaccess.DbManager.getConnection(DbManager.java:169)
at com.uland.app.MatchSendMail.main(MatchSendMail.java:71)
Caused by: java.sql.SQLException: Unable to connect to any hosts due to exception: java.lang.ArrayIndexOutOfBoundsException: 49
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
at com.mysql.jdbc.Connection.(Connection.java:562)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:361)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
... 3 more
解决办法，数据库名称中不要出现下杠。这个bug是数据库驱动的问题。或者升级jdbc数据库驱动到mysql-connector-java-5.0.0-beta-bin.jar 。这个版本已经解决了这个bug。
其他连接错误一般都会给出清晰的错误提示，就不再说明了。
另外推广一下我做的一个小工具，帮助您生成java代码和数据库文档，免费使用，欢迎您下载
http://www.wlun.cn/down/DataBaseTool.zip
页:
[1]