Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Invalid cursor position using updatable result set with JDBC.

10 posts in General Discussion Last posting was on 2005-03-01 14:34:15.0Z
Bill Williams Posted on 2005-02-17 22:19:38.0Z
From: Bill Williams <billwilliams@qcsoftware.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040805 Netscape/7.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Invalid cursor position using updatable result set with JDBC.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 0-1pool229-252.nas8.westchester1.oh.us.da.qwest.net
Message-ID: <42151876@forums-2-dub>
X-Original-Trace: 17 Feb 2005 14:19:34 -0800, 0-1pool229-252.nas8.westchester1.oh.us.da.qwest.net
Lines: 14
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2005 14:19:37 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2005 14:19:38 -0800
X-Trace: forums-1-dub 1108678778 10.22.108.75 (17 Feb 2005 14:19:38 -0800)
X-Original-Trace: 17 Feb 2005 14:19:38 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4144
Article PK: 8027

I'm using the iAnywhere JDBC driver. I am creating a forward only
updatable result set. When I try to actually perform the update on the
result set, I get the following error: [Sybase][ODBC Driver]Invalid
cursor position.

When I try this same code using the jConnect 5.5 JDBC driver, everything
works (it also works on an Oracle database using their JDBC driver);
therefore, I don't believe it's a problem with the way I've written the
code.

Does ODBC not support updatable result sets?

I have tried running my code against ASA 8.0.3 build 5182 on Linux and
ASA 9.0.1 build 1922 on Windows XP.


Robert Waywell Posted on 2005-02-18 15:36:18.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <42151876@forums-2-dub>
Subject: Re: Invalid cursor position using updatable result set with JDBC.
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: wireless-wat-5.sybase.com
X-Original-NNTP-Posting-Host: wireless-wat-5.sybase.com
Message-ID: <42160b72@forums-1-dub>
Date: 18 Feb 2005 07:36:18 -0800
X-Trace: forums-1-dub 1108740978 10.25.109.134 (18 Feb 2005 07:36:18 -0800)
X-Original-Trace: 18 Feb 2005 07:36:18 -0800, wireless-wat-5.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4145
Article PK: 8024

Can you show us the code snippet that is generating the error?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Bill Williams" <billwilliams@qcsoftware.com> wrote in message
news:42151876@forums-2-dub...
> I'm using the iAnywhere JDBC driver. I am creating a forward only
> updatable result set. When I try to actually perform the update on the
> result set, I get the following error: [Sybase][ODBC Driver]Invalid
> cursor position.
>
> When I try this same code using the jConnect 5.5 JDBC driver, everything
> works (it also works on an Oracle database using their JDBC driver);
> therefore, I don't believe it's a problem with the way I've written the
> code.
>
> Does ODBC not support updatable result sets?
>
> I have tried running my code against ASA 8.0.3 build 5182 on Linux and
> ASA 9.0.1 build 1922 on Windows XP.


Bill Williams Posted on 2005-02-18 17:10:30.0Z
From: Bill Williams <billwilliams@qcsoftware.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040805 Netscape/7.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Invalid cursor position using updatable result set with JDBC.
References: <42151876@forums-2-dub> <42160b72@forums-1-dub>
In-Reply-To: <42160b72@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 0-1pool229-47.nas8.westchester1.oh.us.da.qwest.net
Message-ID: <42162182@forums-2-dub>
X-Original-Trace: 18 Feb 2005 09:10:26 -0800, 0-1pool229-47.nas8.westchester1.oh.us.da.qwest.net
Lines: 28
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Feb 2005 09:10:27 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Feb 2005 09:10:30 -0800
X-Trace: forums-1-dub 1108746630 10.22.108.75 (18 Feb 2005 09:10:30 -0800)
X-Original-Trace: 18 Feb 2005 09:10:30 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4149
Article PK: 8026

Here's a snipet that causes the problem. The variable "conn" is a
Connection object.

Statement s = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,

ResultSet.CONCUR_UPDATABLE);
ResultSet r = s.executeQuery("select wcs_mu.*" +
" from wcs_mu" +
" where interface_status
in('INSERTED', 'DELETE')");
while(r.next())
{
r.updateObject(2, "UPDATED");
r.updateRow();
}
s.close();

The call to updateRow is what throws the exception.

In the stack trace, it states "at
ianywhere.ml.jdbcodbc.IResultSet.updateRow(Native Method)".

Robert Waywell wrote:

>Can you show us the code snippet that is generating the error?
>
>
>


Bill Williams Posted on 2005-02-24 14:41:27.0Z
From: Bill Williams <billwilliams@qcsoftware.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040805 Netscape/7.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Invalid cursor position using updatable result set with JDBC.
References: <42151876@forums-2-dub> <42160b72@forums-1-dub> <42162182@forums-2-dub>
In-Reply-To: <42162182@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 0-1pool229-137.nas8.westchester1.oh.us.da.qwest.net
X-Original-NNTP-Posting-Host: 0-1pool229-137.nas8.westchester1.oh.us.da.qwest.net
Message-ID: <421de797@forums-1-dub>
Date: 24 Feb 2005 06:41:27 -0800
X-Trace: forums-1-dub 1109256087 65.134.229.137 (24 Feb 2005 06:41:27 -0800)
X-Original-Trace: 24 Feb 2005 06:41:27 -0800, 0-1pool229-137.nas8.westchester1.oh.us.da.qwest.net
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4161
Article PK: 8041

Any ideas?

Bill Williams wrote:

> Here's a snipet that causes the problem. The variable "conn" is a
> Connection object.
>
> Statement s = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
>
> ResultSet.CONCUR_UPDATABLE);
> ResultSet r = s.executeQuery("select wcs_mu.*" +
> " from wcs_mu" +
> " where interface_status
> in('INSERTED', 'DELETE')");
> while(r.next())
> {
> r.updateObject(2, "UPDATED");
> r.updateRow();
> }
> s.close();
>
> The call to updateRow is what throws the exception.
>
> In the stack trace, it states "at
> ianywhere.ml.jdbcodbc.IResultSet.updateRow(Native Method)".
>
> Robert Waywell wrote:
>
>> Can you show us the code snippet that is generating the error?
>>
>>
>>


Robert Waywell Posted on 2005-02-25 13:18:42.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <42151876@forums-2-dub> <42160b72@forums-1-dub> <42162182@forums-2-dub> <421de797@forums-1-dub>
Subject: Re: Invalid cursor position using updatable result set with JDBC.
Lines: 64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <421f25ae$1@forums-2-dub>
X-Original-Trace: 25 Feb 2005 05:18:38 -0800, rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Feb 2005 05:18:39 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Feb 2005 05:18:42 -0800
X-Trace: forums-1-dub 1109337522 10.22.108.75 (25 Feb 2005 05:18:42 -0800)
X-Original-Trace: 25 Feb 2005 05:18:42 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4165
Article PK: 8045

Hi Bill,
Sorry for the slow response. I'm asking a couple of questions here. In
the meantime, can you check the ODBC configuration and let me know if you
have Prefetch enabled? On the "Advanced" tab of the DSN there is a checkbox
for "Allow multiple record fetching"

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Bill Williams" <billwilliams@qcsoftware.com> wrote in message
news:421de797@forums-1-dub...
> Any ideas?
>
> Bill Williams wrote:
>
> > Here's a snipet that causes the problem. The variable "conn" is a
> > Connection object.
> >
> > Statement s = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
> >
> > ResultSet.CONCUR_UPDATABLE);
> > ResultSet r = s.executeQuery("select wcs_mu.*" +
> > " from wcs_mu" +
> > " where interface_status
> > in('INSERTED', 'DELETE')");
> > while(r.next())
> > {
> > r.updateObject(2, "UPDATED");
> > r.updateRow();
> > }
> > s.close();
> >
> > The call to updateRow is what throws the exception.
> >
> > In the stack trace, it states "at
> > ianywhere.ml.jdbcodbc.IResultSet.updateRow(Native Method)".
> >
> > Robert Waywell wrote:
> >
> >> Can you show us the code snippet that is generating the error?
> >>
> >>
> >>


Bill Williams Posted on 2005-02-25 13:35:25.0Z
From: Bill Williams <billwilliams@qcsoftware.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040805 Netscape/7.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Invalid cursor position using updatable result set with JDBC.
References: <42151876@forums-2-dub> <42160b72@forums-1-dub> <42162182@forums-2-dub> <421de797@forums-1-dub> <421f25ae$1@forums-2-dub>
In-Reply-To: <421f25ae$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 0-1pool229-76.nas8.westchester1.oh.us.da.qwest.net
X-Original-NNTP-Posting-Host: 0-1pool229-76.nas8.westchester1.oh.us.da.qwest.net
Message-ID: <421f299d@forums-1-dub>
Date: 25 Feb 2005 05:35:25 -0800
X-Trace: forums-1-dub 1109338525 65.134.229.76 (25 Feb 2005 05:35:25 -0800)
X-Original-Trace: 25 Feb 2005 05:35:25 -0800, 0-1pool229-76.nas8.westchester1.oh.us.da.qwest.net
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4166
Article PK: 8044

On my Windows XP computer, the "Allow multiple record fetching" option
is checked.

On my linux computer, I don't have a GUI interface for the ODBC, but
here is the entry from the odbc.ini file:

[dcms]
Description = Under Armour DCMS
Driver = Sybase ASA 8.0.0
Userid = xxx
Password = xxx
ServerName = asa800
DatabaseName = dcms
AutoStart = NO
AutoStop = NO
Unconditional = YES
DisableMultiRowFetch = NO
Debug = NO
AutoCommit = NO

Robert Waywell wrote:

>Hi Bill,
> Sorry for the slow response. I'm asking a couple of questions here. In
>the meantime, can you check the ODBC configuration and let me know if you
>have Prefetch enabled? On the "Advanced" tab of the DSN there is a checkbox
>for "Allow multiple record fetching"
>
>
>


Robert Waywell Posted on 2005-02-28 12:38:34.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <42151876@forums-2-dub> <42160b72@forums-1-dub> <42162182@forums-2-dub> <421de797@forums-1-dub> <421f25ae$1@forums-2-dub> <421f299d@forums-1-dub>
Subject: Re: Invalid cursor position using updatable result set with JDBC.
Lines: 75
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <422310ca$1@forums-1-dub>
Date: 28 Feb 2005 04:38:34 -0800
X-Trace: forums-1-dub 1109594314 10.25.98.201 (28 Feb 2005 04:38:34 -0800)
X-Original-Trace: 28 Feb 2005 04:38:34 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4169
Article PK: 8047

Hi Bill,
I had someone look at the code snippet you sent and we didn't see
anything obviously wrong. You can try disabling the multirow fetch to see if
that changes the behaviour. That would be the checkbox in the Windows ODBC
configuration or this line - > DisableMultiRowFetch = NO - in the Linux
ODBC config file. With prefetch enabled, the engine will fill a packet with
multiple rows when a fetch request is made, rather than sending only the
single row. The client will then buffer the rows and return individual rows
to the application. The benefit of this is reduced network traffic.

There is a chance that the engine thinks it has already moved beyond the
record you are trying to update. If that is the case, then turning off
prefetch may resolve the issue.

Let me know if disabling the multirow fetch/turning off prefetch has any
effect.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Bill Williams" <billwilliams@qcsoftware.com> wrote in message
news:421f299d@forums-1-dub...
> On my Windows XP computer, the "Allow multiple record fetching" option
> is checked.
>
> On my linux computer, I don't have a GUI interface for the ODBC, but
> here is the entry from the odbc.ini file:
>
> [dcms]
> Description = Under Armour DCMS
> Driver = Sybase ASA 8.0.0
> Userid = xxx
> Password = xxx
> ServerName = asa800
> DatabaseName = dcms
> AutoStart = NO
> AutoStop = NO
> Unconditional = YES
> DisableMultiRowFetch = NO
> Debug = NO
> AutoCommit = NO
>
> Robert Waywell wrote:
>
> >Hi Bill,
> > Sorry for the slow response. I'm asking a couple of questions here.
In
> >the meantime, can you check the ODBC configuration and let me know if you
> >have Prefetch enabled? On the "Advanced" tab of the DSN there is a
checkbox
> >for "Allow multiple record fetching"
> >
> >
> >


Bill Williams Posted on 2005-03-01 13:59:39.0Z
From: Bill Williams <billwilliams@qcsoftware.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Invalid cursor position using updatable result set with JDBC.
References: <42151876@forums-2-dub> <42160b72@forums-1-dub> <42162182@forums-2-dub> <421de797@forums-1-dub> <421f25ae$1@forums-2-dub> <421f299d@forums-1-dub> <422310ca$1@forums-1-dub>
In-Reply-To: <422310ca$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: nr4-216-196-154-6.fuse.net
Message-ID: <42247546$1@forums-2-dub>
X-Original-Trace: 1 Mar 2005 05:59:34 -0800, nr4-216-196-154-6.fuse.net
Lines: 21
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 1 Mar 2005 05:59:36 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Mar 2005 05:59:39 -0800
X-Trace: forums-1-dub 1109685579 10.22.108.75 (1 Mar 2005 05:59:39 -0800)
X-Original-Trace: 1 Mar 2005 05:59:39 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4171
Article PK: 8048

Has anyone been able to re-create the problem there or am I just the
lucky one?

Robert Waywell wrote:
> Hi Bill,
> I had someone look at the code snippet you sent and we didn't see
> anything obviously wrong. You can try disabling the multirow fetch to see if
> that changes the behaviour. That would be the checkbox in the Windows ODBC
> configuration or this line - > DisableMultiRowFetch = NO - in the Linux
> ODBC config file. With prefetch enabled, the engine will fill a packet with
> multiple rows when a fetch request is made, rather than sending only the
> single row. The client will then buffer the rows and return individual rows
> to the application. The benefit of this is reduced network traffic.
>
> There is a chance that the engine thinks it has already moved beyond the
> record you are trying to update. If that is the case, then turning off
> prefetch may resolve the issue.
>
> Let me know if disabling the multirow fetch/turning off prefetch has any
> effect.
>


Chris Keating (iAnywhere Solutions) Posted on 2005-03-01 14:34:15.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <42151876@forums-2-dub> <42160b72@forums-1-dub> <42162182@forums-2-dub> <421de797@forums-1-dub> <421f25ae$1@forums-2-dub> <421f299d@forums-1-dub> <422310ca$1@forums-1-dub> <42247546$1@forums-2-dub>
Subject: Re: Invalid cursor position using updatable result set with JDBC.
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <42247d67$1@forums-1-dub>
Date: 1 Mar 2005 06:34:15 -0800
X-Trace: forums-1-dub 1109687655 10.25.98.199 (1 Mar 2005 06:34:15 -0800)
X-Original-Trace: 1 Mar 2005 06:34:15 -0800, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4172
Article PK: 8049

You'll probably need to contact Technical Support to get this issue
resolved. Within North America, you can reach Technical Support by calling
1-800-8SYBASE. If you are located outside of North America, you can find
the contact information for your local Sybase Support Center by going
to the Sybase home page at http://www.sybase.com, clicking on the "Support"
link at the top of the page, and then choosing "Support Centers" from the
left hand frame.

You can always report a bug for free by visiting CaseXpress at
http://casexpress.sybase.com/cx/cx.stm. When submitting calls through
CaseXpress,
please make sure to give an accurate description of the steps you take to
reproduce the bug, and include any files that may be needed (database,
source code) to reproduce the problem.

/ck

"Bill Williams" <billwilliams@qcsoftware.com> wrote in message
news:42247546$1@forums-2-dub...
> Has anyone been able to re-create the problem there or am I just the lucky
> one?
>
> Robert Waywell wrote:
>> Hi Bill,
>> I had someone look at the code snippet you sent and we didn't see
>> anything obviously wrong. You can try disabling the multirow fetch to see
>> if
>> that changes the behaviour. That would be the checkbox in the Windows
>> ODBC
>> configuration or this line - > DisableMultiRowFetch = NO - in the
>> Linux
>> ODBC config file. With prefetch enabled, the engine will fill a packet
>> with
>> multiple rows when a fetch request is made, rather than sending only the
>> single row. The client will then buffer the rows and return individual
>> rows
>> to the application. The benefit of this is reduced network traffic.
>>
>> There is a chance that the engine thinks it has already moved beyond
>> the
>> record you are trying to update. If that is the case, then turning off
>> prefetch may resolve the issue.
>>
>> Let me know if disabling the multirow fetch/turning off prefetch has
>> any
>> effect.
>>


Bill Williams Posted on 2005-02-28 17:02:37.0Z
From: Bill Williams <billwilliams@qcsoftware.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Invalid cursor position using updatable result set with JDBC.
References: <42151876@forums-2-dub> <42160b72@forums-1-dub> <42162182@forums-2-dub> <421de797@forums-1-dub> <421f25ae$1@forums-2-dub> <421f299d@forums-1-dub> <422310ca$1@forums-1-dub>
In-Reply-To: <422310ca$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: nr4-216-196-156-136.fuse.net
Message-ID: <42234ea9$1@forums-2-dub>
X-Original-Trace: 28 Feb 2005 09:02:33 -0800, nr4-216-196-156-136.fuse.net
Lines: 20
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Feb 2005 09:02:34 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Feb 2005 09:02:37 -0800
X-Trace: forums-1-dub 1109610157 10.22.108.75 (28 Feb 2005 09:02:37 -0800)
X-Original-Trace: 28 Feb 2005 09:02:37 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4170
Article PK: 8050

I just tried it on my Windows XP computer and it did not help.

Robert Waywell wrote:
> Hi Bill,
> I had someone look at the code snippet you sent and we didn't see
> anything obviously wrong. You can try disabling the multirow fetch to see if
> that changes the behaviour. That would be the checkbox in the Windows ODBC
> configuration or this line - > DisableMultiRowFetch = NO - in the Linux
> ODBC config file. With prefetch enabled, the engine will fill a packet with
> multiple rows when a fetch request is made, rather than sending only the
> single row. The client will then buffer the rows and return individual rows
> to the application. The benefit of this is reduced network traffic.
>
> There is a chance that the engine thinks it has already moved beyond the
> record you are trying to update. If that is the case, then turning off
> prefetch may resolve the issue.
>
> Let me know if disabling the multirow fetch/turning off prefetch has any
> effect.
>