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
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.