Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.26 KB | None | 0 0
  1. Context ctx = new InitialContext();
  2. DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/jaikoz");
  3.  
  4. getDataSource.getConnection()
  5.  
  6. org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
  7. at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
  8. at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
  9. at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  10. at com.jthink.appserver.jaikoz.util.db.DBManager.getConnection(DBManager.java:92)
  11. com.jthink.appserver.jaikoz.action.Check.handleRequest(CheckVersion2.java:145)
  12. at com.jthink.appserver.jaikoz.Session.run(Session.java:66)
  13. at com.jthink.appserver.jaikoz.Controller.doTask(Controller.java:68)
  14. at com.jthink.appserver.jaikoz.Controller.doGet(Controller.java:61)
  15. at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
  16. at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
  17. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  18. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  19. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  20. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  21. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  22. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
  23. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
  24. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
  25. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  26. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
  27. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
  28. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
  29. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
  30. at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
  31. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
  32. at java.lang.Thread.run(Thread.java:619)
  33. Caused by: java.lang.NullPointerException
  34. at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
  35. at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
  36. at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
  37. at java.sql.DriverManager.getDriver(DriverManager.java:253)
  38. at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
  39.  
  40. Copy all webapps from tomcat5 to tomcat7
  41. Copy jaikoz.xml file from Conf/Catalina/localhost to tomcat7
  42. Copy common/lib/mysql-connector-java-3.1.4-beta-bin.jar into webapps/jaikoz/WEB-INF/lib
  43.  
  44. <Context path="/jaikoz" displayname="jaikoz" docBase="../webapps/jaikoz" debug="0" privileged="true">
  45.  
  46. <Resource name="jdbc/jaikoz"
  47. auth="Container"
  48. type="javax.sql.DataSource"/>
  49.  
  50. <ResourceParams name="jdbc/jaikoz">
  51. <parameter>
  52. <name>factory</name>
  53. <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  54. </parameter>
  55.  
  56. <!-- Maximum number of dB connections in pool. Make sure you
  57. configure your mysqld max_connections large enough to handle
  58. all of your db connections. Set to 0 for no limit.
  59. -->
  60. <parameter>
  61. <name>maxActive</name>
  62. <value>0</value>
  63. </parameter>
  64.  
  65. <!-- Maximum number of idle dB connections to retain in pool.
  66. Set to 0 for no limit.
  67. -->
  68. <parameter>
  69. <name>maxIdle</name>
  70. <value>0</value>
  71. </parameter>
  72.  
  73. <!-- Maximum time to wait for a dB connection to become available
  74. in ms, in this example 10 seconds. An Exception is thrown if
  75. this timeout is exceeded. Set to -1 to wait indefinitely.
  76. -->
  77. <parameter>
  78. <name>maxWait</name>
  79. <value>10000</value>
  80. </parameter>
  81.  
  82. <!-- MySQL dB username and password for dB connections -->
  83. <parameter>
  84. <name>username</name>
  85. <value>********</value>
  86. </parameter>
  87.  
  88. <parameter>
  89. <name>password</name>
  90. <value>**********</value>
  91. </parameter>
  92.  
  93. <!-- Class name for mm.mysql JDBC driver -->
  94. <parameter>
  95. <name>driverClassName</name>
  96. <value>com.mysql.jdbc.Driver</value>
  97. </parameter>
  98.  
  99. <!-- The JDBC connection url for connecting to your MySQL dB.
  100. The autoReconnect=true argument to the url makes sure that the
  101. mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
  102. connection. mysqld by default closes idle connections after 8 hours.
  103. -->
  104. <parameter>
  105. <name>url</name>
  106. <value>jdbc:mysql://localhost:3306/jaikoz?autoReconnect=true</value>
  107. </parameter>
  108. </ResourceParams>
  109.  
  110. </Context>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement