very large database
[225 byte] By [ConlonP] at [2007-9-26 3:17:14] 
I'm currently writing a program to interface with a 200MB database. The program has to connect to just a file, no server can be involved. Is there a JDBC driver to connect to an access file? just the .mdb file.
Huh? You never connect to a server when accessing a MS Access database. (Unless you use a proxy driver but that isn't connecting to Access.)Get a odbc driver, create a DSN and use the jdbc-odbc bridge.
jschell at 2007-6-29 11:30:11 >
Wow! A 200MB Access Database!jschell is correct. Every time you connect to an Access database, you are "connecting" to a single file.Like he stated, you can create an ODBC data source and use the JDBC to ODBC driver to read that huge file you call a database. -AJD
ajdiaz at 2007-6-29 11:30:11 >
I'm sorry, I should have been more specific. I cannot use ODBC drivers because the database must be completely transparent. It has to be able to run resident off of a CD, and must be completely cross-platform. The end-users have to be able to use this program with absolutely no installation on their side, just double click the icon and away they go.
ConlonP at 2007-6-29 11:30:11 >
>I cannot use ODBC drivers because the database must be completely transparent.
>It has to be able to run resident off of a CD, and must be completely cross-platform.
Then I would suggest looking for another database. There is no driver for MS Access that will work on a non-windows platform. All commercial/shareware/freeware solutions rely on a windows server to do the real work.
But if you have enough time you could write a new driver.
Or move to a different database.
Or if the data tree isn't that complex move to a flat file solution. Hitting the CD would hide any performance problems in using that.
jschell at 2007-6-29 11:30:11 >
Database Connectivity New Topic
Database Connectivity Hot Topic
- Accessing database Variables using JDBC
- Invalid Path in JDK1.3.1&JDBC-ODBC Connection on Windows NT 4
- validating string between jdbc and textfield
- Insert record into Microsoft Access
- "table already exists" error message....
- Detect database shutdown
- A driver for sequel and oracle
- A driver for sequel and oracle
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding