Skip to content

Instantly share code, notes, and snippets.

@Surechun
Surechun / gist:5727748
Last active December 18, 2015 04:49
Mybatis&c3p0 error msg.
exception in thread "Timer-0" org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 50, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> c3p0_test, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> intergalactoApp, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge9mc8v8715f23uaf6u|859a68, idleConnectionTestPeriod -> 360, initialPoolSize -> 20, jdbcUrl -> jdbc:mysql://test1.company.com:3306/crawling?useUnicode=true&characterEncoding=UTF8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 7200, maxIdleTimeExcessConnections -
@Surechun
Surechun / mybatis-config.xml
Created June 7, 2013 08:37
mybatis-config.xml
<!--ignore-->
<mappers>
<mapper resource="example/spy/core/mapper/PubMapper.xml" />
<mapper resource="example/spy/core/mapper/StatisticMapper.xml" />
<mapper resource="example/spy/core/mapper/PostUpdateLogMapper.xml" />
<mapper resource="example/spy/core/mapper/ParseLogMapper.xml" />
<mapper resource="example/spy/core/mapper/CrawlerReportMapper.xml" />
<mapper resource="example/spy/core/mapper/ArticleEventMapper.xml" />
<mapper resource="example/spy/core/mapper/ListingEventMapper.xml" />
<mapper resource="example/spy/core/mapper/CrawlerEventMapper.xml" />
@Surechun
Surechun / SessionFactory.java
Created June 7, 2013 08:43
SessionFactory.java
package example.data.common;
import java.io.IOException;
import java.io.Reader;
import java.nio.charset.Charset;
import java.sql.Connection;
import java.util.List;
import java.util.Map;