com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException 到网上查了好多资料说是mysql8小时问题,解决方法是修改mysql5的配置文件“my.ini”中的[mysqld]后面添加上: wait_timeout=1814400 重新启动mysql5。 我照着修改了,但是还是报错,请各位高手帮忙解决一下。多谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我用了c3p0连接池,下面是我的配置,麻烦帮忙看一下,有什么问题吗?属性文件:datasource.type=mysql#sqlserverdatasource.driverClassName=org.gjt.mm.mysql.Driver#com.microsoft.sqlserver.jdbc.SQLServerDriverdatasource.url=jdbc:mysql://localhost:3306/shose?useUnicode=true&characterEncoding=UTF-8#jdbc:sqlserver://localhost:1433;DatabaseName=shosedatasource.username=root#bbs_managedatasource.password=rootdatasource.maxActive=20datasource.maxIdle=4datasource.maxWait=120000datasource.whenExhaustedAction=1datasource.validationQuery=select 1 from dualdatasource.testOnBorrow=truedatasource.testOnReturn=falsec3p0.acquireIncrement=6c3p0.acquireRetryAttempts=30 c3p0.acquireRetryDelay=30000 c3p0.autoCommitOnClose=falsec3p0.breakAfterAcquireFailure=falsec3p0.initialPoolSize=20c3p0.minPoolSize=10c3p0.maxPoolSize=250c3p0.maxStatements=200c3p0.numHelperThreads=20c3p0.maxIdleTime=600c3p0.idleConnectionTestPeriod=900c3p0.preferredTestQuery=select 1 from dualc3p0.testConnectionOnCheckin=truec3p0.testConnectionOnCheckout=false#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialecthibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect#hibernate.dialect=org.hibernate.dialect.SQLServerDialecthibernate.jdbc.batch_size=25hibernate.jdbc.fetch_size=50hibernate.show_sql=falsehibernate.connection.release_mode=after_transactionhibernate.autoReconnect=truezengzhi.isloadconfig=falsezengzhi.safePath=e:/safe/cache.config=oscache.propertiescacheus.config=oscache_us.propertiescacheup.config=oscache_up.propertiescachefl.config=oscache_fl.propertiescachelist.config=oscache_list.propertiescachepost.config=oscache_post.properties==========================================================================spring配置<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd"><beans> <bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location"> <value>classpath:init.properties</value> </property> </bean> <bean id="dataSourceTarget" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" dependency-check="none"> <property name="driverClass"> <value>${datasource.driverClassName}</value> </property> <property name="jdbcUrl"> <value>${datasource.url}</value> </property> <property name="user"> <value>${datasource.username}</value> </property> <property name="password"> <value>${datasource.password}</value> </property> <property name="acquireIncrement"> <value>${c3p0.acquireIncrement}</value> </property> <property name="initialPoolSize"> <value>${c3p0.initialPoolSize}</value> </property> <property name="minPoolSize"> <value>${c3p0.minPoolSize}</value> </property> <property name="maxPoolSize"> <value>${c3p0.maxPoolSize}</value> </property> <property name="maxIdleTime"> <value>${c3p0.maxIdleTime}</value> </property> <property name="idleConnectionTestPeriod"> <value>${c3p0.idleConnectionTestPeriod}</value> </property> <property name="maxStatements"> <value>${c3p0.maxStatements}</value> </property> <property name="numHelperThreads"> <value>${c3p0.numHelperThreads}</value> </property> <property name="preferredTestQuery"> <value>${c3p0.preferredTestQuery}</value> </property> <property name="testConnectionOnCheckin"> <value>${c3p0.testConnectionOnCheckin}</value> </property> <property name="testConnectionOnCheckout"> <value>${c3p0.testConnectionOnCheckout}</value> </property> <property name="acquireRetryAttempts"> <value>${c3p0.acquireRetryAttempts}</value> </property> <property name="acquireRetryDelay"> <value>${c3p0.acquireRetryDelay}</value> </property> <property name="breakAfterAcquireFailure"> <value>${c3p0.breakAfterAcquireFailure}</value> </property> <property name="autoCommitOnClose"> <value>${c3p0.autoCommitOnClose}</value> </property> </bean></beans> 收藏 求助mssql存储过程转化为mysql存储过程,小弟急啊!100分双手奉上 mysql 中怎样实现这样需求的存储过程 1067的错误。Mysql5.1的安装。 [急]怎么样查询才能每个关键字出来一条新闻? 如何設置默認值為當前日期? 为什么mysql事务执行不了? 把用select查询出来的结果怎样再数据插入到一张新表中? 求个简单的mysql查询 Qt连接mysql数据库,执行QSQLQuery执行语句的时候程序崩溃 SQLyog连接mysql错误号2003 一个建立视图的问题 如何将一个表的列名存入另一个数据库表
属性文件:
datasource.type=mysql
#sqlserver
datasource.driverClassName=org.gjt.mm.mysql.Driver
#com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.url=jdbc:mysql://localhost:3306/shose?useUnicode=true&characterEncoding=UTF-8
#jdbc:sqlserver://localhost:1433;DatabaseName=shose
datasource.username=root
#bbs_manage
datasource.password=rootdatasource.maxActive=20
datasource.maxIdle=4
datasource.maxWait=120000
datasource.whenExhaustedAction=1
datasource.validationQuery=select 1 from dual
datasource.testOnBorrow=true
datasource.testOnReturn=falsec3p0.acquireIncrement=6
c3p0.acquireRetryAttempts=30
c3p0.acquireRetryDelay=30000
c3p0.autoCommitOnClose=false
c3p0.breakAfterAcquireFailure=false
c3p0.initialPoolSize=20
c3p0.minPoolSize=10
c3p0.maxPoolSize=250
c3p0.maxStatements=200
c3p0.numHelperThreads=20
c3p0.maxIdleTime=600
c3p0.idleConnectionTestPeriod=900
c3p0.preferredTestQuery=select 1 from dual
c3p0.testConnectionOnCheckin=true
c3p0.testConnectionOnCheckout=false#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
#hibernate.dialect=org.hibernate.dialect.SQLServerDialecthibernate.jdbc.batch_size=25
hibernate.jdbc.fetch_size=50
hibernate.show_sql=false
hibernate.connection.release_mode=after_transaction
hibernate.autoReconnect=truezengzhi.isloadconfig=false
zengzhi.safePath=e:/safe/cache.config=oscache.properties
cacheus.config=oscache_us.properties
cacheup.config=oscache_up.properties
cachefl.config=oscache_fl.properties
cachelist.config=oscache_list.properties
cachepost.config=oscache_post.properties
==========================================================================
spring配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans>
<bean id="placeholderConfig"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>classpath:init.properties</value>
</property>
</bean>
<bean id="dataSourceTarget" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close" dependency-check="none">
<property name="driverClass">
<value>${datasource.driverClassName}</value>
</property>
<property name="jdbcUrl">
<value>${datasource.url}</value>
</property>
<property name="user">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>
<property name="acquireIncrement">
<value>${c3p0.acquireIncrement}</value>
</property>
<property name="initialPoolSize">
<value>${c3p0.initialPoolSize}</value>
</property>
<property name="minPoolSize">
<value>${c3p0.minPoolSize}</value>
</property>
<property name="maxPoolSize">
<value>${c3p0.maxPoolSize}</value>
</property>
<property name="maxIdleTime">
<value>${c3p0.maxIdleTime}</value>
</property>
<property name="idleConnectionTestPeriod">
<value>${c3p0.idleConnectionTestPeriod}</value>
</property>
<property name="maxStatements">
<value>${c3p0.maxStatements}</value>
</property>
<property name="numHelperThreads">
<value>${c3p0.numHelperThreads}</value>
</property>
<property name="preferredTestQuery">
<value>${c3p0.preferredTestQuery}</value>
</property>
<property name="testConnectionOnCheckin">
<value>${c3p0.testConnectionOnCheckin}</value>
</property>
<property name="testConnectionOnCheckout">
<value>${c3p0.testConnectionOnCheckout}</value>
</property>
<property name="acquireRetryAttempts">
<value>${c3p0.acquireRetryAttempts}</value>
</property>
<property name="acquireRetryDelay">
<value>${c3p0.acquireRetryDelay}</value>
</property>
<property name="breakAfterAcquireFailure">
<value>${c3p0.breakAfterAcquireFailure}</value>
</property>
<property name="autoCommitOnClose">
<value>${c3p0.autoCommitOnClose}</value>
</property>
</bean>
</beans>