Enhydra: JDBC problem w/Enhydra app

["Beverly Molloy" <bmolloy@xxxxxxxxxxx>]

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