java c3p0 存储过程_Java Hibernate C3P0存储过程命名查询错误 – 语句关闭后不允许任何操作,无法释放JDBC连接...

面对使用

Java,Hibernate,C3P0,命名查询,

MySQL运行我的存储过程的一些奇怪问题.

存储过程

DELIMITER $$

USE `testdb`;

CREATE PROCEDURE `GetWebUserData`(IN requestId INT)

BEGIN

DECLARE keyId LONG DEFAULT 1;

DECLARE name VARCHAR(255) DEFAULT 'testname';

Select keyId,name;

END;

$$

DELIMITER ;

WebUserData.hbm.xml

/p>

"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

的hibernate.cfg.xml

3000

3600

false

true

1

10

25

0

12

1

3000

Java version: 8

Hibernate core version: 25.1-jre

Hibernate-c3p0 version: 5.3.1.Final

com.mchange.c3p0 version: 0.9.5.2

MySQL connection version: 8.0.11

Java调用存储过程

public List> callStoredProc() {

try {

Session session = sessionFactory.openSession();

Transaction txD = session.beginTransaction();

NativeQuery> nativeQuery = session.getNamedNativeQuery("GetWebUserData");

nativeQuery.setParameter("requestId", "1");

nativeQuery.setReadOnly(false);

List> rows = nativeQuery.list();

txD.commit();

session.close();

return rows;

} catch (Exception e) {

e.printStackTrace();

return null;

}

}

问题：第一次运行存储过程时,没有错误.但是,当它第二次运行时,在该行发生以下异常

List rows = nativeQuery.list();

2018-06-23 16:33:47 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: S1009

2018-06-23 16:33:47 WARN SqlExceptionHelper:129 - SQL Error: 0, SQLState: S1009

2018-06-23 16:33:47 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - No operations allowed after statement closed.

2018-06-23 16:33:47 ERROR SqlExceptionHelper:131 - No operations allowed after statement closed.

2018-06-23 16:33:47 DEBUG org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl - JDBC transaction marked for rollback-only (exception provided for stack trace)

java.lang.Exception: exception just for purpose of providing stack trace

at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.markRollbackOnly(JdbcResourceLocalTransactionCoordinatorImpl.java:314)

at org.hibernate.engine.transaction.internal.TransactionImpl.markRollbackOnly(TransactionImpl.java:200)

at org.hibernate.internal.AbstractSharedSessionContract.markForRollbackOnly(AbstractSharedSessionContract.java:378)

at org.hibernate.internal.ExceptionConverterImpl.handlePersistenceException(ExceptionConverterImpl.java:273)

at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:150)

at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)

at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1515)

at com.mnox.core.hibernate.DatabaseEngine.callStoredProc(DatabaseEngine.java:712)

备选方案#1：我试过评论出来

Transaction txD = session.beginTransaction();

和

txD.commit(); lines (i.e: trying calling the stored procedure without a transaction).

但是,我在List行下面的例外情况. rows = nativeQuery.list();

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to release JDBC Connection

at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)

at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)

at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1515)

at com.mnox.core.hibernate.DatabaseEngine.callStoredProc(DatabaseEngine.java:712)

备选方案#2：我试着注释掉“nativeQuery.setReadOnly(false);”只是为了查看行为.在这种情况下,发生以下异常：

2018-06-23 17:58:03 DEBUG org.hibernate.engine.jdbc.spi.SqlStatementLogger - CALL GetWebUserData(?)

2018-06-23 17:58:03 DEBUG SQL:94 - CALL GetWebUserData(?)

2018-06-23 17:58:04 DEBUG org.hibernate.resource.jdbc.internal.ResourceRegistryStandardImpl - Exception clearing maxRows/queryTimeout [No operations allowed after statement closed.]

2018-06-23 17:58:04 DEBUG ResourceRegistryStandardImpl:175 - Exception clearing maxRows/queryTimeout [No operations allowed after statement closed.]

2018-06-23 17:58:04 DEBUG org.hibernate.engine.jdbc.spi.SqlExceptionHelper - could not execute query [CALL GetWebUserData(?)]

java.sql.SQLException: No operations allowed after statement closed.

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:82)

at com.mysql.cj.jdbc.ClientPreparedStatement.setString(ClientPreparedStatement.java:1764)

at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.setString(NewProxyCallableStatement.java:3687)

at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$1.doBind(VarcharTypeDescriptor.java:46)

at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:74)

at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:280)

at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:275)

at org.hibernate.loader.custom.sql.NamedParamBinder.bind(NamedParamBinder.java:34)

at org.hibernate.loader.custom.CustomLoader.bindParameterValues(CustomLoader.java:475)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2000)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1914)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892)

at org.hibernate.loader.Loader.doQuery(Loader.java:937)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)

at org.hibernate.loader.Loader.doList(Loader.java:2689)

at org.hibernate.loader.Loader.doList(Loader.java:2672)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)

at org.hibernate.loader.Loader.list(Loader.java:2501)

at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)

at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2223)

at org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1053)

at org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:168)

at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1506)

at com.mnox.core.hibernate.DatabaseEngine.callStoredProc(DatabaseEngine.java:711)