damianharvey
New Member
Hi,
I am running some java code to extract data from a Progress 9.1E database. When the result set size is larger than 104,000 rows then the driver starts returning complete gibberish.
I start getting errors like : [JDBC Progress Driver]:Invalid character value. Error in column 9
However there is nothing wrong with the data.
Examples:
Querying that fails which a count(*) shows will return 104,767 rows :
select * from PUB.po_details where hdr_id > 30000 and hdr_id < 44750
Query that succeeds which a count(*) shows will return 103,619 rows :
select * from PUB.po_details where hdr_id > 30000 and hdr_id < 44500
Query that succeeds which a count(*) shows will return 75,592 rows :
select * from PUB.po_details where hdr_id > 40000 and hdr_id < 50000
Is this a known problem?
Many Thanks,
Damian.
I am running some java code to extract data from a Progress 9.1E database. When the result set size is larger than 104,000 rows then the driver starts returning complete gibberish.
I start getting errors like : [JDBC Progress Driver]:Invalid character value. Error in column 9
However there is nothing wrong with the data.
Examples:
Querying that fails which a count(*) shows will return 104,767 rows :
select * from PUB.po_details where hdr_id > 30000 and hdr_id < 44750
Query that succeeds which a count(*) shows will return 103,619 rows :
select * from PUB.po_details where hdr_id > 30000 and hdr_id < 44500
Query that succeeds which a count(*) shows will return 75,592 rows :
select * from PUB.po_details where hdr_id > 40000 and hdr_id < 50000
Is this a known problem?
Many Thanks,
Damian.