当我们需要进行SSH2整合时,可以将数据库连接的关键信息写入init.properties文件中:
下面给出一个样例文件的内容,可以参考:
datasource.type=mysql
datasource.driverClassName=com.mysql.jdbc.Driver
datasource.url=jdbc\:mysql\://database_server_ip_address/ database_name
datasource.username= username
datasource.password= password
# max active user
datasource.maxActive=10
# max idle user
datasource.maxIdle=2
# max wait time for long connection, unit is ms, 120000 ms = 120 s = 2 minute
datasource.maxWait=120000
datasource.whenExhaustedAction=1
datasource.testOnBorrow=true
datasource.testOnReturn=false
c3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=900
c3p0.minPoolSize=2
c3p0.maxPoolSize=50
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=600
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.jdbc.batch_size=25
hibernate.jdbc.fetch_size=50
hibernate.show_sql=true
hibernate.connection.release_mode=after_transaction