Hello,
It seems that "IF NOT EXISTS" does not work properly when creating a table inside a Catalog (a subdirectory). For example:
CREATE TABLE IF NOT EXISTS meta.usrd (rowid int primary key, parentid int, userid longvarchar(500), username longvarchar(500), password longvarchar(500))
java.sql.SQLException: Failed to create index Z:\ramirez\idc-catalyst\workspace\CM Desktop\data\meta\usrd.IDX because it exists.
These statements worked properly until I placed the tables in a Catalog.
Thanks,
|
Supported. Please download the latest package. Thanks.
|
The above problem is resolved, however, if I create a sequence in a catalog ("CREATE SEQUENCE IF NOT EXISTS meta.seqd CACHE 5"), how do I obtain values from it. I tried:
"? nextval('meta.seqd');"
but it throws:
java.sql.SQLException: Failed to get current sequence c:\data\meta.seqd.SEQ because it doesn't exist.
Thanks,
|
|
Supported too. Please download the latest package. Thanks.
|
There seems to be a problem with the lastest jar file:
java.lang.ClassNotFoundException: com.hxtt.sql.dbf.DBFDriver
Also, in Eclipse it no longer allows the expansion of the Jar to see the content... This may be related.
Thanks,
|
|
Try to redownload the package. It seems that you're using a corrupted jar file.
|
No same problem. I am downloading "DBF JDBC 3.0 Package" from the download page. It seems that this jar is obfuscated badly. The jar is not corrupted because I can list it using jar -tf. The output contains:
META-INF/MANIFEST.MF
com/hxtt/swing/a/b.class
com/hxtt/swing/a/a.class
com/hxtt/swing/util/h.class
com/hxtt/swing/util/f.class
com/hxtt/swing/util/TableSorter$1.class
com/hxtt/swing/util/TableSorter$2.class
com/hxtt/swing/util/TableSorter$b.class
com/hxtt/swing/util/TableSorter$e.class
...
com/hxtt/sql/dbf/DBFDriver.class
com/hxtt/sql/dbf/DBFIndex.class
com/hxtt/sql/dbf/i.class
com/hxtt/sql/dbf/o.class
com/hxtt/sql/dbf/n.class
...
|
|
Checked. Please try to redownload the latest package. If your issue exists still, please let us know.
|
Main
webmaster@hxtt.com