mysql..connectivity

[Aboo saimon]

im very new to j2ee and mysql... i wanna entire connectivity coding..can please... ???

[Campbell Ritchie]

Welcome to JavaRanch

"I want doesn't get" is what we were told as little children.

Please read some of our FAQs. Look at the MySQL handbook and the Java� Tutorials.
[ August 13, 2008: Message edited by: Campbell Ritchie ]

[aleem khan]

String url = "jdbc:mysql://localhost:3309/";
String db = "search";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
try{
Statement stmt = con.createStatement();
String table = "CREATE TABLE Employee(SSN integer,Name VARCHAR(40),DOB VARCHAR(20),Address VARCHAR(100))";
stmt.executeUpdate(table);
}catch (SQLException s){
}

The above code is tested code, it should work. Here db="search" is your database name. Let me know if you are successful

[Muhammad Saifuddin]

hi Aboo saimon,

Welcome to Javaranch,

Just a suggestion : its better to ask concept instead of coding..

[Adeel Ansari]

Originally posted by lavani aleem khan:
String url = "jdbc:mysql://localhost:3309/";
String db = "search";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
try{
Statement stmt = con.createStatement();
String table = "CREATE TABLE Employee(SSN integer,Name VARCHAR(40),DOB VARCHAR(20),Address VARCHAR(100))";
stmt.executeUpdate(table);
}catch (SQLException s){
}

The above code is tested code, it should work. Here db="search" is your database name. Let me know if you are successful

If I were you, I would have been showed some respect to the Campbell's post, and never post the code. Anyways, we are here to learn. Have a good time.

Cheers.

[Campbell Ritchie]

Originally posted by Adeel Ansari:


If I were you, I would have been showed some respect to the Campbell's post, and never post the code. Anyways, we are here to learn. Have a good time.

Cheers.

Actually, all the code was in my post . . . but you had to click the links to find it. And there is a major error in the code quoted, viz the empty catch block.

You are right, however; following the links and copying the code from the handbook is a better way to learn. But in real life, you don't actually need to learn the code if you can remember which page of the handbook it is on.
[ August 14, 2008: Message edited by: Campbell Ritchie ]

[Adithya NN]

Hi,
I am using the following piece of code for establishing the connectivity

  try{
      String url ="jdbc:mysql://localhost:3306/";
      String driver ="com.mysql.jdbc.Driver";
      String user="root";
      String dbName="test";
     
     Class.forName(driver); 
      
      conn=   DriverManager.getConnection(url+dbName,user,"");
            System.out.println("Connection to MySQL Database Successful"+conn);
   } catch (SQLException sqe1){
   sqe1.printStackTrace();
      System.out.println("Caught SQL Exception: " + sqe1);
   }  

However i am getting the following exception when i run the program

  java.sql.SQLException: Unexpected exception encountered during query.
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2581)
   at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1751)
   at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3425)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2045)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
   at java.sql.DriverManager.getConnection(libgcj.so.9)
   at java.sql.DriverManager.getConnection(libgcj.so.9)
   at JDBCtest.main(JDBCTest.java:26)
Caused by: java.io.CharConversionException
   at gnu.gcj.convert.Input_iconv.read(libgcj.so.9)
   at java.lang.String.init(libgcj.so.9)
   at java.lang.String.<init>(libgcj.so.9)
   at com.mysql.jdbc.SingleByteCharsetConverter.<init>(SingleByteCharsetConverter.java:152)
   at com.mysql.jdbc.SingleByteCharsetConverter.initCharset(SingleByteCharsetConverter.java:107)
   at com.mysql.jdbc.SingleByteCharsetConverter.getInstance(SingleByteCharsetConverter.java:85)
   at com.mysql.jdbc.ConnectionImpl.getCharsetConverter(ConnectionImpl.java:2759)
   at com.mysql.jdbc.StringUtils.getBytes(StringUtils.java:679)
   at com.mysql.jdbc.Buffer.writeStringNoNull(Buffer.java:663)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2025)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
   ...9 more
Caught SQL Exception: java.sql.SQLException: Unexpected exception encountered during query.
  

Could any body help me and tell me what i am doing wrong ?

[Campbell Ritchie]

Welcome to JavaRanch Adithya Neurons.

Please don't post something unrelated to the original thread; this is called hi-jacking and may lose the original poster their topic.

It would have been better to start a new thread.
Please get the SQLException to print out its error code and SQL state and go to the MySQL handbook and search for those error types and their explanation.
Please find out which query it is not working, go to the tables queried and see what sort of characters you are using there. What sort of charset are you using in your database? That will give a bit more information for a start.
[ August 14, 2008: Message edited by: Campbell Ritchie ]

[Adithya NN]

Sorry for the mistake have moved it to new link as below.
Mysql COnnection fails