Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » JSP Interest »

JSP/JDBC question

Jack Lauman

2005-01-19


I'm getting the following error when my JSP form POSTs:

17:15:23,500 INFO [STDOUT] -----SQLException-----
17:15:23,500 INFO [STDOUT] SQLState: 42000
17:15:23,500 INFO [STDOUT] Message: Syntax error or access violation
message from server: "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '?, Subscriber = ?, RenewalDate = ?,
SubscriptionExpired = ?, Cuisine = ?, ChefsN' at line 1"
17:15:23,500 INFO [STDOUT] Vendor: 1064
17:15:23,500 INFO [STDOUT] access: on

I'm running eclipse 3.0.1 and MySQL on the same machine.

Is there a way to display the exact contents of the POST that the form
submits? I've tried using TcpMon from the Axis project but can't get
anything to show up.

Thanks,

Jack

===========================================================================
To unsubscribe: mailto listserv@(protected)".
For digest: mailto listserv@(protected)".

Some relevant archives, FAQs and Forums on JSPs can be found at:

http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
©2008 junlu.com - Jax Systems, LLC, U.S.A.