SQLite Resource Template

context.xml

<Context>
<Resource
	name="jdbc/example"
	auth="Container"
	driverClassName="org.sqlite.JDBC"
	initialSize="0"
	maxActive="15"
	maxIdle="3"
	minIdle="0"
	maxWait="-1"
	validationQuery="SELECT 1"
	connectionInitSqls="PRAGMA foreign_keys = ON"
	testOnBorrow="true"
	removeAbandoned="true"
	removeAbandonedTimeout="60"
	username="username"
	password="password"
	type="javax.sql.DataSource"
	url="jdbc:sqlite:/path/to/sqlite/file/example.db"/>
</Context>