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?