Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
Failed to do reindex
Rajiv
2008-07-01 06:23:27.0
Hi,

I am using hxtt dbf v3.0 (DBF_JDBC30)
I am trying to do reindex on a table and I get an exception. Here are the details:

Table: issuelog
SQL: statement.executeUpdate("reindex all on issuelog");
Exception:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 3
at com.hxtt.sql.dbf.m.a(Unknown Source)
at com.hxtt.sql.dbf.m.do(Unknown Source)
at com.hxtt.sql.dbf.b.a(Unknown Source)
at com.hxtt.sql.dbf.i.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at org.bjc.ric.cleanup.Try.main(Try.java:12)

at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at org.bjc.ric.cleanup.Try.main(Try.java:12)

Error code: 393216 <--- getErrorCode();
State: 60000 <--- getSQLState();

Thanks.
Re:Failed to do reindex
HXTT Support
2008-07-01 06:34:11.0
>I am using hxtt dbf v3.0 (DBF_JDBC30)
Please upgrade to v3.1, and see whether your issue disappear.
Re:Re:Failed to do reindex
Rajiv
2008-07-02 12:32:21.0
I checked download site. But it only offers DBF_JDBC30.jar there is no 3.1 version. Is there a DBF_JDBC31.jar I can download? I (our organization) recently bought the software. Please let know where can I find the latest version.

Thanks.
Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-02 17:30:04.0
JDBC30 means the JDBC 3.0 specification. That DBF_JDBC30.jar file is v3.1 version.
Re:Re:Re:Re:Failed to do reindex
Rajiv
2008-07-03 04:19:56.0
Ok. But I am already using that and I am getting the above stated error. I don't know what that error means, and I am getting while reindexing. Please let me know what do I have to do inorder for the reindexing to work properly.

Thanks.
Re:Re:Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-03 05:06:25.0
You can zip and email us your issuelog.dbf and cdx file.
Re:Re:Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-03 05:11:33.0
If your file is too large, you can zip and upload your database sample into:
ftp site: ftp.hxtt.com
ftp user: anonymous@hxtt.com
ftp password: (empty)
login mode: normal (not anonymous)
ftp port:21
upload directory: incoming
transer mode: binary (not ASCII)
After upload, you can't see that upload file, but it has been upload.

Then we will check and fix that for you.
Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
Rajiv
2008-07-21 04:47:01.0
The .dbf and .cdx files are together around 1gb. Is it okay to upload them? Please let know so that I can upload it and you can fix the problem.
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-21 05:21:40.0
Please zip it, then upload it. anonymous allows 600mb at most.
Re:Failed to do reindex
Rajiv
2008-07-21 07:13:31.0
Unable to ftp!

Failed to upload file from windows command prompt. using the following commands
ftp ftp.hxtt.com
anonymous@hxtt.com
"empty for password"
cd incoming
binary
put issuelog.zip

this gets disconnected after while.

I tried using winSCP, in FTP mode. I am able to upload 2% but after that I get the following error:

Timeout detected.
Copying files to remote side failed.
Connecting to port 59017
Copying files to remote side failed.

I would like to know how to make it work and what commands do I have to use exactly.

If I want to e-mail the zip file, what is the e-mail id?

Thanks,
Rajiv.
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-21 07:52:09.0
You can try webmaster.hxtt@gmail.com .
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
Rajiv
2008-07-21 08:48:13.0
I e-mailed zipped and splitted version (9-parts) of the two files (.dbf, .cdx)

Please acknowledge that you received the files and that you are successful to restore them back to figure out why reindex fails.

Thanks,
Rajiv.
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-22 05:46:28.0
Recurred and supported. Please download the latest package.
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
Rajiv
2008-07-22 06:30:41.0
We already have the latest package(that has DBF_JDBC30.jar). We bought this software recently. If this is not the latest jar, what is the latest jar? and where can I find it?

Please let know.

Thanks.
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-22 06:40:50.0
Please login and download it. The latest pacakge is v4.0.049 on July 22, 2008.
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
Rajiv
2008-07-25 09:28:16.0
Thanks. The reindexing now works fine.

But I have another problem. I am trying to "pack" a table.

I use a particular tool that does the compress and reindex. There are 2 tables tableA, tableB.

The compress tool shows that there are "X" number of rows to be deleted from tableA, and "Y" number of rows to be deleted from tableB

Now, using HXTT DBF, when I issue the
"pack table tableA" -- it deletes "X" number of rows (which matches with the result form the tool)
"pack table tableB" -- it deletes "Z" number of rows ( which does not match with the result from the tool).
and Z < Y.

I would like to know why is HXTT DBF failing while compressing tableB ?

here is the java code i use exactly:
Class.forName("com.hxtt.sql.dbf.DBFDriver");
Connection conn = DriverManager.getConnection("jdbc:dbf:/c:/DSN3/BSWP/Data","","");
Statement st = conn.createStatement();
int recordCount = st.executeUpdate("pack table tableA");
System.out.println("compressed tableA. The record count is: "+recordCount);
recordCount = st.executeUpdate("pack table tableB");
System.out.println("compressed tableB. The record count is: "+recordCount);

Thanks.
Re:Re:Re:Re:Re:Re:Re:Re:Failed to do reindex
HXTT Support
2008-07-25 09:35:43.0
>The compress tool shows that there are "X" number of rows to be deleted from tableA, and "Y" number of rows to be deleted from tableB
>"pack table tableB" -- it deletes "Z" number of rows ( which does not match with the result from the tool).
and Z < Y.
You can use your compress tool to check the new Y number, and use HXTT DBF to repack that table. I guess that your tool will report y-z deletedd rows, and HXTT DBF reports 0. HXTT DBF should be worked normally, but we will try to dig out why your compress tool reports wrongly according to your sample.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap