On Thu, 03 Mar 2005 14:49:16 +0530, Shreyas Kaushik <[EMAIL PROTECTED]> wrote: > Just to clarify, does this mean that using the JCC driver I can have > scrollable updatabale ResultSets although Derby > does not support it ? > > thanks > Shreyas > > Mamta A. Satoor (JIRA) wrote: > > > [ > > http://issues.apache.org/jira/browse/DERBY-154?page=comments#action_60102 ] > > > >Mamta A. Satoor commented on DERBY-154: > >--------------------------------------- > > > >I did some looking through the JCC driver code and the problem is in how JCC > >class Connection.java handles resultset type downgrading. Since Derby does > >not support scroll sensitive resultsets, JCC code should downgrade resultset > >type to scroll insensitive. I will try to work with the JCC team on this. > >People working on the Derby Net Client - similar change might be necessary > >in the Derby Net Client code too. > > > > > > > >>Does Network Server support scroll sensitive read-only and updatable > >>resultsets? > >>-------------------------------------------------------------------------------- > >> > >> Key: DERBY-154 > >> URL: http://issues.apache.org/jira/browse/DERBY-154 > >> Project: Derby > >> Type: Bug > >> Components: Network Server > >> Versions: 10.0.2.1 > >> Reporter: Mamta A. Satoor > >> > >> > > > > > > > >>Derby in embedded mode does not support scroll sensitive resultsets in both > >>read-only and updatable modes. But when I write a simple test program in > >>Network Server configuration, it appears that scroll sensitive resultsets > >>are supported both in read-only and updatable modes. Is that correct? > >>Connection con = > >>DriverManager.getConnection("jdbc:derby:net://localhost:1527/db1drda;create=true:retrieveMessagesFromServerOnGetMessage=true:deferPrepares=false;", > >> "app", "app"); > >>Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, > >>ResultSet.CONCUR_READ_ONLY); > >>SQLWarning warnings = con.getWarnings(); > >>while (warnings != null) > >>{ > >> System.out.println("warnings on connection = " + warnings); > >> warnings = warnings.getNextWarning(); > >>} > >>System.out.println("Did we get TYPE_SCROLL_SENSITIVE? " + > >>(s.getResultSetType() == ResultSet.TYPE_SCROLL_SENSITIVE)); > >>System.out.println("Did we get CONCUR_READ_ONLY? " + > >>(s.getResultSetConcurrency() == ResultSet.CONCUR_READ_ONLY)); > >>s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, > >>ResultSet.CONCUR_UPDATABLE); > >>System.out.println("Did we get TYPE_SCROLL_SENSITIVE? " + > >>(s.getResultSetType() == ResultSet.TYPE_SCROLL_SENSITIVE)); > >>System.out.println("Did we get CONCUR_UPDATABLE? " + > >>(s.getResultSetConcurrency() == ResultSet.CONCUR_UPDATABLE)); > >>And the output in Network Server mode for above test case is > >>Did we get TYPE_SCROLL_SENSITIVE? true > >>Did we get CONCUR_READ_ONLY? true > >>Did we get TYPE_SCROLL_SENSITIVE? true > >>Did we get CONCUR_UPDATABLE? true > >> > >> > > > > > > >
No, there is no scrollable resultset support both in embedded and Network Server mode (coming through JCC or soon to be available Derby Net Client). thanks, Mamta
