Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: Blackfish SQL/SQL/JDBC Driver    [ Add a report in this area ]  
Report #:  55133   Status: Open
ResultSet::relative does not move cursor
Project:  JDataStore Build #:  8.0.2804.9245
Version:    6 Submitted By:   Jonathan Benedicto
Report Type:  Basic functionality failure Date Reported:  11/21/2007 2:27:11 PM
Severity:    Serious / Highly visible problem Last Updated: 3/20/2012 2:24:39 AM
Platform:    All platforms Internal Tracking #:   257857
Resolution: None (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
Calling ResultSet::relative on a scroll insensitive result set, before the first next() call, does not move the dataset cursor.
Steps to Reproduce:
1. Download the attached zip file.

2. Extract into a JBuilder2007 workspace.

3. Execute the SQL file (testCase.sql) on a BlackfishSQL database.

4. Open the project in JBuilder 2007

5. Open the TestLineSplit.java file, and alter the connection string on line 27 to connect to the BlackfishSQL server on your machine.

6. Run the project.

Expected output:
scrolling result sets are supported
scrolling forward 2 rows
Result[0] = user3
Result[1] = user4

Actual output:
scrolling result sets are supported
scrolling forward 2 rows
Result[0] = user1
Result[1] = user2

Line 14 in the .java file sets the desired starting row position.
Workarounds
None
Attachment
TestLineSplit.zip
Comments

None

Server Response from: ETNACODE01