469,954 Members | 1,637 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,954 developers. It's quick & easy.

DB2 EE (or Connect) and iSeries Scrollable cursor problem

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
================================================== ==========

Jun 26 '06 #1
2 2020
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
Jun 26 '06 #2
Thank You Karl!

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

Jun 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by GAS | last post: by
3 posts views Thread by DarthMacgyver | last post: by
1 post views Thread by Brami Yair | last post: by
1 post views Thread by Yanik Reid | last post: by
reply views Thread by Dominic Paquette | last post: by
6 posts views Thread by Tomek | last post: by
menayah
1 post views Thread by menayah | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.