-Original Message-
From: Laxmikanth M.S. [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 12:20 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: COMMUNICATION LINK FAILURE
Hi all,
well and wish the same...
I am getting a peculiar error ..
I am using
ave used PreparedStatement
after 33 rows are Inserted it shows the below error
java.sql.SQLException: Communication link failure: java.io.IOException
at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknow
error
java.sql.SQLException: Communication link failure: java.io.IOException
at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source
- Root Cause -
java.sql.SQLException: Communication link failure: java.io.IOException
at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source
I got a tip here from Craig about using a query in server.xml to make sure the
connection was good before executing a statement, but I lost it.
Is this correct?
parameter
namevalidationQuery/name
valueSELECT 0;/value
/parameter
Also, should I use ; or not? an extra ; will
Here's my validation query...
parameter
namevalidationQuery/name
valueSELECT MAX(id) FROM Users/value
/parameter
The Database being used is Oracle 8i
Hope that helps.
Jake
At 07:59 PM 1/17/2003 -0800, you wrote:
I got a tip here from Craig about using
) {}
if (pstmt != null) try { pstmt.close(); } catch(Exception e3) {}
}
Jake
At 04:40 PM 4/2/2002 -0500, you wrote:
I'm running Tomcat 4.0.1 on a W2K server and connecting to SQL Server 2000
on another W2K server on our network.
I get a Communication Link Failure from time to time. It's