尝试
//put the imports where they really go, obvIoUsly...
import javax.sql.*;
import org.sqlite.*;
import com.mchange.v2.c3p0.*;
// configure sqlite
sqliteConfig config = new org.sqlite.sqliteConfig();
config.setReadOnly(true);
config.setPageSize(4096); //in bytes
config.setCacheSize(2000); //number of pages
config.setSynchronous(sqliteConfig.SynchronousMode.OFF);
config.setJournalMode(sqliteConfig.JournalMode.OFF);
// get an unpooled sqlite DataSource with the desired configuration
sqliteDataSource unpooled = new sqliteDataSource( config );
// get a pooled c3p0 DataSource that wraps the unpooled sqlite DataSource
DataSource pooled = DataSources.pooledDataSource( unpooled );
pooled
现在,数据源将是c3p0 PooledDataSource,它包装了已根据需要配置的sqlite未池化数据源。
请参阅C3P0的文档,“使用数据源工厂类”,并为api文档数据源工厂类。