File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Stupid question (if any could be such) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stupid question (if any could be such)" Watch "Stupid question (if any could be such)" New topic
Author

Stupid question (if any could be such)

Goran Markovic
Ranch Hand

Joined: Sep 26, 2008
Posts: 399
Hi, well just I said I'm really blushing during this writing, but that's the occasion... I'm however used the jdbc API, and create few web application, but each my application has used MS Access, as database storage. Now I want , of course, to some serious database, but to start with mysql. How I've installed mySaql and configure it onto my machine and it ok. But as I said, I used to utilize "physical tangible" tables, just as MS Access has, and using mySql I'm little confused? Where are they - databases, tables... In other words How can I use my applications with mySql (the portion of code where from I talk to database, just as I did with MS Access)???
Balagopal Kannampallil
Ranch Hand

Joined: Oct 18, 2004
Posts: 136

HI,

I am making out that you have installed MySQL successfully in your machine and now you want to create databases and tables. For this purpose you can use MySQL GUI tools. Please see the following link MySQL GUI Tools


SCJP 5.0 and now fighting with ExtJS
Goran Markovic
Ranch Hand

Joined: Sep 26, 2008
Posts: 399
I want to reuse my database calls, coded in my class, but to be directed to mySql database not MSAccess.
Balagopal Kannampallil
Ranch Hand

Joined: Oct 18, 2004
Posts: 136

You can change the driver class name, now to point to MySQL driver in place of the current MS Access driver in the class where your database operation are done.
Goran Markovic
Ranch Hand

Joined: Sep 26, 2008
Posts: 399
I've download the toolkit you advice me and during configuration it give me some error. Can you direct me to some source where I could found this "transaction" from MS Access to mySql?
Balagopal Kannampallil
Ranch Hand

Joined: Oct 18, 2004
Posts: 136

I am not sure, may be this link will help. Migrating From MS Access To MySQL
Goran Markovic
Ranch Hand

Joined: Sep 26, 2008
Posts: 399
Since, interesting, I'll take a closer look into. Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stupid question (if any could be such)