ddkking
ddkking
2017-09-15 08:37

javaweb中mysql的spi.SqlExceptionHelper

2
  • java
  • mysql
  • hibernate

spi.SqlExceptionHelper: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource defaultDatasource in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4SuspendableXAConnection@38723fd8 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@5823b403

配置信息
database.type=mysql
jdbc.className=com.mysql.jdbc.Driver

jdbc.pinGlobalTxToPhysicalConnection=true
jdbc.xa.driver-class=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource

dhcp config

dhcp.initialSize=2
dhcp.logAbandoned=true
dhcp.maxActive=300
dhcp.maxIdle=100
dhcp.maxWait=10000
dhcp.minEvictableIdleTimeMillis=1800000
dhcp.minIdle=10
dhcp.removeAbandoned=true
dhcp.removeAbandonedTimeout=60
dhcp.testOnBorrow=true
dhcp.testWhileIdle=true
dhcp.timeBetweenEvictionRunsMillis=1800000
dhcp.validationQuery=select 1

hibernate config

hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
hibernate.cache.use_query_cache=false
hibernate.cache.use_second_level_cache=false
#hibernate.dialect=org.hibernate.dialect.MySQLDialect
#hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.dialect=com.sugon.wuxi.database.transaction.dialect.MySql5InnoDBDialect
hibernate.hbm2ddl.auto=update
hibernate.show_sql=false
hibernate.format_sql=true
hibernate.connection.release_mode=auto
hibernate.useTransactionAwareDataSource=true
hibernate.transaction.factory_class=org.hibernate.engine.transaction.internal.jta.JtaTransactionFactory
hibernate.transaction.manager_lookup_class=com.sugon.dboperation.service.hibernate.transaction.HibernateTransactionManagerLookup
hibernate.current_session_context_class=jta

有没有神一样的人物能提供点帮助

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答