开发者

Accessing SQLite in Java Webapp

开发者 https://www.devze.com 2023-04-12 15:33 出处:网络
I am trying to access sqlite.db file in 开发者_如何学Gomy java web app. i can access it with absolute path, but now i want to access it with my webapps relative path.

I am trying to access sqlite.db file in 开发者_如何学Gomy java web app. i can access it with absolute path, but now i want to access it with my webapps relative path. My context.xml looks like

<Context antiJARLocking="true" path="/webappServer">
    <Resource name="jdbc/myDB" auth="Container" 
    type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="1000"
    driverClassName="org.sqlite.JDBC"
    url="jdbc:sqlite:/db/sqlite.db" />
</Context>

and i call for the connection in my java class

Context initContext = new InitialContext();
Context envContext  = (Context) initContext.lookup("java:/comp/env");
DataSource ds = (DataSource) envContext.lookup("jdbc/myDB");
Connection conn = ds.getConnection();

my sqlite location is in C:\db\sqlite.db but now i want to move it so i can call my sqlite connection with something like localhost/mysqlite.db is it possible ? what should i do to achieve it ?

Thanks !

P.S. Im new to java web app. so any help will be very useful


There are 2 different ways of doing so:

  1. Define the datasource outside your webapps Context.xml inside Tomcat's own Context.xml and modify it according to the needs of the different servers. One-time configuration on each server required.
  2. Solve the problem during your build process. Create different Context.xml files for all the environments you need, e.g. Context_prod.xml. During the build process identify the file you need and place it in your webapp.

Those are the 2 approaches I am aware of.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号