配置文件
- 名称必须为c3p0-config.xml,否则找不到;
- 标签名称
<c3p0-config>
<default-config >
具体配置内容
</default-config>
</c3p0-config>
一般按照上述配置即可,如果有多个数据库可以使用标签,在创建ComboPooledDataSource对象时,把config名称"xxx"传递给构造函数即可。
sqlite配置参考
<named-config name = "sqlite" >
<property name="jdbcUrl">jdbc:sqlite:db_save_path</property>
<property name="driverClass">org.sqlite.JDBC</property>
<span class="hljs-tag"><<span class="hljs-name">property</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"checkoutTimeout"</span>></span>30000<span class="hljs-tag"></<span class="hljs-name">property</span>></span>
<span class="hljs-tag"><<span class="hljs-name">property</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"idleConnectionTestPeriod"</span>></span>30<span class="hljs-tag"></<span class="hljs-name">property</span>></span>
<span class="hljs-tag"><<span class="hljs-name">property</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"initialPoolSize"</span>></span>10<span class="hljs-tag"></<span class="hljs-name">property</span>></span>
<span class="hljs-tag"><<span class="hljs-name">property</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"maxIdleTime"</span>></span>30<span class="hljs-tag"></<span class="hljs-name">property</span>></span>
<span class="hljs-tag"><<span class="hljs-name">property</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"maxPoolSize"</span>></span>10<span class="hljs-tag"></<span class="hljs-name">property</span>></span>
<span class="hljs-tag"><<span class="hljs-name">property</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"maxStatements"</span>></span>200<span class="hljs-tag"></<span class="hljs-name">property</span>></span>