You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by tc...@memphis.edu on 2003/06/26 21:13:18 UTC
Deleting from a database - Cocoon 2.0.3
Hi all -
I've got a problem using Cocoon 2.0.3 in that I can't seem to delete a
record from the database I'm using. Didn't see anything on the archive
list related to this. I can add records just fine, but when I execute
the code to delete a record, I get the following:
"org.apache.cocoon.ProcessingException: Could not delete record
:position = 0: java.sql.SQLException: Syntax error or access violation:
You have an error in your SQL syntax near '' at line 1..."
When I change the <map:act type="delete"> in the sitemap to <map:act
type="add">, I get the confirmation page and the display of the values
within the database that I should get if this were an actual delete.
Any other way will throw the error above. I'm using the following
within my sitemap:
<map:action name="delete" logger="sitemap.action.delete"
src="org.apache.cocoon.acting.DatabaseDeleteAction"/>
I'm using MySql version 3.23.56 with the appropriate driver. I also
have delete access granted to the user on MySql - so it's not an access
problem. Actually, I'm re-writing an example out of the book "Cocoon
Developers Handbook" in Ch. 12 - and have this working like it should
(there is no example of deleting a record from the database, though).
What confuses me is that I get a SQL syntax error. I have written a
page to delete a record using ESQL - and that works fine - but it
doesn't fit into the overall site plan.
My development setup is described below:
Windows XP
Tomcat 4.0.5
Cocoon 2.0.3
MySql 3.23.56
Any thoughts?
Thanks in advance,
tsc
Todd S. Canaday
Instructor - Adjunct Faculty
Herff College of Engineering
The University of Memphis
Memphis, TN 38152-3210
Office 218A
http://www.people.memphis.edu/~tcanaday/
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org