2 ddkking ddkking 于 2017.09.15 16:37 提问

javaweb中mysql的spi.SqlExceptionHelper 2C

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个回答

caozhy
caozhy   Ds   Rxr 2017.09.15 23:46
Csdn user default icon
上传中...
上传图片
插入图片