Not sure if there is a typo in your email or if your copy of the Category.xml file somehow got buggered up, but there is a trailing "." on the select statement there. That would make it puke, but like I said, I am not positive that that is the real problem, or just a weird typo. Can you check it and let use know?
Larry On 10/28/06, Martin Gainty <[EMAIL PROTECTED]> wrote:
Has anyone encountered this error with the spring jpetstore sample and know the solution?org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Category.xml. --- The error occurred while executing query. --- Check the select catid,name,descn from category where catid = 'dog' . --- Check the SQL Statement (preparation failed). Many Thanks,Martin --This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
