wood burning stoves*
The moose likes JSP and the fly likes Why this 500 error - Is this DB related? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Why this 500 error - Is this DB related?" Watch "Why this 500 error - Is this DB related?" New topic
Author

Why this 500 error - Is this DB related?

John Bennet
Greenhorn

Joined: Nov 23, 2004
Posts: 15
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

Joined: Dec 06, 2004
Posts: 4
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Why this 500 error - Is this DB related?