Hi,
We have a problem in our application.Pro blem is like this..
Statement dynamicstmt = null;
dynamicstmt = con.createState ment(ResultSet. TYPE_SCROLL_INS ENSITIVE, ResultSet.CONCU R_READ_ONLY);
dynamicstmt.set FetchSize(rowsP erPage);
dynamicstmt.set FetchDirection( ResultSet.FETCH _FORWARD);
With this statement if I execute the query the result would be coming with 0 records..
If I use the following type of statement :
dynamicstmt = con.createState ment();
It gives all records for the query.
we are using JRE version 1.4.2 and DB2 version 7.1,
This happend for a particular geo, but run in other geos.Can you pls suggest me what the root causr that querry unable to fetch resultset,Is their any problem with DDL version?Pls response urgently.
We have a problem in our application.Pro blem is like this..
Statement dynamicstmt = null;
dynamicstmt = con.createState ment(ResultSet. TYPE_SCROLL_INS ENSITIVE, ResultSet.CONCU R_READ_ONLY);
dynamicstmt.set FetchSize(rowsP erPage);
dynamicstmt.set FetchDirection( ResultSet.FETCH _FORWARD);
With this statement if I execute the query the result would be coming with 0 records..
If I use the following type of statement :
dynamicstmt = con.createState ment();
It gives all records for the query.
we are using JRE version 1.4.2 and DB2 version 7.1,
This happend for a particular geo, but run in other geos.Can you pls suggest me what the root causr that querry unable to fetch resultset,Is their any problem with DDL version?Pls response urgently.