java-mysql connection error cannot be resolved

Hi, due to some issues i uninstalled openjdk shipped default on my opensuse 11.3 and installed jdk 1_6_21 from a .bin file. Its installed to usr/java/jdk… …

The mysql connector is also present in the same but running a java program that connects to mysql gives me the error

java.sql.SQLException: Unknown initial character set index ‘192’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

the code i tried is

import java.sql.;

class mysql_conn_tester
static Connection my_test_connection;
public static void main(String args])
System.out.println("Connection Failed
System.out.println("Connection Success
catch(Exception e)

NB: This code has been working successfully and have tested connections before.:’(


Instead of using this bin file, did you try the package available through yast (the java-sun one) : Webpin

I don’t think its problem with the bin file because I’ve once used the same file before and things worked fine then…Just last night I have upgraded to KDE 4.5. Do you think that has something to do with this?

I really doubt it… Make sure all the packages with openjdk are uninstalled on your system.