• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Postgres driver: there, then not?

 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
So when i navigate to a certain page in an application at work I get:

Caused by: com.opensymphony.workflow.StoreException: Error creating new workflow instance: root cause: Cannot load JDBC driver class 'org.postgresql.Driver'
Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver

This happens both when I try to run it standalone and under Eclipse.
Here are the weird things:
1. Seems to be a new problem pretty sure I used this screen before
2. Other operations that I KNOW accessed the Postgres database (as a test I created a user, and then saw the updated user table through pgAdmin) are working fine
3. I have the .jar (postgresql-8.3-603.jdbc4.jar) in the properties buildpath for the Project along with its location in WEB-INF/lib, when I deploy straight to Tomcat I see it in the exploded war's WEB-INF/lib , and when I crack open the jar I see “org/postgresql/Driver.class” – the class required seems to be there (as a possibly related note, it actually was showing up twice in the build path properties for the project, I removed one in case being there twice was a problem but it didn’t help or hurt things)

Any suggestions on what to try?
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Are you using container-managed pooling? If so, the jar needs to be in Tomcat's lib folder (Tomcat6) or common/lib (Tomcat5).
 
kirk israel
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Jeez, I think that was it! Thanks for the quick response!
 
Onion rings are vegetable donuts. Taste this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic