Guest User

Untitled

a guest
Nov 21st, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <Context antiJARLocking="true" path="/DBConnectionPoolTest">
  3. <Resource name="jdbc/testdb"
  4. auth="Container"
  5. type="javax.sql.DataSource"
  6. username="xxx" password="xxx"
  7. driverclassname="com.mysql.jdbc.Driver"
  8. url="jdbc:mysql://xxx/myApp"
  9. maxactive="10"
  10. maxidle="4" />
  11. </Context>
  12.  
  13. <?xml version="1.0" encoding="UTF-8"?>
  14. <web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">
  15. <resource-ref>
  16. <description>DB Connection</description>
  17. <res-ref-name>jdbc/testdb</res-ref-name>
  18. <res-type>javax.sql.DataSource</res-type>
  19. <res-auth>Container</res-auth>
  20. </resource-ref>
  21. </web-app>
  22.  
  23. Context initContext = new InitialContext();
  24. Context envContext = (Context) initContext.lookup("java:/comp/env");
  25. dataSource = (DataSource) envContext.lookup("jdbc/testdb");
  26. ...
  27. connection = dataSource.getConnection();
  28.  
  29. java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql://xxx/myApp'
  30. t org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2065)
  31. at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1939)
  32. at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412)
  33. at DBPoolConnectionServlet.processRequest(DBPoolConnectionServlet.java:73)
  34. ...
  35. Caused by: java.sql.SQLException: No suitable driver
Add Comment
Please, Sign In to add comment