我收到此错误:
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的作业有一个小的事务超时,但我找不到默认超时值是什么。我在休眠文档中也没有找到它,我找到了如何更改它,但没有找到默认值。
这是我的休眠配置:
<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>
您知道使用此配置的休眠事务的默认超时值是多少吗?
我得到了同样的异常。我用谷歌搜索并找到了您的问题,没有答案:)
我将 Weblogic 控制台上的"mydomain->Configuration->JTA"上的"超时秒:"从 300 更改为 1000(可能会增加更多,这取决于您的事务超时)或增加应用程序服务器上的 JTA 超时。
然后,对于休眠.cfg.xml您可以检查此答案:休眠/MySQL 连接超时
它有效。