1. scrollable resultsets coderanch.com |
2. ResultSet not scrollable coderanch.comI 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.comHI, 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.comI 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.comFirst 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 ... |
7. Using a scrollable resultset to retrieve 'rowcount' coderanch.com |
8. Scrollable ResultSet coderanch.com |
9. Using scrollable resultset in stored procedures coderanch.com |
10. Scrollable ResultSet not working coderanch.comHi 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.comI 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.comMy 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.comScrollable 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 |
20. Scrollable Resultsets - Calling next Resultset forums.oracle.com |