sqlite作为一种嵌入式数据库越来越受欢迎,特别是在小型的项目中,下面介绍两种spring配置sqlite数据库的方式
第一种:配置在tomcat目录下
1、在tomcat根目录下创建dbs文件夹,将sqlite文件放到该目录下(暂定为test.db)
2、在tomcat跟目录conf目录下找到context.xml文件,在<context></context>标签内添加如下内容
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- Uncomment this to disable session persistence across Tomcat restarts -->
<!--
<Manager pathname="" />
-->
<!-- Uncomment this to enable Comet connection tacking (provides events
on session expiration as well as webapp lifecycle) -->
<!--
<Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />
-->
<Resource auth="Container" description="DB Connection"
name="jdbc/sqlite"
driverClass="org.sqlite.JDBC"
jdbcUrl="jdbc:sqlite:/${catalina.home}/dbs/test.db"
maxPoolSize="10"
minPoolSize="1"
acquireIncrement="1"
idleConnectionTestPeriod="60"
preferredTestQuery="select 1"
factory="org.apache.naming.factory.BeanFactory"
type="com.mchange.v2.c3p0.ComboPooledDataSource" />
<!--<Loader delegate="true" />
-->
</Context>
3、在spring的配置文件中加上
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jdbc/sqlite" />
</bean>
配置jndi连接
第二种:将sqlite放在项目中
1、将test.db文件放到项目src目录下的dbs文件夹下
2、在spring的配置文件中加上
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="org.sqlite.JDBC" />
<property name="jdbcUrl" value="jdbc:sqlite::resource:dbs/test.db" />
<property name="initialPoolSize" value="5" />
<property name="minPoolSize" value="1" />
<property name="maxPoolSize" value="10" />
<property name="maxStatements" value="100" />
<property name="maxIdleTime" value="3600" />
<property name="acquireIncrement" value="2" />
<property name="acquireRetryAttempts" value="10" />
<property name="acquireRetryDelay" value="600" />
<property name="testConnectionOnCheckin" value="true" />
<property name="idleConnectionTestPeriod" value="1200" />
<property name="checkoutTimeout" value="10000" />
</bean>
这就完成了配置
两中方式各有各的优点和缺点,使用时请自行衡量,以上所有的前提是数据库连接驱动存在于项目中