db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: [jira] Commented: (DERBY-154) Does Network Server support scroll sensitive read-only and updatable resultsets?
Date Thu, 03 Mar 2005 16:34:03 GMT
On Thu, 03 Mar 2005 14:49:16 +0530, Shreyas Kaushik
<Shreyas.Kaushik@sun.com> 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

Mime
View raw message