Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <Context antiJARLocking="true" path="/DBConnectionPoolTest">
- <Resource name="jdbc/testdb"
- auth="Container"
- type="javax.sql.DataSource"
- username="xxx" password="xxx"
- driverclassname="com.mysql.jdbc.Driver"
- url="jdbc:mysql://xxx/myApp"
- maxactive="10"
- maxidle="4" />
- </Context>
- <?xml version="1.0" encoding="UTF-8"?>
- <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">
- <resource-ref>
- <description>DB Connection</description>
- <res-ref-name>jdbc/testdb</res-ref-name>
- <res-type>javax.sql.DataSource</res-type>
- <res-auth>Container</res-auth>
- </resource-ref>
- </web-app>
- Context initContext = new InitialContext();
- Context envContext = (Context) initContext.lookup("java:/comp/env");
- dataSource = (DataSource) envContext.lookup("jdbc/testdb");
- ...
- connection = dataSource.getConnection();
- java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql://xxx/myApp'
- t org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2065)
- at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1939)
- at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412)
- at DBPoolConnectionServlet.processRequest(DBPoolConnectionServlet.java:73)
- ...
- Caused by: java.sql.SQLException: No suitable driver
Add Comment
Please, Sign In to add comment