This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
I have a postgreSQL table populated with data. Integers. I have used JDBC stuff before to get data out of the table. This time I need to only see one record at a time. The stuff I used before, the "while res.next()" queries all the records and displays all of them latter at bottom of code.
I need to know how to get it to show me only one record at a time. I have buttons on GUI that I will connect to this. A forward and back button.
Through searching I have come across hints to use a rowset. I also came across advice to use JdbcRowSet with java 1.5. I tried some examples but I am still getting back from eclipse error that the cursor type is forward only.
Here is what I have been trying
Error Message from eclipse SQL Exception: PostgreSQL Connection Failed Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.
According to all the stuff I have found about the JdbcRowSet it is scrollable by default. I dont have to set it.
anyone have an idea? or another suggestion for what to use to navigate through the records one at a time?