Welcome to the Java Programming Forums
The professional, friendly Java community. 21,500 members and growing!
The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.
>> REGISTER NOW TO START POSTING
Members have full access to the forums. Advertisements are removed for registered users.
LinkBack URL
About LinkBacks
JDBC JAVA MYSQL
Hey guys? I was wondering how to connect a MYSQL database to JAVA using a Connector /J. I have the following -
@java sql connector /j.msi // I read that it's supposed to be a jar file but I can only find a .msi file on the download website.
@wamp server
@eclipse adt
Someone explain to me how please. I'm frustrated.
Related threads:
Re: JDBC JAVA MYSQL
It took me some time to figure out too. The driver loading was the hardest part. I found the driver easily enough, but something about loading it up in Eclipse was hard to figure out. I wrote it down somewhere in a notebook, but that's... somewhere far away and I can't get to it for a few hours.
MSI files are just Microsoft installer files. Try running the MSI file after downloading it. If I recall correctly, you select a location to install it to, and it installs a folder containing the JAR file. Mine (downloaded not too long ago, sometime toward the end of June) is called mysql-connector-java-5.1.25 and contains a bunch of files, including mysql-connector-java-5.1.25-bin.jar. I can't remember the exact procedure I used in Eclipse to install it. Like I said, I wrote it down somewhere because I kept forgetting, but I won't have access to that notebook until later this morning.
Do you know the steps involved in setting up a Connection, a Statement, and running queries after you get the driver loaded?
kevthanewversi (September 22nd, 2013)
Re: JDBC JAVA MYSQL
You just have to add the Jar file to your project's build path.
kevthanewversi (September 22nd, 2013)
Re: JDBC JAVA MYSQL
Thank you! My problem is that when I try to unpack the. msi file it says it's corrupted. I thought .msi files could be unarchived? I don't really know how to do that too and would very much appreciate if you showed me how.
Re: JDBC JAVA MYSQL
.msi is a winblows installer file. Double click it in windows.
Re: JDBC JAVA MYSQL
there is jar file available for connectivity if you are failed to find it then search for a zip file there are files containing jar files on official site
Re: JDBC JAVA MYSQL
WAMP is a WebServer, Eclipse is an IDE.
The jar files are the libraries that are needed to make java work with MYSQL database.
there will be 3 jar files that has to be installed.
Open Eclipse, select the project on the Left Pane at which you are working with.
When expanding (+ symbol) you may see Library folder..
On that, Right click and choose add JAR/Files..
Browse to the folder that having these 3 needed jar files.
Select all those and add into your project.
Thats it.
Thanks.
Vigneshwaran R.R
Reply With Quote