DB2 EE (or Connect) and iSeries Scrollable cursor problem

[roberto]

Hello,
I'm trying to retrieve some records in my web application using a jdbc
Statement like this:

statement =
connection.createStatement(ResultSet.TYPE_SCROLL_I NSENSITIVE,ResultSet.CONCUR_READ_ONLY);
resultSet = statement.executeQuery(...);

with DB2 v8.2 EE that has a connection to an iSeries v5.3 and JBoss as
application server.

If I call the last() method on the ResultSet it works fine at the
beginning.
Later if a reset the application url to the context root, and I reenter
the application it throws the following error when it reaches the
last() method:

This method should only be called on ResultSet objects that are
scrollable(type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE)]
at com.ibm.db2.jcc.b.kf.nb(kf.java:3454)

The same thing happens if I call the isLast() method.
It seems that something becomes dirty into the driver and it stops to
run correctly.
If I run the same code with a DB2 database that has not a connection to
an iSeries, all works fine.

Classe containing that kind of code are BMP entities...

Any Idea?

Thank You!!!

Roberto

db2 EE version detail:
================================================== ==========
About DB2 Administration Tools Environment
================================================== ==========
DB2 administration tools level:
Product identifier SQL08025
Level identifier 03060106
Level DB2 v8.1.12.99
Build level s060429
PTF WR21368
================================================== ==========
Java development kit (JDK):
Level IBM Corporation 1.4.1
================================================== ==========

[Karl Hanson]

roberto wrote:

Hello,
I'm trying to retrieve some records in my web application using a jdbc
Statement like this:

statement =
connection.createStatement(ResultSet.TYPE_SCROLL_I NSENSITIVE,ResultSet.CONCUR_READ_ONLY);
resultSet = statement.executeQuery(...);

with DB2 v8.2 EE that has a connection to an iSeries v5.3 and JBoss as
application server.

If I call the last() method on the ResultSet it works fine at the
beginning.
Later if a reset the application url to the context root, and I reenter
the application it throws the following error when it reaches the
last() method:

This method should only be called on ResultSet objects that are
scrollable(type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE)]
at com.ibm.db2.jcc.b.kf.nb(kf.java:3454)

The same thing happens if I call the isLast() method.
It seems that something becomes dirty into the driver and it stops to
run correctly.
If I run the same code with a DB2 database that has not a connection to
an iSeries, all works fine.

Classe containing that kind of code are BMP entities...

Any Idea?

<snip>

On the iSeries check that you have the latest DB Group PTF installed:
http://www-912.ibm.com/s_dir/slkbase...commendedfixes
In particular, these PTFs may be relevant: SI24258 v5r3, SI24257 v5r4

If you still have the problem, I recommend contacting your IBM Service
provider. The JCC cursor management aspect may need to be investigated.

--
Karl Hanson

[roberto]

Thank You Karl!

I haven't that kind of PTF installed.
ASAP i will install it and try again.