Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  Buy Now
  HXTT Excel v6.1
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

driver limits amount of return
Arturas Gruodis
2020-10-23 23:15:50.0

we are trying to excute the query with hibernate and yuor driver from dbaseIII.

It seems it return not all records. We have more than 1000 records, but it returns only 265-302 records, but no more. Maybe there is some kind of limitation?

studyentit0_.StudyInsta as col_0_0_,
studyentit0_.StudyDate as col_1_0_,
studyentit0_.StudyTime as col_2_0_,
studyentit0_.StudyDescr as col_3_0_,
patientent1_.PatientNam as col_4_0_,
patientent1_.PatientID as col_5_0_,
studyentit0_.AccessionN as col_6_0_,
seriesenti2_.Modality as col_7_0_
DICOMStudies studyentit0_
inner join
DICOMPatients patientent1_
on (
inner join
DICOMSeries seriesenti2_
on (
order by
studyentit0_.StudyDate DESC,
studyentit0_.StudyTime DESC limit 1001
More information
Arturas Gruodis
2020-10-23 23:19:17.0

we noticed that if we are setting maxResult to 1001, the queries ruturn 250 - 300 rows.
try(ScrollableResults queryResults = requestQuery
.scroll(ScrollMode.FORWARD_ONLY)) { ..}

If we set it to 4000 it return more than 1000.

try(ScrollableResults queryResults = requestQuery
.scroll(ScrollMode.FORWARD_ONLY)) { ..}
Re:Re:driver limits amount of return
HXTT Support
2020-10-24 00:51:14.0
Differences between the trial version and the licensed version: .

The trial version of the driver is available to use free for a 30-day trial period.
The trial version of the driver allows executing not more than 50 queries once.
SELECT queries return the first 1000 rows in the result set.
Re:Re:Re:driver limits amount of return
Arturas Gruodis
2020-10-26 00:09:22.0

We have commercial licence and we want to limit result to 1000 rows. The problem is that when we limit it to 1000 rows, it return only 250-300 rows.

We use inner join in our queries. See the sample above.
Re:Re:Re:Re:driver limits amount of return
HXTT Support
2020-10-26 16:55:30.0
Failed to recur your issue with v7.1.017 ion October 23, 2020

For test data with the same SQL,
1. Without limit 1001, it return 2042 rows.

2.With limit 1001, it return 1001 rows.
stmt.setMaxRows(4000); , it return 1001 rows.
stmt.setMaxRows(1001); , it return 1001 rows.
stmt.setMaxRows(400); , it return 400 rows.

Your Name
Email ( other cannot see this information)
                                 notify me anyone answer
All spammers will be banned automatically or manually. If you failed to post your question, your ip should be in our blacklist. In that way, you have to contact us through email.
Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap