Advertisement
Guest User

Untitled

a guest
Aug 8th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.94 KB | None | 0 0
  1. // context.xml
  2. /*
  3. <?xml version="1.0" encoding="UTF-8"?>
  4. <Context antiJARLocking="true" path="/MyServlet">
  5.     <Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"
  6.         maxActive="100" maxIdle="30" maxWait="10000"
  7.         username="" password="" driverClassName="org.sqlite.JDBC"
  8.         url="jdbc:sqlite:web/mydb.db"/>
  9. </Context>
  10. */
  11.  
  12. // DBConnect.java
  13. public class DBConnect() {
  14.   public DBConnect() {
  15.     try {
  16.       Context ctx = new InitialContext();
  17.       DataSource ds = (javax.sql.DataSource) ctx.lookup("java:comp/env/jdbc/mydb");
  18.  
  19.       Connection conn = ds.getConnection();
  20.  
  21.       Statement stmt = conn.createStatement();
  22.     } catch (SQLException e) {
  23.       System.out.println(e.toString());
  24.     } catch (Exception e) {
  25.       System.out.println(e.toString());
  26.     }
  27.   }
  28. }
  29.  
  30. // Tomcat error that I get
  31. // org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.sqlite.JDBC'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement