Scrollable « Resultset « Java Database Q&A

1. scrollable resultsets

2. ResultSet not scrollable

I am using jdk1.2.2, Oracle 8i with Oracle jdbc driver I create a result set as below: _____________________________________________ Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2"); __________________________________________________ I expect that my result set will be scollable. I can iterate my result set object in a while and again come back to the first first ...


HI, I've got a problem getting my resultset to be scrollable. I'm using Tomcat 4.0, MySQL, on W98. All other stuff seems to work( up to my poor sql level anyway). This is the line that causes runtime (not compiler) error: Statement s = DBConx.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE , ResultSet.CONCUR_UPDATABLE ) ; The code is fine - I copied it from the Resultset ...

4. scrollable ResultSet

I want to scroll the Record with rs.prevoius()so what can i do for this below in this code a sql "UnsupportedOpertationException" genreted in runtime try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:MyData"); stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //stmt = con.createStatement( ); //System.out.println("Stmt Created"); //stmt.setFetchSize(25); rs= stmt.executeQuery("Select * from Directory"); System.out.println("con created"); }catch(Exception e){System.out.println("Sql error :" +e);} ENTER.addActionListener(this); SAVE.addActionListener(this); VIEW.addActionListener(this); } public void actionPerformed(ActionEvent ae) { ...

5. Scrollable ResultSet

6. Scrollable ResultSet

First off, the JDBC 2.0 is outlined by the java.sql specification ( not javax.sql ) so no further downloads are needed as it is included in the sdk 1.2 and up. But, most classes ( including Connection, ResultSet, Statement and most other classes ) are only an interface. So you have to find a jdbc driver to access your database that ...

8. Scrollable ResultSet

10. Scrollable ResultSet not working

Hi All I'm trying to use scrollable resultset. File is getting compiled but runtime throwing an exception. if we remove ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE from createStatement() method program woeks fine Can anybody tell me why it is doing like this. Server Tomcat 4.1.3 jdk1.4 Thanks in advance [ June 28, 2005: Message edited by: Navin Pillu ]

11. Making ResultSet object scrollable

12. Scrollable ResultSet

I second the previous post. In addition, this is in part because in at least some of the major database, scrolling result sets either don't perform particularly efficiently, or because the entire result set gets cached by the driver in memory, or both. In other words, they're best used for small results, and for small results is often easier to use ...

13. JDBC Scrollable ResultSet

My current company already have a framework in place and in their framework they have a class that handles all the database connectivity (including pooling) and statement preparation/executions. Tried doing some scrolling on the returned resultset but ended up with an exception. With some checking, I noticed that the returned resultset is nonscrollable. Looking at the framework code, seems like it ...

14. scrollable resultset

15. how to make a ResultSet scrollable

16. Scrollable ResultSets with JDev 3.1.12

17. Scrollable ResultSet

18. [ResultSet] Scrollable vs Default

Scrollable will allow you to traverse the fetched rows in any diection (backward and forward) using the next() and previous() methods. The non scrollable version will throw some exception on using the previous() method. You can define the type of resultset using the constructor (Not completely sure of this) Write a sample program to verify that.

19. scrollable resultset