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 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
HXTT NegativeArraySizeException on Windows 2008 R2, but not on Windows 10
MD
2018-10-15 14:30:11.0
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.0
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.0

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

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