到网上查了好多资料说是mysql8小时问题,解决方法是修改mysql5的配置文件“my.ini”中的[mysqld]后面添加上: wait_timeout=1814400
重新启动mysql5。
我照着修改了,但是还是报错,请各位高手帮忙解决一下。多谢!
重新启动mysql5。
我照着修改了,但是还是报错,请各位高手帮忙解决一下。多谢!
解决方案 »
- 问一个FEDERATED storage engine的问题
- 如何在触发器中更新同一个表中的其它记录?
- mysql的procedure里面,查询语句放在V_SQL变量里面 怎么去执行它,看它返回多少行?
- mysql4.1.4字符集问题???怎么修改
- 数据类型的问题
- 麻烦的一个MySQL查询。
- 请大家进来看看俺的MYSQL是什么问题?????
- 奇怪问题,跪求大侠指点,通宵未解决!!急
- MySQL5.6不兼容MySQL5.0的配置,我在找5.6的配置文件说明,翻了半天了,有人帮忙翻翻么?
- 初学SQL求助语句,随机取出数据库一条 table 为 2018 的数据
- 一个建立视图的问题
- 如何将一个表的列名存入另一个数据库表
属性文件:
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>