The code being used is causing some problems.When i iterate through the resultset to print all the rows of the table, the resultset does not have the data of newly inserted row. Everytime it shows all the data except the freshly inserted data. This is causing problems in my application as the newly inserted data is not shown.

I explored web for this, everywhere its said that this kind of insertion mechansim using ResultSet object updates the ResultSet as well as the underlying database. But in my case the ResultSet does not show the new data, where as the database has the newly inserted row.