• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Tomcat 5.x - Cannot create PoolableConnectionFactory  RSS feed

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm having the most difficult time trying to get my web app to connect to a database (MS Access via sun.jdbc.odbc.JdbcOdbcDriver). I've registered an odbc datasource in Windows and have gotten the application to work in a command prompt. I'm pretty sure it's some sort of configuration issue, but I can't figure it out (I don't know much about Tomcat). I've extracted the JdbcOdbcDriver class file from rt.jar and placed it in a dbconn.jar file in [$CATALINA_HOME]/common/lib. The error message I get states, "Cannot create PoolableConnectionFactory."
server.xml
...

web.xml
...

...
Source code: A servlet calls a class that calls this class.

And the lovely output to the error log
12/2/2003 4:19:57 PM: 0
12/2/2003 4:19:57 PM: 1
12/2/2003 4:19:57 PM: 2
12/2/2003 4:19:57 PM: org.apache.commons.dbcp.BasicDataSource@e22f2b
12/2/2003 4:19:57 PM: 3
12/2/2003 4:19:57 PM: SQLEXception open
12/2/2003 4:19:57 PM: Cannot create PoolableConnectionFactory
12/2/2003 4:19:57 PM: SQLEXception close

Any advice would get greatly appreciated. Thanks.
 
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This worked for me on tomcat 5, not on tomcat 4!
Keith


WEB.XML

 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!