<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: h2console.war and postgreSQL
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/harikris">harikris</a> in <i>Beginner's Corner</i> - <a href="https://community.jboss.org/message/777113#777113">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi Wolf-Dieter Fink,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I unzipped the h2console.war, edited the META-INF/MANIFEST.MF such that i now have:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Dependencies: org.postgresql,com.h2database.h2</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>inside it.</p><p>I then zipped it back up and deployed it.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>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.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><a class="jive-link-external-small" href="http://localhost:8080/h2console/console/test.do?jsessionid=6dc5a70799e02ee130f5ba7965dc1a81#">No suitable driver found for jdbc:postgresql://localhost:5432</a><span style="color: #ff0000; font-family: Arial, sans-serif; font-size: 12px;"> 08001/0</span><span id="st0" style="color: #ff0000; font-family: Arial, sans-serif; font-size: 12px;"><br/>java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432<br/>    at java.sql.DriverManager.getConnection(DriverManager.java:602)<br/>    at java.sql.DriverManager.getConnection(DriverManager.java:154)<br/>    at org.h2.util.JdbcUtils.getConnection(JdbcUtils.java:148)<br/>    at org.h2.server.web.WebServer.getConnection(WebServer.java:653)<br/>    at org.h2.server.web.WebApp.test(WebApp.java:839)<br/>    at org.h2.server.web.WebApp.process(WebApp.java:215)<br/>    at org.h2.server.web.WebApp.processRequest(WebApp.java:164)<br/>    at org.h2.server.web.WebServlet.doGet(WebServlet.java:118)<br/>    at org.h2.server.web.WebServlet.doPost(WebServlet.java:153)<br/>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)<br/>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)<br/>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)<br/>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)<br/>    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)<br/>    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)<br/>    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)<br/>    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br/>    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br/>    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)<br/>    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)<br/>    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)<br/>    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)<br/>    at java.lang.Thread.run(Thread.java:680)</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>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.</p><p>Any input is highly appreciated.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/777113#777113">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Beginner's Corner at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>