Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 8669 invoked from network); 20 Jan 2005 15:59:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 20 Jan 2005 15:59:03 -0000 Received: (qmail 51119 invoked by uid 500); 20 Jan 2005 15:58:30 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 51057 invoked by uid 500); 20 Jan 2005 15:58:29 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 51011 invoked by uid 99); 20 Jan 2005 15:58:29 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.mtctrains.com (HELO mail.mtctrains.com) (63.76.25.118) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 20 Jan 2005 07:58:27 -0800 Received: from MTC-MTA by mail.mtctrains.com with Novell_GroupWise; Thu, 20 Jan 2005 08:58:24 -0700 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.2 Date: Thu, 20 Jan 2005 08:58:18 -0700 From: "Dennis Payne" To: Subject: Re: JSP/JDBC question Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Looks like you put a statement intended for preparation into a regular statement. >>> jlauman@nwcascades.com 01-19-2005 18:23 >>> 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, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org