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.

Cursor behavior using JDBC

2 posts in General Discussion Last posting was on 2009-07-02 14:50:58.0Z
Yaniv C. Posted on 2009-07-02 13:58:02.0Z
Sender: 3a64.4a4cbbb9.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: Cursor behavior using JDBC
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a4cbcea.3b5b.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 2 Jul 2009 06:58:02 -0700
X-Trace: forums-3-dub.sybase.com 1246543082 10.22.241.188 (2 Jul 2009 06:58:02 -0700)
X-Original-Trace: 2 Jul 2009 06:58:02 -0700, forums-3-dub.sybase.com
Lines: 17
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27945
Article PK: 77191

Hi
I am using Sybase ASE 15.0.2 ESD 2 on Linux.
I have small stored procedure that opens a cursor and for
each record insert a record into a table.
when executing the SP using isql, number of insert records
are 3000, when calling the SP from Java using JDBC, the
number of records that inserted, number of rows fetched are
56!!
Does anyone familiar with a JDBC property, that limited the
number of fetches?
Does anyone familiar which such a problem in the past?

This is really frustrating...
I am out of solutions

Thanks,
Yaniv


Yaniv C. Posted on 2009-07-02 14:50:58.0Z
Sender: 3a64.4a4cbbb9.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: Re: Cursor behavior using JDBC - Solved
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a4cc952.44a3.1681692777@sybase.com>
References: <4a4cbcea.3b5b.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 2 Jul 2009 07:50:58 -0700
X-Trace: forums-3-dub.sybase.com 1246546258 10.22.241.188 (2 Jul 2009 07:50:58 -0700)
X-Original-Trace: 2 Jul 2009 07:50:58 -0700, forums-3-dub.sybase.com
Lines: 24
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27947
Article PK: 77195

Hi
Just to update you all, Solved.
Just use executeUpdate() and not execute() method in the
statement object.

> Hi
> I am using Sybase ASE 15.0.2 ESD 2 on Linux.
> I have small stored procedure that opens a cursor and for
> each record insert a record into a table.
> when executing the SP using isql, number of insert records
> are 3000, when calling the SP from Java using JDBC, the
> number of records that inserted, number of rows fetched
> are 56!!
> Does anyone familiar with a JDBC property, that limited
> the number of fetches?
> Does anyone familiar which such a problem in the past?
>
> This is really frustrating...
> I am out of solutions
>
> Thanks,
> Yaniv