paceauto wrote:
>
> I am rying to acces mySql 3.2.2.22 (Linux 6.0) from my windows clients.
> I have given all the necessary grants on the server side. I am able to
> telnet and login into the server MYSQL db server from my clients. Butu
> whne i run my application and access my database on server, it gives me
> an error saying:
>
> java.sql.sqlexception:E2022:Socket error creation.
> I have tried all different port numbers(default is 3036).
>
> It looks to me as a TCP/IP error. What could be done about it?
>
> My code is below:
>
> public class jdex {
>
> public static void main(String[] args) {
> try {
> String url = "jdbc:z1MySQL://servername/databasename";
> System.out.println(url);
>
> Driver mydriver = new twz1.jdbc.mysql.jdbcMysqlDriver();
> java.sql.DriverManager.registerDriver(mydriver);
> System.out.println("Class Loaded");
>
> Connection cntdb =
> DriverManager.getConnection(url,"user","password");
>
> System.out.println("Connected");
> } catch(Exception ex){System.out.println(ex.toString());}
> }
> }
>
> Mysql Version : 3.22.22
> twz1jdbcForMysql 1.0.4 version
>
> Server
Hi "paceauto"
You didn't say, which Java you use for this.
Also the default port is 3306 not 3036, but I assume this was just a typo.
I wouldn't use "System.out,println(ex.toString());", instead "ex.printStacktrace()".
BTW:
There is a Java <-> mysql related mailinglist at:
mailto:java@stripped
On this list is also the author of this driver.
Tschau
Christian
