List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 3 1999 12:40pm
Subject:Re: MySql 3.2.2.22- Socket Creation error: twz1jdbcForMysql 1.0.4
version
View as plain text  
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

Thread
MySql 3.2.2.22- Socket Creation error: twz1jdbcForMysql 1.0.4 versionpaceauto31 Jul
  • Re: MySql 3.2.2.22- Socket Creation error: twz1jdbcForMysql 1.0.4 versionChristian Mack3 Aug