HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10 |
MD |
2018-10-15 14:30:11 |
Hello,
I have written a program which reads a single row from a DBF file. When I run the program on Windows 10 (my development environment), it works fine. But when I run it on the Windows Server 2008 R2 server (production environment), I get the below exception... The SQL is valid (I'm able to run the same SQL using another tool), and the url looks correct.
I am using the latest version of Java, and the latest version of the HXTT DBF package (DBF_JDBC42).
Do you know of a way to debug this issue?
The line of code that fails is...
ResultSet rs = stmt.executeQuery(sql);
(but again) the same exact code works on my dev environment, with the identical DBF file. I have also tried other DBF files, and they all fail in Windows Server 2008 R2 (which is essentially Windows 7 kernel). Any idea what's going wrong?
2018-10-15 15:31:54 INFO com.agentsnet.EDI.EDIRecords getPolicyExpDate() sql=select exp from POLICY WHERE pol_idx='MEILDE1-1001'
2018-10-15 15:31:54 INFO com.agentsnet.EDI.EDIRecords getPolicyExpDate() url=jdbc:DBF:///E:\Applied\TAM
2018-10-15 15:31:54 SEVERE com.agentsnet.EDI.ImportEDI main() java.sql.SQLException: java.lang.NegativeArraySizeException
at com.hxtt.sql.dbf.a.i(Unknown Source)
at com.hxtt.sql.dbf.a.(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.j.a(Unknown Source)
at com.hxtt.sql.dbf.e.a(Unknown Source)
at com.hxtt.sql.dbf.e.(Unknown Source)
at com.hxtt.sql.dbf.y.a(Unknown Source)
at com.hxtt.sql.b1.a(Unknown Source)
at com.hxtt.sql.d5.a(Unknown Source)
at com.hxtt.sql.d5.a(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.b1.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.executeQuery(Unknown Source)
at com.agentsnet.EDI.EDIRecords.getPolicyExpDate(EDIRecords.java:368)
at com.agentsnet.EDI.EDIRecords.convert2ENsToREN(EDIRecords.java:287)
at com.agentsnet.EDI.ImportEDI.main(ImportEDI.java:47)
at com.hxtt.b.ar.a(Unknown Source)
at com.hxtt.b.ar.a(Unknown Source)
at com.hxtt.sql.b1.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.executeQuery(Unknown Source)
at com.agentsnet.EDI.EDIRecords.getPolicyExpDate(EDIRecords.java:368)
at com.agentsnet.EDI.EDIRecords.convert2ENsToREN(EDIRecords.java:287)
at com.agentsnet.EDI.ImportEDI.main(ImportEDI.java:47)
|
Re:HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10 |
HXTT Support |
2018-10-15 18:10:16 |
It has no relation for Windows 2008 or 10.
Are you using NDX index file? It seems that some invalid index information in your NDX files on Windows 2008. You can try to "reindex all on yourTable" once to see whether your issue disappear. You can also choose to email us your POLICY.dbf and POLICY.ndx on Windows 2008 so that we can recur and debug it for you.
|
Re:Re:HXTT NegativeArraySizeException when using NDX files |
D |
2018-10-16 04:51:27 |
On my development environment I do not have the NDX files, and you are right, the query works fine when the NDX files are removed. I have tried re-indexing and packing them, but that does not help.
I have created a test case on a small table (all tables have this same problem) with a simple "select count(1) from CURRENCY". It might be something specific in the way the vendor I'm using constructs the NDX files.
I will email the files to you support@...
|
Re:Re:Re:HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10 |
HXTT Support |
2018-10-16 06:53:00 |
It's resulted by an invalid information in your NDX file header.
Supported. Please redownload the latest package.
|
Re:Re:Re:Re:HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10 |
D |
2018-10-16 09:46:14 |
Thank you. That fixed that one error, but now it has hit a new error...
2018-10-16 12:44:19 INFO com.agentsnet.EDI.EDIRecords updatePolicyCommisions() sql=update POLICY set com_p=20.00 WHERE pol_idx='SINGGA1-1001';
2018-10-16 12:44:19 SEVERE com.agentsnet.EDI.ImportEDI main() java.sql.SQLException: 508
at com.hxtt.global.aq.a(Unknown Source)
at com.hxtt.global.aq.a(Unknown Source)
at com.hxtt.sql.b1.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.a(Unknown Source)
at com.hxtt.sql.aq.if(Unknown Source)
at com.hxtt.sql.aq.executeUpdate(Unknown Source)
at com.agentsnet.EDI.EDIRecords.updatePolicyCommisions(EDIRecords.java:256)
at com.agentsnet.EDI.EDIRecords.updateMissingCommissions(EDIRecords.java:238)
at com.agentsnet.EDI.ImportEDI.main(ImportEDI.java:59)
I will email the sample files... I also receive a error 512 when trying a different file... Is there a way to have the driver ignore the NDX files completely?
|
Re:Re:Re:Re:Re:HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10 |
HXTT Support |
2018-10-16 23:11:40 |
What's the program to create/reindex your NDX file? According to my analysis on your sample, it should be a variable format of NDX.
Supported. Please redownload it.
BTW, you can use loadIndices=false connection property to avoid loading NDX files. But your format should have been supported fully.
|
Re:Re:Re:Re:Re:Re:HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10 |
D |
2018-10-17 04:24:54 |
Thank you, that fixed it.
What is the value of using the indices? I notice that if I disable them as you mentioned, that the program runs significantly faster.
Will I need to re-index my DBF files after running my program if I make changes to the data with loadIndices=false ?
|
Re:Re:Re:Re:Re:Re:Re:HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10 |
HXTT Support |
2018-10-17 05:07:54 |
>>loadIndices=false
>What is the value of using the indices?
Default loadIndices=true .
>Will I need to re-index my DBF files after running my program if I make changes to the data with loadIndices=false ?
Yeah. So that you should use loadIndices=true for data modification.
|
Main
webmaster@hxtt.com