I am having a few problems and I cannot explain why this is happening. I am using a Java servlet to connect to an Oracle Database. Using the "SELECT * FROM <TABLENAME>" command, the servlet is to retrieve all results and display them in an html file. I am using Java servlets and RESIN servlet webserver.
The problem that I am having is that the servlet
a) Doesn't show the results at all. By this I mean that the servlet runs and executes the code, returns and no SQL exception errors but returns empty results.
b) The servlet shows some results. It shows all the results from a different table but when I try to add to the table so that it has 5 records, it only shows 4, as if the code or database does not update.
I can't understand why it would do this. When I execute "SELECT * FROM <TABLENAME>" it is fine and shows all the results on SQL PLUS*. Could it be my code or anything?
Copy of my coding (this used to work, but now it only returns empty results):