ansaurus

Question

Hibernate+PostgreSQL throws JDBCConnectionException: Cannot open connection

Answer 1

+1 A:

What's the question here?

The exception is pretty explicit:

org.hibernate.exception.JDBCConnectionException: Cannot open connection

Make sure you can connect to the database you are connected to, that the configuration is correct, that you do not have network issues preventing the connection, etc.

matt b 2010-06-18 15:42:10

But I configure hibernate cfg.xml llike that; <property name="hibernate.connection.driver_class">org.postgresql.Driver</property> <property name="hibernate.connection.password">1234</property> <property name="hibernate.connection.url">jdbc:postgresql://localhost/postgres</property> <property name="hibernate.connection.username">postgres</property> <property name="hibernate.default_schema">public</property> <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>

Omer Salmanoglu 2010-06-18 15:43:56

Ok, and do you have a postgres database running on localhost at the default port, and does it have a database named postgres, and does it have a user named postgres with a password named postgres?

matt b 2010-06-18 15:56:32

Yes There is a database which is name postgres and is used default portThis db have a user which is name postgres and its pass = '1234'

Omer Salmanoglu 2010-06-18 16:05:18

Answer 2

A:

I didn't look at your config file, but I'm assuming it configured at least reasonably well since the stack trace indicates that it is trying to connect to a postgres database at a localhost JDBC url.

It looks like the big problem is that it can't find the postgres JDBC driver:

root cause

java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost/postgres java.sql.DriverManager.getConnection(Unknown Source) java.sql.DriverManager.getConnection(Unknown Source) org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)

Make sure the JAR file is in your classpath. You can download it here, if you don't already have it: http://jdbc.postgresql.org/

Jeff 2010-06-18 16:02:07

I write a test Java app and it works right but I think that this Web application have a problem. And I control JDBC driver and it is right

Omer Salmanoglu 2010-06-18 16:07:32

Answer 3

+2 A:

When encountering an exception, it's worth to check the bottommost root cause in the stacktrace. In this case it's the following:

java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost/postgres

This just means that either the URL is wrong or that the desired driver is not present in the current runtime classpath. Since the URL looks fine as per the PostgreSQL JDBC documentation, it'll be that the driver is missing in the current runtime classpath.

So, to fix this problem, you need put the JDBC driver JAR file in the webapp's runtime classpath. The /WEB-INF/lib is one of the folders which is covered by the webapp's default runtime classpath. Just drop the PostgreSQL JDBC driver JAR file in there and redeploy.

BalusC 2010-06-18 16:39:57

The Driver path is already /WEB-INF/lib but same problem continues

Omer Salmanoglu 2010-06-18 17:18:28

Apparently a different classloader is been used. Try putting in `Tomcat/lib` or adding JAR file's root path to `shared.loader` in `Tomcat/conf/catalina.properties`.

BalusC 2010-06-18 17:24:39

ansaurus

tags:

views:

answers:

Hibernate+PostgreSQL throws JDBCConnectionException: Cannot open connection

related questions