This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Tomcat and the fly likes Tomcat 6 with MS ACCESS JNDI Relative Path Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat 6 with MS ACCESS JNDI Relative Path" Watch "Tomcat 6 with MS ACCESS JNDI Relative Path" New topic

Tomcat 6 with MS ACCESS JNDI Relative Path

James Camire

Joined: Apr 17, 2008
Posts: 1
I am trying to bundle a war file with a MS access database. Everything works great, except I can't figure out how to specify the MDB file using a relative path. This means a user will have to change the context.xml file to use it on another box. My goal is to allow a user to drop the war file onto any Tomcat app server and have it work without changes.

I've tried many variations and can't get it to work.




<Resource name="weather"
url="jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=C:/Develop/webapp/MyProject/WebRoot/WEB-INF/database/weather.mdb;DriverID=22;READONLY=false}"/>

I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Tomcat 6 with MS ACCESS JNDI Relative Path
It's not a secret anymore!