Java access to MySQL

[hazresource]

Does the Java on FQ machines support access to the FQ MySQL databases?[nbsp][nbsp]If so, what classes would be involved and please provide a pointer to the appropriate javadoc.
<!-- NO_AUTO_LINK -->

[Tog]

Are you talking about running an applet on your page that connects to your mysql database or about an external application that connects to a mysql db?

I haven't done any java db related work recently but IIRC, you should study the java.sql.* package javadoc documentation and perhaps get a good book that describes db access and java.

You should also to download some db drivers that will allow you to connect to mysql. Visit http://www.mysql.com as I believe there are links there to some freeware Type 4 database drivers to mysql. Once you have a db driver, you will need to add them to your CLASSPATH or applet CODEBASE.

Hope this helps.

Tony
[This message has been edited by Tog (edited 01-31-00@02:39 am)]

[Justin]

I'm also not sure exactly what you're looking for - but you might find this link helpful:

http://www.gwe.co.uk/mysql/

If you're refering to server-side Java, we have the Blackdown JDK installed, though I can't say if MySQL support is compiled in or not (or if that's even how it works - I'm Java-illiterate)...

If the above doesn't help, please elaborate or provide a link that will help us figure out what we would need to do...

------------------
Justin Nelson
FutureQuest Support

[pier]

Does the Java on FQ machines support access to the FQ MySQL databases?
What do you exactly mean ?

Do you want to gave applets access to the database ? I guess not, because they will need the username/pwd combination to access it, and using a decompiler I would be
able to gain access to you database.
Also remind that applets need to connect to something like
a listener, as they run on the user's pc.

On the contrary, if you want local applets (i.e. servlets) to connect, you'll need the jdbc-drivers. Indeed study the java.sql.* package, and you might take a look at mysql.com, for information about available jdbc-drivers.

Pier
[ Or *maybe* you mean something like jsp (java server pages). Than FQ will need to install jrun or resin, to enable it. But due to some errors, this is currently not an
option (e.g.: resin and jrun need to be rebooted when you update the local java-classes. ]