数据库异常
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1765)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at util.DBUtil.getConnection(DBUtil.java:13)
at util.DBUtil.main(DBUtil.java:37)
** END NESTED EXCEPTION **
-----conn-----------null
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1830)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at util.DBUtil.getConnection(DBUtil.java:13)
at util.DBUtil.main(DBUtil.java:37)
我做的练习是ssh框架整合,在action中注入service,
public String getAll(){
System.out.println("book getall...");
List<Book> bookList = bookService.getAllBook();
System.out.println("4444444");
return "getAll";
}
book getall,,, 输出了,但44444没有输出
dabug时bookService注入了不为null;但getAllBook方法没有调用成功,
我在List bookList = bookService.getAllBook();这句上加了个try catch将异常打印出来,看异常信息知道是dataSource里面的url写错了。。。导致数据库无法连接