[jboss-user] [Beginner's Corner] - Re: h2console.war and postgreSQL

[harikris]

harikris [https://community.jboss.org/people/harikris] created the discussion

"Re: h2console.war and postgreSQL"

To view the discussion, visit: https://community.jboss.org/message/777113#777113

--------------------------------------------------------------
Hi Wolf-Dieter Fink,

I unzipped the h2console.war, edited the META-INF/MANIFEST.MF such that i now have:

Dependencies: org.postgresql,com.h2database.h2

inside it.
I then zipped it back up and deployed it.

Looks like we made some progress - i see a new error now. I am now starting to wonder if h2console.war really can only be used with H2 database due to some hardcoding in it's java class files. Can you please confirm based on your experience? Thanks a lot.

 http://localhost:8080/h2console/console/test.do?jsessionid=6dc5a70799e02ee130f5ba7965dc1a81# No suitable driver found for jdbc:postgresql://localhost:5432 08001/0
java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432
    at java.sql.DriverManager.getConnection(DriverManager.java:602)
    at java.sql.DriverManager.getConnection(DriverManager.java:154)
    at org.h2.util.JdbcUtils.getConnection(JdbcUtils.java:148)
    at org.h2.server.web.WebServer.getConnection(WebServer.java:653)
    at org.h2.server.web.WebApp.test(WebApp.java:839)
    at org.h2.server.web.WebApp.process(WebApp.java:215)
    at org.h2.server.web.WebApp.processRequest(WebApp.java:164)
    at org.h2.server.web.WebServlet.doGet(WebServlet.java:118)
    at org.h2.server.web.WebServlet.doPost(WebServlet.java:153)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
    at java.lang.Thread.run(Thread.java:680)

Unfortunately, i don't have the source code for the h2console.war to actually see if JdbcUtils.java was actually loading the driver or not.
Any input is highly appreciated.

Thanks.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/777113#777113]

Start a new discussion in Beginner's Corner at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20121119/faf82f71/attachment-0001.html