473,385 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

scrollable resultset

When we are trying to execute scrollable resultset APIs (rs.last etc.,) we get the following error. (Database version: UDB 7. on Windows. Driver: Type 4.)
This method should only be called on ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE).

But the same(scrollable resultset) works on DB2 Version 7.1 on DB2 z/OS version.

Can anyone help in solving for the issue in scrollable resultset in UDB 7. on Windows. Driver: Type 4.

Thanks in Advance,
Feb 20 '07 #1
3 6756
r035198x
13,262 8TB
When we are trying to execute scrollable resultset APIs (rs.last etc.,) we get the following error. (Database version: UDB 7. on Windows. Driver: Type 4.)
This method should only be called on ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE).

But the same(scrollable resultset) works on DB2 Version 7.1 on DB2 z/OS version.

Can anyone help in solving for the issue in scrollable resultset in UDB 7. on Windows. Driver: Type 4.

Thanks in Advance,
Apparently there is a restriction on the scrollable resultset. See here.
Feb 20 '07 #2
Apparently there is a restriction on the scrollable resultset. See here.

Thanks for the reply.
I seen the mentioned URL and confirmed that the datatype we use, does not match with any of the mentioned restricted data type. One thing i want to confirm is, can the scrollable resultset be used on windows version UDB 7 with type 4 driver
Feb 21 '07 #3
r035198x
13,262 8TB
Thanks for the reply.
I seen the mentioned URL and confirmed that the datatype we use, does not match with any of the mentioned restricted data type. One thing i want to confirm is, can the scrollable resultset be used on windows version UDB 7 with type 4 driver
This does not seem to be containing the details for the type 4 too. I'll keep checking. Let me know when you get any other info on the problem.
Feb 21 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Matt Kruse | last post by:
This is a typical layout, but I have specific requirements. I'm trying to figure out a) if it's possible to meet the requirements and b) if so, how. +---------------+ | header |...
25
by: Michael Schuerig | last post by:
I'm trying to do something seemingly very simple, but it's brought me close to crushing my head on the keyboard. All I want is a table where the head row is fixed and the body columns below are...
1
by: TP | last post by:
I am using Db2Connect 7.1 on winxp to connect to db2 on z/os version 7.1 in a java application. How can i find out if my version of jdbc driver supports scrollable resultsets? Also, how can I...
0
by: 4.spam | last post by:
Hello. W2K, v8.2.1, jcc driver I am trying to get scrollable result set from SQL stored procedure in my java application using jcc driver. --- CallableStatement cs = conn.prepareCall (...
5
by: Brian Henry | last post by:
Hello, I want to make a control that has a scrollable Gantt type display (not really one but will look similar to one) this is going to be custom drawn (i already have the drawing procedure...
2
by: Ben H | last post by:
Hello all I'm using a listview in my app but I want to scroll the listview programatically as I hate the look of the standard scrollbar. So, the listview is scrolled programatically using...
2
by: roberto | last post by:
Hello, I'm trying to retrieve some records in my web application using a jdbc Statement like this: statement =...
0
by: charbak | last post by:
Hi, We have a problem in our application.Problem is like this.. Statement dynamicstmt = null; dynamicstmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ...
1
by: since | last post by:
I figured I would post my solution to the following. Resizable column tables. Search and replace values in a table. (IE only) Scrollable tables. Sortable tables. It is based on a lot...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.