Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1216
  • Last Modified:

Servlet Hibernate - java.sql.SQLException: No suitable driver found for org.postgresql.Driver

Hi,

I new at Hibernate and I wrote a littel test application in Ecplipse to test and learn how Hibernate works. This small program works well and Hibernate could find org.postgres.Driver and is reading and writing to the database correct.

Then when I try to test my code in a servlet it can't find the Postgres driver.

I get the following error:
2010-nov-26 07:16:35 org.hibernate.cfg.Configuration applyHibernateValidatorLegacyConstraintsOnDDL
INFO: Hibernate Validator not found: ignoring
2010-nov-26 07:16:35 org.hibernate.cfg.search.HibernateSearchEventListenerRegister enableHibernateSearch
INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
2010-nov-26 07:16:35 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
2010-nov-26 07:16:35 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
2010-nov-26 07:16:35 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
2010-nov-26 07:16:35 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: org.postgresql.Driver at URL: org.postgresql.Driver
2010-nov-26 07:16:35 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=postgres, password=****}
2010-nov-26 07:16:35 org.hibernate.cfg.SettingsFactory buildSettings
VARNING: Could not obtain connection to query metadata
java.sql.SQLException: No suitable driver found for org.postgresql.Driver
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)
        at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2833)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2829)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1840)
        at se.bostadsforsaljning.managers.HibernateManager.<init>(HibernateManager.java:62)
        at se.bostadsforsaljning.server.Server.processRequest(Server.java:103)
        at se.bostadsforsaljning.server.Server.doPost(Server.java:83)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        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:298)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)

The driver i using for Postgres i postgresql-8.4-701.jdbc4.jar.

How do I solve this issue?

0
freeOne
Asked:
freeOne
  • 5
  • 3
1 Solution
 
objectsCommented:
you need to add the driver jar to your container by adding the jat to tomcats lib directory
0
 
freeOneAuthor Commented:
I have put the jar file in:

...\apache-tomcat-6.0.28\lib

But, even if its there it is not working....
0
 
freeOneAuthor Commented:
The driver I'm using is postgresql-8.4-701.jdbc4.jar.

I have tried to put it in the above given folder and under the sites WEB_INF/lib

But nothinng works.

Any idée what i should do?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
objectsCommented:
is the class it is looking for in that jar?
0
 
freeOneAuthor Commented:
Yes, it is there...

I have tried both and postgresql-8.4-701.jdbc4.jar and postgresql-9.0-801.jdbc3.jar

in the folders:
...\apache-tomcat-6.0.28\lib
...\WEB_INF/lib

and Hibernate can't find it anny were.
0
 
objectsCommented:
whats your connection string?
0
 
freeOneAuthor Commented:
Thanks alot for your help.

It was the connection string that was wrong. When I changed it to the correct one it worked perfectly with all verions mentioned above.
0
 
freeOneAuthor Commented:
Thanks a lot
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now