Scrollable « Resultset « Java Database Q&A





1. scrollable resultsets    coderanch.com

2. ResultSet not scrollable    coderanch.com

I am using jdk1.2.2, Oracle 8i with Oracle jdbc classes12.zip 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 ...

3. SCROLLABLE RESULTSET PROBLEM    coderanch.com

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    coderanch.com

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    coderanch.com

6. Scrollable ResultSet    coderanch.com

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    coderanch.com





10. Scrollable ResultSet not working    coderanch.com

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 classes12.zip Thanks in advance [ June 28, 2005: Message edited by: Navin Pillu ]

11. Making ResultSet object scrollable    coderanch.com

12. Scrollable ResultSet    coderanch.com

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    coderanch.com

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    coderanch.com

15. how to make a ResultSet scrollable    coderanch.com

16. Scrollable ResultSets with JDev 3.1.12    coderanch.com





17. Scrollable ResultSet    coderanch.com

18. [ResultSet] Scrollable vs Default    coderanch.com

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    forums.oracle.com