Results 1 to 7 of 7
- 01-20-2010, 02:53 AM #1
Senior Member
- Join Date
- Jan 2010
- Posts
- 138
- Rep Power
- 0
- 01-20-2010, 09:06 AM #2
Senior Member
- Join Date
- Jun 2008
- Posts
- 2,568
- Rep Power
- 14
There is only one Type 4.0 (I.E. Java only driver, which is not, or at least not supposed to be, a simple proxy) JDBC Driver for MS Access (by HXTT or something like that, so Google that), and is not free. You would be much better off using a different database. If it must be an "embedded" DB than look into Apache Derby (I.E. JavaDB which is distributed bundled with JDK 6).
- 01-20-2010, 10:15 AM #3
Senior Member
- Join Date
- Jan 2010
- Posts
- 138
- Rep Power
- 0
Hi, I need to use portable database, could you please advise what database should I use (readable on Windows & Linux) ..
derby is database server and it's not portable ..right? (pls correct me if I'm wrong)
thanks & regards
- 01-20-2010, 10:18 AM #4
Senior Member
- Join Date
- Jun 2008
- Posts
- 2,568
- Rep Power
- 14
It can be run in server/client mode. It does not need to be, and, is most often used in "embedded" mode (i.e. not a server). And, seeing as how it is a DB that is implemented completely in Java, it is the most portable DB you're going to find, which MS Access definately is not. That you need to use it on Linux eliminates MS Access from your possibilites anyway.
- 01-20-2010, 11:00 AM #5
Senior Member
- Join Date
- Jan 2010
- Posts
- 138
- Rep Power
- 0
noted with thanks, I will try derby now ;>)
- 01-20-2010, 05:10 PM #6
Senior Member
- Join Date
- Jan 2010
- Posts
- 138
- Rep Power
- 0
btw, how to distribute my db? .. or I just copy the database folder?
- 01-20-2010, 06:28 PM #7
Senior Member
- Join Date
- Jun 2008
- Posts
- 2,568
- Rep Power
- 14
Do need to deliver actual data or just the structure? If just the structure, don't bother. Write a small set of classes that create the tables and the like, and on program start simply get a connection, use DatabaseMetaData and see if the tables are there, and if not create them.
If you need to deliver data, then, yes, just deliver the entire directory (make sure its not in use when you zip it, though), but make that the program is configured properly (as its location is liable to change, of course).
Similar Threads
-
Default Access (package access) confusion
By gauravrajbehl in forum New To JavaReplies: 1Last Post: 11-18-2009, 11:48 AM -
Method access or field access
By carderne in forum New To JavaReplies: 2Last Post: 12-06-2008, 07:20 PM -
ms access jdbc query problem
By Fleur in forum New To JavaReplies: 2Last Post: 04-30-2008, 07:55 PM -
How to use JDBC Template classes to control basic JDBC processing and error handling
By Java Tip in forum Java TipReplies: 0Last Post: 04-01-2008, 11:17 AM -
How to use JDBC Template classes to control basic JDBC processing and error handling
By JavaBean in forum Java TipReplies: 0Last Post: 09-28-2007, 01:56 PM
Bookmarks