Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSPs and SQL, displaying results error

Bob Backlund
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I'm not sure if this wants to be under the JSP forum or SQL, but I'll have a go.

I've writtena small program which uses JSP front end and SQL database at teh back, simply allowing people to enter some details into a DB and display the results to page (pretty standarrd stuff).

But I seem to be having a strange anomaly occur. Ever so often, on what seems to be a random row and colum from the DB, the output JSP doesn't show a result (e.g. all the "date entered" values from 1-20 are displayed apart from 3, 15 and 18 which are left blank!), In the WAS log I get a
"No such column COLUMNNAME" error, but as I say, the next row will display the value.

Has anyone else ever had this mysterious disappearing values, and does anyone know how to get them back?

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic