Re: Connection link failure - Jeff Mathis - com.mysql.lists.java

5 messages in com.mysql.lists.javaRe: Connection link failure

From	Sent On	Attachments
Jeff Mathis	23 Oct 2002 10:34
Mark Matthews	23 Oct 2002 10:43
Jeff Mathis	23 Oct 2002 12:19
Mark Matthews	23 Oct 2002 12:24
Mark Matthews	25 Oct 2002 06:09

Subject:	Re: Connection link failure
From:	Jeff Mathis (jmat...@predict.com)
Date:	10/23/2002 12:19:59 PM
List:	com.mysql.lists.java

when i telnet, i do get a connection:

chalupa{jmathis}64: telnet snow 3306 Trying 192.132.2.162... Connected to snow.predict.com. Escape character is '^]'. 3 4.0.3-beta-max-logUR|;P_m',

and then after about 30 seconds, the connection is closed by foreign host.

I have no problem connecting through the Perl DBI module, which I pretty sure also uses TCP/IP

any other suggestions?

thanks

jeff

Mark Matthews wrote:

Jeff Mathis wrote:

hello all,

I'm trying to connect, and am getting this exception:

getting connection to jdbc:mysql://snow:3306/hera ... java.sql.SQLException: Communication link failure: java.io.IOException at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:883) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1338) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1183) at com.mysql.jdbc.Connection.execSQL(Connection.java:1982) at com.mysql.jdbc.Connection.execSQL(Connection.java:1918) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1188) at com.mysql.jdbc.Connection.connectionInit(Connection.java:1098) at com.mysql.jdbc.Driver.connect(Driver.java:313) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.predict.ndq.TestConnect.<init>(TestConnect.java:35) at com.predict.ndq.TestConnect.main(TestConnect.java:60)

I'm using the 3.01 beta release, and jdk1.40

any help?

thanks

jeff

What happens when you do something like 'telnet snow 3306' from a command prompt? You should get a response from MySQL. If not, then your MySQL isn't configured to do TCP/IP networking (which JDBC requires).

The README that comes with the driver covers some possible scenarios.

-Mark

To request this thread, e-mail <java...@lists.mysql.com> To unsubscribe, e-mail <java-unsubscribe-##L=##H...@lists.mysql.com>