Java-Gaming.org    
Featured games (91)
games approved by the League of Dukes
Games in Showcase (577)
games submitted by our members
Games in WIP (498)
games currently in development
News: Read the Java Gaming Resources, or peek at the official Java tutorials
 
    Home     Help   Search   Login   Register   
Pages: [1]
  ignore  |  Print  
  about mdb files and java  (Read 1128 times)
0 Members and 1 Guest are viewing this topic.
Offline Kommi

Junior Member




All opinions will be lined up and shot!


« Posted 2005-02-28 17:14:22 »

If I have an mdb file (database file), can Java access it directly without the mdb file needing to be loaded into an SQL server? If so can I also change the tables and create new ones in the mdb file without an sql server?

Kommi
Offline erikd

JGO Ninja


Medals: 15
Projects: 4
Exp: 14 years


Maximumisness


« Reply #1 - Posted 2005-02-28 17:44:36 »

You can access (no pun intended Wink) it by creating an ODBC data source in Windows and use the JDBC-ODBC bridge driver (either sun's or a third party bridge driver).
I don't think there is a JDBC driver specifically for MS Access.
You need the Access ODBC driver installed though (for example by installing Access)

Offline Kommi

Junior Member




All opinions will be lined up and shot!


« Reply #2 - Posted 2005-02-28 18:03:14 »

im using ms sql and already have micro$oft's driver. So this means that any sql server just gives you a UI to the mdb file correct? I could theoretically write my own sql server in Java?

Kommi
Games published by our own members! Check 'em out!
Legends of Yore - The Casual Retro Roguelike
Offline erikd

JGO Ninja


Medals: 15
Projects: 4
Exp: 14 years


Maximumisness


« Reply #3 - Posted 2005-02-28 19:42:43 »

I'm confused. Isn't an mdb file an MS Access database?  Huh
MS SQL Server is an entirely different beast, for which good JDBC drivers are available (as long as you avoid MS's one).
Both should DB's should be avoided though  Grin

Offline Daire Quinlan

Junior Member





« Reply #4 - Posted 2005-02-28 21:24:44 »

agreed, Ideally you should be using PostreSQL or MySQL, but I've used Access databases occasionally on simple websites purely for convenience sakes. Mainly for ASP stuff though. The two work well together.

D.
Offline Kommi

Junior Member




All opinions will be lined up and shot!


« Reply #5 - Posted 2005-03-03 19:49:27 »

what are some of the downfalls of using Microsoft's drivers and working with an mdb file?

Kommi
Offline erikd

JGO Ninja


Medals: 15
Projects: 4
Exp: 14 years


Maximumisness


« Reply #6 - Posted 2005-03-04 10:59:36 »

If you want to access an MS Access .mdb file, you have to use the ODBC bridge driver, which is only really suitable for testing, really (even Sun states that it shouldn't be used in production).
There are alternative, but commercial, ODBC bridge drivers available though. But then again, Idoubt that you will be able to access the Access database from another and non-windows machine.

The last time I checked, the SQL-server JDBC driver from Microsoft came with an installshield which installs all kinds of scary .dll files and so only works on Windows. Besides, I found it's not exactly the fastest driver and not really stable too.
For SQL server, try jTDS (http://jtds.sourceforge.net/). It's fast, reliable and very easy to install/use (it's just a jar).

Offline Daire Quinlan

Junior Member





« Reply #7 - Posted 2005-03-04 14:40:39 »

Or better still, embed cloudscape/derby into your app. No external stuff needed (as far as i know), pure java, and open source. I think its hosted off the Apache foundation website ?

D.
Offline erikd

JGO Ninja


Medals: 15
Projects: 4
Exp: 14 years


Maximumisness


« Reply #8 - Posted 2005-03-04 17:45:02 »

Anything is better than an Access mdb file or SQL Server (esp. with MS JDBC driver)  Grin

Pages: [1]
  ignore  |  Print  
 
 
You cannot reply to this message, because it is very, very old.

 

Add your game by posting it in the WIP section,
or publish it in Showcase.

The first screenshot will be displayed as a thumbnail.

xsi3rr4x (22 views)
2014-04-15 18:08:23

BurntPizza (17 views)
2014-04-15 03:46:01

UprightPath (31 views)
2014-04-14 17:39:50

UprightPath (15 views)
2014-04-14 17:35:47

Porlus (31 views)
2014-04-14 15:48:38

tom_mai78101 (57 views)
2014-04-10 04:04:31

BurntPizza (114 views)
2014-04-08 23:06:04

tom_mai78101 (214 views)
2014-04-05 13:34:39

trollwarrior1 (182 views)
2014-04-04 12:06:45

CJLetsGame (189 views)
2014-04-01 02:16:10
List of Learning Resources
by Longarmx
2014-04-08 03:14:44

Good Examples
by matheus23
2014-04-05 13:51:37

Good Examples
by Grunnt
2014-04-03 15:48:46

Good Examples
by Grunnt
2014-04-03 15:48:37

Good Examples
by matheus23
2014-04-01 18:40:51

Good Examples
by matheus23
2014-04-01 18:40:34

Anonymous/Local/Inner class gotchas
by Roquen
2014-03-11 15:22:30

Anonymous/Local/Inner class gotchas
by Roquen
2014-03-11 15:05:20
java-gaming.org is not responsible for the content posted by its members, including references to external websites, and other references that may or may not have a relation with our primarily gaming and game production oriented community. inquiries and complaints can be sent via email to the info‑account of the company managing the website of java‑gaming.org
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines | Managed by Enhanced Four Valid XHTML 1.0! Valid CSS!