Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Json v1.0
  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)

HXTT DBF
Empty resultSet with large table
Yvan
2014-03-19 02:50:40
Hi. I have a problem.
I select all from 3 tables with query like this:
SELECT * FROM xxx.dbf AS p, yyy.dbf AS s, zzz.dbf AS r WHERE p.UL = s.CODE AND p.REGS = r.RNCODE;
Then I save all results to Collection of Collections.
With this it's all ok.
But when I iterate on saved results I need to send some queries in every row using by this method:
private List> getSelect(String sqlQuery, Statement statement) {
List> response = new LinkedList>();
ResultSet resultSet = null;
ResultSetMetaData resultSetMetaData = null;
int columnCounter = 0;
try {
resultSet = statement.executeQuery(sqlQuery);
resultSetMetaData = resultSet.getMetaData();
columnCounter = resultSetMetaData.getColumnCount();
while (resultSet.next()) {
List row = new ArrayList();
for (int i = 1; i <= columnCounter; i++) {
row.add(resultSet.getObject(i));
}
response.add(row);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (!resultSet.isClosed()) {
resultSet.close();
resultSet = null;
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
return response;
}
As you can see I use existing statement. In this sqlQuery I use some fields which were recieved from previous "SELECT * ..." like this (it need that find unique row):
SELECT SUBSTRING(SN_PASP, 1, 5) FROM xxx.dbf AS p, yyy.dbf AS s, zzz.dbf AS r WHERE SURNAME = 'DOE' AND NAME = 'JOHN' AND DATE = '1988-03-03' AND p.UL = s.CODE AND p.REGS = r.RNCODE;
Absolutely true that this row is exists and up to ~10000 rows in table I recieved right response but if I use more larger table resultSet is empty almost all the time.
Empty resultSet with large table
Yvan
2014-03-19 02:56:05
Oh, parser eats some angle brackets with words.
The start part of method is:
private List *angle brackets* List *angle brackets* Object *angle brackets* *angle brackets* getSelect(String sqlQuery, Statement statement) {
List *angle brackets* List *angle brackets* Object *angle brackets* *angle brackets* response = new LinkedList *angle brackets* List *angle brackets*Object *angle brackets* *angle brackets* ();
...
while (resultSet.next()) {
List *angle brackets* Object *angle brackets* row = new ArrayList *angle brackets* Object *angle brackets* ();
Re:Re:Empty resultSet with large table
HXTT Support
2014-03-19 04:51:03
>WHERE SURNAME = 'DOE' AND NAME = 'JOHN' AND DATE = '1988-03-03'
Try to use p, s, r alias for surname, name, and date column. BTW, you should test it with the latest package.
Re:Re:Re:Empty resultSet with large table
Yvan
2014-03-19 06:09:11
Nothing changed. I use v4.0.0 'cause customer bought this version a few time ago.
Re:Re:Re:Re:Empty resultSet with large table
HXTT Support
2014-03-19 06:15:36
You can try to download the evaluation package to see whether that issue disappear. If it disappear, then you should consider renew your license to get the latest version.
Re:Re:Re:Re:Re:Empty resultSet with large table
Yvan
2014-03-19 07:11:55
Yep, it works now but I don't know why for sure. Because evaluation driver returns only 1000 rows. With old driver program works properly with only 1000 rows too.
Re:Re:Re:Re:Re:Re:Empty resultSet with large table
HXTT Support
2014-03-19 16:56:14
Evaluation version returns only 1000 rows. If it works, then you should consider renewing to the latest version, since v4.0 is a very old package in 2007.
Re:Re:Re:Re:Re:Re:Re:Empty resultSet with large table
Yvan
2014-03-20 01:02:17
Ok. But I repeat. With bought driver v4.0 with table consists 1000 rows or less program works properly too. I couldn't verify new driver with large table (like 20000 rows) 'cause it returns only 1000 rows. Is it clear? Customer don't give me money to buy a new version until he is sure that one will be works right.
Re:Re:Re:Re:Re:Re:Re:Re:Empty resultSet with large table
HXTT Support
2014-03-20 04:27:36
>Empty resultSet with large table
According to your description, for the older package, it can't fetch any row. For the evaluation package, it can fetch 1000 rows.

BTW, what's your customer email for bought? You can email the customer information to support @ hxtt.com so that we can check whether it can get a cheaper upgrade fee.
Re:Re:Re:Re:Re:Re:Re:Re:Empty resultSet with large table
Yvan
2014-03-20 06:22:14
I quote myself: "up to ~10000 rows in table I received right response but if I use more larger table resultSet is empty almost all the time."
So to be absolutely sure that it works I need, for example, evaluation driver with increased limitation up to ~15 thousands or something like this. 50 queries are in limitation still ok for me. Can you do this?
P.S. Ok, I am going to tell my customer about discount but I don't sure that he'll agree to buy it as long as it'll not works.
Re:Re:Re:Re:Re:Re:Re:Re:Empty resultSet with large table
HXTT Support
2014-03-20 07:36:42
>So to be absolutely sure that it works I need, for example, evaluation driver with increased limitation up to ~15 thousands or something like this. 50 queries are in limitation still ok for me. Can you do this?
Evaluation can query on the large table, and will fetch the first 1000 rows met your where condition.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap