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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
HXTT Support | 2008-07-03 05:06:25.0 | |
| You can zip and email us your issuelog.dbf and cdx file. | ||
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. | ||
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. | ||
HXTT Support | 2008-07-21 05:21:40.0 | |
| Please zip it, then upload it. anonymous allows 600mb at most. | ||
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 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. | ||
HXTT Support | 2008-07-21 07:52:09.0 | |
| You can try webmaster.hxtt@gmail.com . | ||
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. | ||
HXTT Support | 2008-07-22 05:46:28.0 | |
| Recurred and supported. Please download the latest package. | ||
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. | ||
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. | ||
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. | ||
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. | ||