我得到了这个错误:
2014-11-14 17:39:44 [WARN]SqlExceptionHelper:143 SQL Error: 0, SQLState: 08S01
2014-11-14 17:39:44 [ERROR]SqlExceptionHelper:144 Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2014-11-14 17:39:44 [ERROR]BackupService:245 org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection似乎Hibernate对我的作业有一个很小的事务超时,但我找不到默认的超时值。我也没有在hibernate文档中找到它,我知道如何更改它,但不是默认值。
这是我的hibernate配置:
<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="packagesToScan">
<list>
<value>com.test.db.entity</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.bytecode.use_reflection_optimizer">false</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.search.autoregister_listeners">false</prop>
<prop key="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</prop>
</props>
</property>
</bean>您知道使用此配置的hibernate事务的默认超时值是多少吗?
发布于 2015-09-11 22:32:22
我也有同样的例外。我用谷歌搜索了一下,发现你的问题没有答案:)
我在Weblogic控制台上的"mydomain->Configuration-> JTA“上将"Timeout Second:”从300更改为1000 (可能会增加更多,这取决于您的事务超时),或者在您的应用服务器上增加JTA超时。
然后,对于hibernate.cfg.xml,您可以检查这个答案:Hibernate/MySQL Connection Timeout
它起作用了。
https://stackoverflow.com/questions/26990090
复制相似问题