RE: Enhydra: JDBC problem w/Enhydra app

["Michael Molloy" <ukalumni@xxxxxxxxxxx>]

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