This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes CLI0627E  The result set is not scrollable. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CLI0627E  The result set is not scrollable." Watch "CLI0627E  The result set is not scrollable." New topic
Author

CLI0627E The result set is not scrollable.

Deepa Raj
Greenhorn

Joined: Nov 17, 2005
Posts: 3
hi All,

i m using WSAD5.1.2 , JDBC 2.0 , DB2 7.2.3 .

i m getting the following exception.Plz help me to rectify this.
[11/14/05 18:30:01:515 IST] 6900690 SystemErr R java.sql.SQLException: [IBM][JDBC Driver] CLI0627E The result set is not scrollable.
[11/14/05 18:30:01:531 IST] 6900690 SystemErr R at java.lang.Throwable.<init>(Throwable.java)
[11/14/05 18:30:01:531 IST] 6900690 SystemErr R at java.lang.Throwable.<init>(Throwable.java)
[11/14/05 18:30:01:531 IST] 6900690 SystemErr R at java.sql.SQLException.<init>(SQLException.java:90)
[11/14/05 18:30:01:531 IST] 6900690 SystemErr R at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throwNotScrollable(SQLExceptionGenerator.java:761)
[11/14/05 18:30:01:531 IST] 6900690 SystemErr R at COM.ibm.db2.jdbc.app.DB2ResultSet.getRow(DB2ResultSet.java:3188)

thanks.
Ram Mohan
Greenhorn

Joined: Oct 21, 2005
Posts: 26
Did you make it Scroll Intensive.

smt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);


Ram Mohan
Deepa Raj
Greenhorn

Joined: Nov 17, 2005
Posts: 3
Hi ,

Actually we are using , Callable Statement.......One more thing the same code is working in onsite.but in offshore its not working......
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
Originally posted by Deepa Raj:
Hi ,

Actually we are using , Callable Statement.......One more thing the same code is working in onsite.but in offshore its not working......


Then this is a deployment issue. You don't have the same version of code or stored proc on the offshore version as you do onsite.
Deepa Raj
Greenhorn

Joined: Nov 17, 2005
Posts: 3
Originally posted by Maximilian Stocker:


Then this is a deployment issue. You don't have the same version of code or stored proc on the offshore version as you do onsite.



Hi ,

Actually we r hitting onsite Stored procedure only....code and SP are same ....but something JDBC driver problem....we r using DB27.1 but Onsite is using DB27.2 ... is it any problem?

Thanks.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18708
    
    8

You were looking for something in your configuration that was different between the two sites. Now you have found something.

If it were me I would change the non-working site to be configured the same as the working site. Even though I have no idea whether that difference is the problem or not.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: CLI0627E The result set is not scrollable.