Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.253
  HXTT Cobol 5.0.252
  HXTT DBF 7.1.253
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel 6.1.256
  HXTT Json 1.0.224
  HXTT Paradox 7.1.252
  HXTT PDF 2.0.252
  HXTT Text(CSV) 7.1.252
  HXTT Word 1.1.252
  HXTT XML 4.0.253
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
java.sql.SQLException: Can't parse index expression txntype=>"300"
Kit
2011-09-07 07:53:42
I got this error message: java.sql.SQLException: Can't parse index expression txntype=>"300" when I was trying to run a simple select on a table. I ran the same type of simple select query on a different table and there was no problem. It returned the data properly. I am using your demo HXTT DBF Driver: DBF_JDBC30.jar. Both of the tables have .dbf, .fpt, & .cdx files. The key thing to know is that the field called txntype should not be the index field. I don't know what the index field should be (possibly ORD or FIND or something else).
Re:java.sql.SQLException: Can't parse index expression txntype=>
HXTT Support
2011-09-08 17:34:45
>The key thing to know is that the field called txntype should not be the index
> field. I don't know what the index field should be (possibly ORD or FIND or
> something else).
Please email us the dbf and cdx sample
Re:Re:java.sql.SQLException: Can't parse index expression txntype=>
Kit Kennedy
2011-09-29 06:16:12
I was able to solve this problem by using the properties to tell the dbf driver to not load the indices:

Properties properties = new Properties();
properties.setProperty("loadIndices", "false");

However, I may still want to fix this problem. If I still need help with this, I will write back at that time. Thank you anyway.
Re:Re:Re:java.sql.SQLException: Can't parse index expression txntype=>
HXTT Support
2011-09-29 06:24:14
Yeah. If we received your dbf and index file sample, we will support it.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap