Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

error  RSS feed

 
pinakin patel
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi everybody i have an error when my jsp calls my servlet when i click on the save button i get this error the exact error is
SQLException :
Syntax error or access violation: You have an error in your SQL syntax near '_config, mdms_amc_wty, mdms_inst, mdms_not_covparts,tpds_qty, tpds_config, tpds_' at line 1
 
Timmy Marks
Ranch Hand
Posts: 226
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you post your entire SQL query? It would probably help diagnose the problem.
Make sure that all your table/column names are spelled correctly. That could be the problem.
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This post belongs in JDBC.. I will request it be moved. Notice that your problem is an SQLException specifically and has nothing at all to do with JSP?
 
Jim Yingst
Wanderer
Sheriff
Posts: 18671
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm moving this to JDBC.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!