File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Converting from Access to MySQL
Joined: Mar 31, 2005
Dec 20, 2006 16:08:00
I've just converted my database from Access to MySQL because I'm running on Linux now.
My question is, are there any changes needed in the
code when making a connection to a MySQL database in comparison to an Access database?
Using Access, I would include this in my servlet to make a connection:
url = "jdbc
dbc:jTunesDB"; //jTunesDB is the database name.
Connection connection = DriverManager.getConnection(url,"","");
and previously in my Windows machine, I would go into ODBC setting in my control panel and set the path where the Access database was stored.
If anyone can help me with this, I would greatly appreciate it.
author & internet detective
Joined: May 26, 2003
Dec 20, 2006 19:00:00
That should still work. Note that with MySQL, you are not tied to the ODBC driver. See this
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Converting from Access to MySQL
MySQL can't connect with my driver
Optimizing Database Connection ?
MySQL database connection fails after long idle
Transactions - JTA or JDBC?
localhost to web server
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015