Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

MySql

 
Ranch Hand
Posts: 161
1
jQuery Eclipse IDE
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 8
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Swapna, It will help you:-



It will return the connection with MySqlDataBase with url "jdbc:mysql://bsl-ritu/pearlstine" , User "root", Password "123456".
 
Sheriff
Posts: 22649
126
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Swapna latha
Ranch Hand
Posts: 161
1
jQuery Eclipse IDE
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 22649
126
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 8
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 36
MySQL Database Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 161
1
jQuery Eclipse IDE
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 22649
126
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Posts: 8
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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".

 
When all four tires fall off your canoe, how many tiny ads does it take to build a doghouse?
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
    Bookmark Topic Watch Topic
  • New Topic