Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (herse.apache.org: domain of manjula.kutty@gmail.com
 designates 64.233.162.225 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=FtC3m5zBEHxja3352183o5hWSMXI6aDnY5PkV0oFtegkcp0oxV75j1NQYZWsEQ/dcG5pGpa0d0k1Ia5jpdXJ+NT++IgNH1biZZXeo/vPjoRx0E8R1NMAArPOn285ZNyRj5EedY/7GL8NehaLpG4yGb/JRz5aPQm0mN/9By/3xPA=
Message-ID: <59c2e1ec0702090958rb1d9cceo9590a7c98417997a@mail.gmail.com>
Date: Fri, 9 Feb 2007 09:58:33 -0800
From: "Manjula Kutty" <manjula.kutty@gmail.com>
To: derby-dev@db.apache.org
Subject: Re: CurrentOfTest.java in the client/server mode
In-Reply-To: <wjo8r6sz8zku.fsf@sun.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_41043_25053369.1171043913944"
References: <59c2e1ec0702061200n5d5a6c40l580ac4a17f03242a@mail.gmail.com>
	 <wjo8zm7qias0.fsf@sun.com>
	 <59c2e1ec0702071520w42c26c92nf649a5b5f67d01fc@mail.gmail.com>
	 <wjo8r6sz8zku.fsf@sun.com>

------=_Part_41043_25053369.1171043913944
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Knut,

Thanks for your clarification. It helps a lot. So for the time being I make
the CurrentOfTest.java to run only in the embedded mode and will open a jira
issue to address the difference in behaviour. If some one fixes that then
they can just uncomment the line specified in the test to make it runnable
in the n/w server mode

Thanks
Manjula


On 2/9/07, Knut Anders Hatlen <Knut.Hatlen@sun.com> wrote:
>
> Manjula Kutty <manjula.kutty@gmail.com> writes:
>
> > Thanks Knut for your clarification. Please bear in mind that I don't
> know
> > much about cursor states. But my strong feeling is that it should behave
> > similar in both embedded and n/w server, other than the difference in
> the
> > SQL states. But please find the attached test (which is a miniature of
> the
> > CurrentOfTest.java), where I expect that cursor.getCursorName() should
> > return null. And it works as expected in the embedded mode. But in N/w
> > server it has a cursor name. Is that the correct behaviour?? If so
> please
> > give me some more inputs..
>
> I'm not sure what's the correct behaviour for getCursorName(). The
> JDBC spec is vague on this issue, but the JDBC API Tutorial and
> Reference, Third Edition says that it should return "the SQL name of
> the cursor associated with this ResultSet object; null if this
> ResultSet object is read-only and its cursor name has not been
> specified with the Statement.setCursorName method". It also says that
> "[if] a DBMS supports positioned update/delete, and if the method
> Statement.setCursorName has not been called to specify a cursor name,
> the JDBC driver or the underlying DBMS must generate a cursor name
> when a SELECT ... FOR UPDATE" statement is executed."
>
> So, according to the tutorial, the embedded driver behaves correctly,
> whereas the network client doesn't.
>
> --
> Knut Anders
>

------=_Part_41043_25053369.1171043913944
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi Knut,</div>
<div>&nbsp;</div>
<div>Thanks for your clarification. It helps a lot. So for the time being I make the CurrentOfTest.java to run only in the embedded mode and will open a jira issue to address the difference in behaviour. If some one fixes that then they can just uncomment the line specified in the test to make it runnable in the n/w server mode
</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>Manjula<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 2/9/07, <b class="gmail_sendername">Knut Anders Hatlen</b> &lt;<a href="mailto:Knut.Hatlen@sun.com">Knut.Hatlen@sun.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Manjula Kutty &lt;<a href="mailto:manjula.kutty@gmail.com">manjula.kutty@gmail.com</a>&gt; writes:<br><br>
&gt; Thanks Knut for your clarification. Please bear in mind that I don&#39;t know<br>&gt; much about cursor states. But my strong feeling is that it should behave<br>&gt; similar in both embedded and n/w server, other than the difference in the
<br>&gt; SQL states. But please find the attached test (which is a miniature of the<br>&gt; CurrentOfTest.java), where I expect that cursor.getCursorName() should<br>&gt; return null. And it works as expected in the embedded mode. But in N/w
<br>&gt; server it has a cursor name. Is that the correct behaviour?? If so please<br>&gt; give me some more inputs..<br><br>I&#39;m not sure what&#39;s the correct behaviour for getCursorName(). The<br>JDBC spec is vague on this issue, but the JDBC API Tutorial and
<br>Reference, Third Edition says that it should return &quot;the SQL name of<br>the cursor associated with this ResultSet object; null if this<br>ResultSet object is read-only and its cursor name has not been<br>specified with the 
Statement.setCursorName method&quot;. It also says that<br>&quot;[if] a DBMS supports positioned update/delete, and if the method<br>Statement.setCursorName has not been called to specify a cursor name,<br>the JDBC driver or the underlying DBMS must generate a cursor name
<br>when a SELECT ... FOR UPDATE&quot; statement is executed.&quot;<br><br>So, according to the tutorial, the embedded driver behaves correctly,<br>whereas the network client doesn&#39;t.<br><br>--<br>Knut Anders<br></blockquote>
</div><br>

------=_Part_41043_25053369.1171043913944--