title: Accessing SQLite in Java Webapp
body: <p>I am trying to access sqlite.db file in my 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</p>
  
  <pre><code>&lt;Context antiJARLocking="true" path="/webappServer"&gt;
      &lt;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" /&gt;
  &lt;/Context&gt;
  </code></pre>
  
  <p>and i call for the connection in my java class</p>
  
  <pre><code>Context initContext = new InitialContext();
  Context envContext  = (Context) initContext.lookup("java:/comp/env");
  DataSource ds = (DataSource) envContext.lookup("jdbc/myDB");
  Connection conn = ds.getConnection();
  </code></pre>
  
  <p>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 ?</p>
  
  <p>Thanks !</p>
  
  <p>P.S. Im new to java web app. so any help will be very useful</p>