HXTT DBF and IDX files |
Marcin Bogdanski |
2007-08-24 08:09:31 |
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 |
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 |
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 |
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 |
|
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 |
|
We haven't received it.
|
Re:Re:Re:Re:Re:Re:HXTT DBF and IDX files |
MB |
2007-08-28 04:20:36 |
|
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 |
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 |
|
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 |
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 |
|
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 |
|
Thanks.
|
Main
webmaster@hxtt.com