[ JAVA连接数据库是其众多功能中的一部分,主要有两种方式连接DataBase: 一种是采用JDBC-ODBC桥,另一种则是称之为纯驱动连接DataBase,第一种方式在大型项目中基本上不
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3361)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3295)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1852)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1975)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2476)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1583)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1859)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1777)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1762)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:101)
... 10 more
com.zhongrx.base.exception.BusinessException: err.base.0001
"try restarting transaction"
这是事务之间的关系存在问题,比如说事务嵌套等等
请楼主仔细看一下开启事务和commit事务的代码,一次开启和一次提交之间有没有
开新的事务等等。。[MySQL Connector/J在处理MySQL数据类型和Java数据类型的转换处理方面十分灵活。尽管可能会出现舍入、溢出或精度损失,当在通常情况下,能够将任何MySQL数据类型转换为java
[使用java连接Mysql 和Using JDBC Statement Objects to Execute SQL 首先引入mysql-connector-javaXXXXX.jar的包:项目test右键 Build Path> Add External Achives.....>