Re: Enhydra: JDBC problem w/Enhydra app

[Jay Gunter <jay@xxxxxxxxxx>]

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