This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile 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