Mysql driver fails on connection

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

I tried to print the SQL error code and it comes to be 0.
I am not using any query or anything this exception occurs when i call Drivermanager.getCnnection().

Can any one help me and tell me where i am going wrong

[Paul Clapham]

"Adithya Neurons", please check your private messages for an important administrative matter.

[Campbell Ritchie]

Originally posted by Paul Clapham:
"Adithya Neurons", please check your private messages for an important administrative matter.

I am afraid you will have to check your private messages again, Adithya.

[Adithya NN]

Hi
We generally dont use our last name in india since its most of the time our fathers name So i wud still be preffered to call Adithya NN. If it still violates your naming policy I am afraid i will have to leave JavaRanch.I dint expect this kind of insensitivity from your end

Thanks & regards
Adithya N N

[arulk pillai]

Look at


https://coderanch.com/t/307219/JDBC/java/Connecting-MySQL
[ August 15, 2008: Message edited by: arulk pillai ]

[Adithya NN]

I have added the connector jar downloaded into the class path and have also tried using the code present in the above link none of them work.I keep getting the Exception. Its not the ClassNotFoundException its some other kind of exception as i have posted above

[arulk pillai]

28.4.5.3.9: When using gcj an java.io.CharConversionException is raised when working with certain character sequences.

This is a known issue with gcj which raises an exception when it reaches an unknown character or one it cannot convert. You should add useJvmCharsetConverters=true


http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-troubleshooting.html#qandaitem-28-4-5-3-9


Google for - MySQL Caused by: java.io.CharConversionException

[Adithya NN]

Thanks it worked.I changed the JRE to Sun. And the it worked with gcj upon passing the VM argument

[Campbell Ritchie]

It's not a case of insensitivity, but of bitter experience with fora where people use pseudonyms only. The atmosphere can become unpleasant and we have found that enforcing the naming policy strictly helps maintain a friendly atmosphere here, even though (and we are sorry about that) it may inconvenience a few people.

It would not be appropriate to continue discussing the naming policy here, but you are welcome to go through the "Javaranch" forum where that sort of thing is normally discussed.

[Campbell Ritchie]

And well done getting your problem sorted out
[ August 15, 2008: Message edited by: Campbell Ritchie ]

[Ulf Dittmer]

As to the display name, note that you're free to choose any name you like. It doesn't have to be your real name, it just has to sound like a real name, and have a full first and last name.