MySQL drivers in Linux

Hi folks,

I'm not sure where this question belongs, but I guess it's kinda here, as it's JDBC related.

Hi guys,

I'm currently re-installing my linux stuff at the moment, and I have a split on my HD of XP & Linux.

For some weeks now, I have been working on a Sales system using the JDBC bits in Java. I'm looking to do the same in Linux using MySQL instead of Access.

Couple of things I wanna know:

1.How do I install a MySQL driver for Linux? I'm currently running Ubuntu 6.10 Edgy

2.I can create a data base easily enough, however I need to change where the file is kept. Ideally I want it in the same place as my source code for the programming stuff.

Many thanks.

[731 byte] By [Emyra] at [2007-10-3 11:03:59]
# 1

Um. To answer your second question first, if you care where the file is kept, you probably would prefer an embedded database to a stand-alone DB like MySQL. Look into Derby, and also into HSQLDB.

For the sake of argument, supposing that you still want to "install" a MySQL driver, just download the JDBC driver (Connector/J) JAR file and place it in the classpath of your app.

dcmintera at 2007-7-15 13:26:24 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
PS Make sure you've got a "real" JVM installed, not the GCJ one. I don't know if they have a synaptic package for the Sun one yet, but download and install it if not.
dcmintera at 2007-7-15 13:26:24 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...