Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  Buy Now
  HXTT Excel v6.1
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
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)

Long column name : invalid index
Etienne Boutry
2012-09-24 08:55:48.0
Good morning.

I am using DBF_JDBC40 to query a Visual Fox Pro database. However, I cannot get the driver to recognize column names over 10 characters. When I try to read such a field, I get the message "SQLException: Index D:\folder\Base Système\controle.cdx should have an invalid index expression controle_id, since failed to find column controle_id !"

I made sure that the magnifier - système.dct, magnifier - système.dcx and magnifier - système.dbc files are there along with controle.dbf and controle.cdx.

I tried tweaking the connection parameters but that did not work.

Do you have any idea what the problem might be?

Thanks in advance.

Re:Long column name : invalid index
HXTT Support
2012-10-19 17:02:34.0
Sorry for missed that thread. Do you make sure that système.dbc is at the same directory of controle.dbf? If it's at the parent directory, you can try jdbc:dbf:D:/folder/système.dbc .
Re:Re:Long column name : invalid index
Etienne Boutry
2012-10-22 01:58:41.0
They are indeed in the same directory. I just had a thought : can the driver handle "è" in files names?
Re:Re:Re:Long column name : invalid index
HXTT Support
2012-10-22 02:21:40.0
If possible, you can backup your data, and email us sucha a sample. Maybe your thought is correct, because that dbc path is stored in controle.dbf .
Re:Re:Re:Re:Long column name : invalid index
HXTT Support
2012-10-22 02:40:06.0
You can try jdbc:dbf:D:/folder/système.dbc?charSet=ISO8859_1 to see whether it can work now. If it can work, then we will provide a solution soon.
Re:Re:Re:Re:Re:Long column name : invalid index
HXTT Support
2012-10-22 06:34:13.0
A version will release after 2 hours, and it will parse first the dbc database path with the dbc's CodePage, so that you needn't charSet connection property to solve that issue.

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap