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
HXTT DBF and IDX files
Marcin Bogdanski
2007-08-24 08:09:31.0
We are interested in using HXTT DBF library for accesing database of existing and live FlagShip application.
DBFs and DBTs are read and wrote excellent, but there is a big problem with IDXs created by FlagShip application (some old, maybe 4.* or older version).
When I try to connect do DBFs with CGPs containing the list of indexes, I receive en exception.
Are the IDXs supported?
Re:HXTT DBF and IDX files
HXTT Support
2007-08-24 08:31:36.0
It support IDX. What's your exception?
You can use:

catch (SQLException sqle) {
do {
System.out.println(sqle.getMessage());
System.out.println("Error Code:" + sqle.getErrorCode());
System.out.println("SQL State:" + sqle.getSQLState());
sqle.printStackTrace();
}
while ( (sqle = sqle.getNextException()) != null);
}

to know more message.
Re:Re:HXTT DBF and IDX files
Marcin Bogda��ski
2007-08-26 02:28:03.0
Can't parse index expression ÿ
java.sql.SQLException: Can't parse index expression ÿ
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.dbf.v.a(Unknown Source)
at com.hxtt.sql.dbf.n.char(Unknown Source)
at com.hxtt.sql.dbf.n.(Unknown Source)
at com.hxtt.sql.dbf.b.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.i.a(Unknown Source)
at com.hxtt.sql.dbf.d.a(Unknown Source)
at com.hxtt.sql.dbf.d.(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.dc.a(Unknown Source)
at com.hxtt.sql.dc.a(Unknown Source)
at com.hxtt.sql.bm.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.executeQuery(Unknown Source)
at pl.waw.mb.Marza.Test.testNaz(Test.java:43)
--------------------------------------------------
My program looks like this:
String url = "jdbc:dbf:////dane/k2000/bazy";
String nrdok = "590190";
System.out.print("Szukanie paska '" + nrdok + "'\n");
Class.forName("com.hxtt.sql.dbf.DBFDriver");
Properties p = new Properties();
p.setProperty("charSet", "Mazovia");
Connection c = DriverManager.getConnection(url, p);
Statement s = c.createStatement();
ResultSet r = s
.executeQuery("select nazwa,pasek from nazw_tow where pasek like '"
+ nrdok + "%'");
while (r.next()) {
String w = r.getString(1);
String a = r.getString(2);
System.out.print("W=" + w + " P=" + a + "\n");
}
r.close();
s.close();
c.close();
--------------------------
the nazw_tow.CGP file looks:
nazw_to1.idx
--------------------------
If the .CGP file is empty, or contains invalid (non-existent) filenames, the program works!
Re:Re:Re:HXTT DBF and IDX files
HXTT Support
2007-08-26 04:51:06.0
It means that if failed to parse your index expression in nazw_to1.idx . Maybe yout idx format isn't standard IDX format. You can zip and email webmaster@hxtt.com a nazw_to.dbf and nazw_to.idx sample to see whether we can provide support.

>We are interested in using HXTT DBF library for accesing database of existing and
> live FlagShip application.
BTW, you need to set lockType connection property if ther's a FlashShip application are using the same tables.
Re:Re:Re:Re:HXTT DBF and IDX files
MB
2007-08-28 02:57:51.0
I sent it few days ago - did you receive it?
Re:Re:Re:Re:Re:HXTT DBF and IDX files
HXTT Support
2007-08-28 03:27:03.0
We haven't received it.
Re:Re:Re:Re:Re:Re:HXTT DBF and IDX files
MB
2007-08-28 04:20:36.0
I just sent it again to webmaster@hxtt.com.
Re:Re:Re:Re:Re:Re:Re:HXTT DBF and IDX files
MB
2007-08-28 08:17:46.0
Now, did you receive the file?
If not, I can publish it on web page to download for you.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT DBF and IDX files
HXTT Support
2007-08-28 08:30:08.0
Haven't recevied it still.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT DBF and IDX files
MB
2007-08-28 09:21:37.0
So i put it to the web:
http://mb.waw.pl/tmp/nazw_tow.zip
Re:Re:Re:Re:Re:Re:Re:Re:HXTT DBF and IDX files
HXTT Support
2007-08-28 21:45:01.0
Thanks. Checked. FlagShip has own index structure. Although it's using the IDX suffix, but it's not a standard IDX format. FlagShip's IDX foramt is still Btree binary structure, but it's devided into two versions(4.4x and 5.x). Now HXTT hasn't plan to support FlagShip's own IDX format.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT DBF and IDX files
MB
2007-09-01 07:59:40.0
Thanks.

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