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 JDBC and Relational Databases and the fly likes Deploy MS Access DB on Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Deploy MS Access DB on Server" Watch "Deploy MS Access DB on Server" New topic

Deploy MS Access DB on Server

De La Hai

Joined: Jun 04, 2008
Posts: 11
Hello !

I am trying to deploy a *.mdb file along my ear-project on the glassfish server. But I have no clue how to do it ... . Obviously just hanging the mdb-file to the ear-project // ejb project doesn't work.

Can someone tell me what is the general method to deploy a MS Access Database along with your EAR-Project ?

Unfortunately I need to use MS Access....
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
MDB files are just that: files. Have you encountered problems when you tried using them from someplace on the server? And yes, they won't work inside of war/ear files.
De La Hai

Joined: Jun 04, 2008
Posts: 11

My Server is Glassfish v2 can you tell me where I can put my DB file ? In which Folder can I put my file in order to read it from my EJB ? or is it even possible to read it from the EJB ? or is the EJB (SFSB) bound in anyway to a namespace on the server ?

This is the code which is called from my SFSB ... for this instance , where do I have to put my DB.file on ?

Thanks in advance
De La Hai

Joined: Jun 04, 2008
Posts: 11
okok , I have noticed my misunderstanding ... :p ... nevermind my stupid posts ;)
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: Deploy MS Access DB on Server
jQuery in Action, 3rd edition