Enhydra: IOException in MysqlIO.clearAllReceive??

[Jay Gunter <jay@xxxxxxxxxx>]

Michael,

I'm not familiar enough with MySQL to provide more assistance,
so I've taken the liberty of reposting your message to
the enhydra, dods-group and jdbc-group mailing lists.

Have any of you MySQL users ever seen an intermittent IOException
thrown from MysqlIO.clearAllReceive() ??

I hate problems like this, and would enjoy knowing the workaround.
Hey Michael, does the problem happen at all predictably?
For example, does it never happen if you avoid certain operations?
What if you do some completely trivial query over and over?

TIA
--
Jay Gunter
Lutris Technologies
1200 Pacific Ave, Suite 300
Santa Cruz, CA 95060
831/460-7318
jay@xxxxxxxxxx

--- Begin Message ---

• Subject: RE: Enhydra: JDBC problem w/Enhydra app
• From: "Michael Molloy" <ukalumni@xxxxxxxxxxx>
• Date: Tue, 26 Sep 2000 08:19:12 -0500

Hi Jay. Thanks for the reply.

Yes, I've tried 2.0.2, 2.0.1, & 1.2.

I fixed the "Query Was Empty" error; that was all my fault. But this io
exception still happens more than 50% of the time. When it doesn't happen,
my code works fine. That's what really throws me.

Thanks again,
--Michael

-----Original Message-----
From: owner-enhydra@xxxxxxxxxxx [mailto:owner-enhydra@xxxxxxxxxxx]On
Behalf Of Jay Gunter
Sent: Monday, September 25, 2000 1:53 PM
To: enhydra@xxxxxxxxxxx
Subject: Re: Enhydra: JDBC problem w/Enhydra app


Have you tried using a different JDBC driver?
I've seen many quirky problems go away with a driver change.

Beverly Molloy wrote:

> I've got an Enhydra application that connects to a MySQL database and
checks
> to see if any data exists. If the data doesn't exist, it is inserted. If
it
> does exist, the quantities are updated.
>
> The problem happens in the update. I get two different errors, never at
the
> same time. I can submit the form multiple times, and sometimes I get one
> error message, and other times I get the other.
>
> Here's one:
>
> java.sql.SQLException: Communication link failure: java.io.IOException
> at org.gjt.mm.mysql.MysqlIO.clearAllReceive(MysqlIO.java)         at
> org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)         at
> org.gjt.mm.mysql.Connection.execSQL(Connection.java)
>         at
> org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java)
>
> Here's the other:
>
> java.sql.SQLException: Syntax error or access violation: Query was empty
> at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
>         at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at
> org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
>         at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
>         at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
>         at org.gjt.mm.mysql.Statement.executeUpdate(Statement.java)
> at org.gjt.mm.mysql.jdbc2.Statement.executeUpdate
> (Statement.java:97)
>
> Any suggestions? I'm using JDK 1.3 & the mm.mysql-2.0.2-bin.jar.zip
driver.
> Thanks for any help.
>
> --Michael
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@xxxxxxxxxxx
> with the text "unsubscribe enhydra" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-enhydra@xxxxxxxxxxxx

--
Jay Gunter
Lutris Technologies
1200 Pacific Ave, Suite 300
Santa Cruz, CA 95060
831/460-7318
jay@xxxxxxxxxx


----------------------------------------------------------------------------
-
To unsubscribe from this mailing list, send email to majordomo@xxxxxxxxxxx
with the text "unsubscribe enhydra" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-enhydra@xxxxxxxxxxxx

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@xxxxxxxxxxx
with the text "unsubscribe enhydra" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-enhydra@xxxxxxxxxxxx

--- End Message ---