Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Why this 500 error - Is this DB related?

 
John Bennet
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

While trying to save data, I get the following error 500:

javax.servlet.ServletException: [SQL0104] Token S was not valid. Valid tokens: <END-OF-STATEMENT>.
com.tcg.content.SaveContentServlet.doGet(SaveContentServlet.java:263)
com.tcg.content.SaveContentServlet.doPost(SaveContentServlet.java:42)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
com.tcg.user.AdminOnlyServlet.service(AdminOnlyServlet.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

com.tcg.PokemonException: [SQL0104] Token S was not valid. Valid tokens: <END-OF-STATEMENT>.
com.tcg.content.SaveContentServlet.doGet(SaveContentServlet.java:245)
com.tcg.content.SaveContentServlet.doPost(SaveContentServlet.java:42)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
com.tcg.user.AdminOnlyServlet.service(AdminOnlyServlet.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


note The full stack trace of the root cause is available in the Apache Tomcat/5.0.27 logs.
 
Marty Strzembicki
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would check your SQL statement, whenever "TOKEN" is mentioned in the description of the error, it's most likely SQL related. Verify the names of your table columns and check for proper comma seperation.
[ December 09, 2004: Message edited by: Marty Strzembicki ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic