I need help resolving the following error, which I get
when trying to use the DatabaseUpdateAction to update
the database. Note that I have successfully used the
DatabaseAddAction from the same form to post records,
so I assume it cannot be my descriptor file that is in error.
The message is:
org.apache.cocoon.ProcessingException:
Could not update record :position = 5:
java.sql.SQLException: Syntax error or access violation:
You have an error in your SQL syntax near '' at line
1
Original exception : java.sql.SQLException:
Original exception : java.sql.SQLException:
Syntax error or access violation:
You have an error in your SQL syntax near '' at line 1
at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown
Source)
at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.cocoon.acting.DatabaseUpdateAction.act(DatabaseUpdateAction.java:124)
... etc
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
"The CSIR exercises no editorial control over E-mail messages and/or
attachments thereto/links referred to therein originating in the
organisation and the views in this message/attachments thereto are
therefore not necessarily those of the CSIR and/or its employees.
The sender of this e-mail is, moreover, in terms of the CSIR's Conditions
of Service, subject to compliance with the CSIR's internal E-mail and
Internet Policy."
