spring+mybatis+sqlite(dbcp做连接池)

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<propertyname="driverClassName"value="${db.driverClassName}"/>

<propertyname="url"value="${db.url}"/>

<propertyname="username"value="${db.username}"/>

<propertyname="password"value="${db.password}"/>

<propertyname="initialSize"value="10"/>

<propertyname="maxActive"value="100"/>

<propertyname="maxIdle"value="100"/>

<propertyname="poolPreparedStatements"value="true"/>

</bean>

<beanid="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">

<propertyname="dataSource"ref="dataSource"/>

<propertyname="configLocation"value="classpath:mybatis/mybatis-config.xml"></property>

</bean>

app.home=D:/soft/sqlite/db

db.dir=D:/soft/sqlite/db/kserver.db

db.driverClassName=org.sqlite.JDBC

db.name=kserver.db

db.url=jdbc:sqlite:D:/soft/sqlite/db/kserver.db

db.username=

db.password=

错误：

Cause: java.sql.SQLException: not implemented by SQLite JDBC driver; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; not implemented by SQLite JDBC driver; nested exception is java.sql.SQLException: not implemented by SQLite JDBC driver

有的属性不支持，如： private BigDecimal workFactor;

java.sql.BatchUpdateException: batch entry 0: [SQLITE_ERROR] SQL error or missing database (near "=": syntax error)

db.username=root（不能为空）

db.password=root（不能为空）