Win a copy of Java EE 8 High Performance this week in the Java/Jakarta EE forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JSPs and SQL, displaying results error  RSS feed

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?

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!