aspose file tools*
The moose likes JDBC and the fly likes MySql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySql" Watch "MySql" New topic
Author

MySql

Swapna latha
Ranch Hand

Joined: Dec 18, 2011
Posts: 68
hi all ! i know how to do programs and connect to jdbc for oracle.

But i am getting confused with MySql. What is this connector j ? Can anybody help me out in creating tables,jdbc connections in MySql ? Any links, pdfs, materials, books, sites please help me ?

Thanks & Regards
Kori Swapna Latha
Shankh Pani Parimal
Greenhorn

Joined: Dec 29, 2011
Posts: 8

Hi Swapna, It will help you:-



It will return the connection with MySqlDataBase with url "jdbc:mysql://bsl-ritu/pearlstine" , User "root", Password "123456".
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19557
    
  16

Connector/J is just MySQL's JDBC driver implementation. Similarly there are Connector/Net for connecting to MySQL databases from .NET and Connector/ODBC for connecting using ODBC.

Some useful links:
JDBC
MySQL


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Swapna latha
Ranch Hand

Joined: Dec 18, 2011
Posts: 68
Thanks phani and Rob.

Still i have confusion regarding connector j. without connector j phani has given code and whats the use of connectorj then ?
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19557
    
  16

Connector/J include the com.mysql.jdbc.Driver class that's loaded in that little piece of code. Without the Connector/J JAR file that line would throw a ClassNotFoundException.
Shankh Pani Parimal
Greenhorn

Joined: Dec 29, 2011
Posts: 8

Don't confuse yourself with connector j, it internaly work with in driver package ("com.mysql.jdbc.Driver "). Driver automaticaly create connection using Connector/j.

Shankh
Raj Bansilal Champaneriya
Ranch Hand

Joined: Dec 17, 2011
Posts: 36

Most of our applications require database for storing data. Programs written in many languages and they might use different databases to store data.

For communicating with database programming languages need some mechanism to convert their database call into Database specific code for executing SQL commands. Here the mechanism is written in driver specific to databases. Sun has given a specification in which all interfaces were given to all database vendors for creating driver that support JDBC.

So we can say JDBC work as middle ware between application and database driver.

See this link you'll be very clear about JDBC Driver.

http://www.tutorialspoint.com/jdbc/jdbc-driver-types.htm
Swapna latha
Ranch Hand

Joined: Dec 18, 2011
Posts: 68
Thanks Raj Bansilal. You have shown me a good website to learn. If you know any good websites like this please share it to me so that i can update myself. Please update me by sending the list to my private message box
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19557
    
  16

Swapna latha wrote:Please update me by sending the list to my private message box

Please don't. UseTheForumNotEmail (or private messages).
Shankh Pani Parimal
Greenhorn

Joined: Dec 29, 2011
Posts: 8

Shankh Pani Parimal wrote:Hi Swapna, It will help you:-



It will return the connection with MySqlDataBase with url "jdbc:mysql://bsl-ritu/pearlstine" , User "root", Password "123456".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySql
 
Similar Threads
JDBC and MySQL
Jars and magic problems
hello everyone,how can i use jsp connect mysql?
Mysql and JDBC problem
Connect to Style Reports using JDBC Only