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
DBF_JDBC20.jar
Zulkefli Aris
2005-10-12 00:00:00.0
Hi,
Is there a guide on how to setup the above driver in coldfusion MX 7 running on linux? Actually I have managed to load and query using the drive but there is this one query giving me some problem. Below is the sample query in cfml.


select * from "#ZipDest#/".#fnames#


It gives me parsing error when running the page
Re:DBF_JDBC20.jar
HXTT Support
2005-10-12 00:00:00.0
You can find "3. How to set up HXTT DBF with Coldfusion MX 6.1 Application Server?" at http://www.hxtt.net/dbf/faq.html#interoperability . For unix, you should use "jdbc:dbf:///yourDatabaseDir" as embedded jdbc url.

I guess that your issue should be resulted by your sql:
>select * from "#ZipDest#/".#fnames#
If #ZipDest# is your tableName, you should use: select * from "#ZipDest#/"




Re:Re:DBF_JDBC20.jar
zulkefli aris
2005-10-24 00:00:00.0
"#ZipDest#/" is actually the path to the dbf
Re:Re:Re:DBF_JDBC20.jar
HXTT Supports
2005-10-24 00:00:00.0
>select * from "#ZipDest#/".#fnames#
>"#ZipDest#/" is actually the path to the dbf
You should use: "select * from "#ZipDest#".#fnames# . The last "/" character should be removed.

You can read "4. Can I setup only one datasource to access four servers for my Cold Fusion?" of http://www.hxtt.net/dbf/faq.html#remote if you wish to use full UNC path names in SQL.
Re:Re:Re:Re:DBF_JDBC20.jar
Zulkefli Aris
2005-10-27 00:00:00.0
JDBC URL : jdbc:DBF:/
Driver Class : com.hxtt.sql.dbf.DBFDriver
OS : Linux

When I issue the following query;

select * from /var/ww/html/main/ihq/1109clin

I got an error "Failed to parse: Stopped parse at /"

I am currently using a demo driver. This is the last hurdle before I can decide to buy one. Please help me. Thanks
Re:Re:Re:Re:Re:DBF_JDBC20.jar
HXTT Supports
2005-10-27 00:00:00.0
/var/ww/html/main/ihq/1109clin isn't a UNC path.

You should use:
JDBC URL : jdbc:DBF:////var/ww/html/main/ihq/
select * from 1109clin

Or
JDBC URL : jdbc:DBF:////var/ww/html/main/
select * from ihq.1109clin

Or

JDBC URL : jdbc:DBF:////var/
select * from "ww/html/main/ihq".1109clin

Or

JDBC URL : jdbc:DBF:////
select * from "var/ww/html/main/ihq".1109clin


Re:Re:Re:Re:Re:Re:DBF_JDBC20.jar
Zulkefli Aris
2005-10-27 00:00:00.0
Followed your url setup and below are the results

JDBC URL : jdbc:DBF:////var/ww/html/main/ihq/
select * from 1109clin
OK

JDBC URL : jdbc:DBF:////var/ww/html/main/
select * from ihq.1109clin
Failed to parse: Can't continue parse

JDBC URL : jdbc:DBF:////var/
select * from "ww/html/main/ihq".1109clin
Error : Failed to parse: Can't continue parse

JDBC URL : jdbc:DBF:////
select * from "var/ww/html/main/ihq".1109clin
Error : Failed to parse: Can't continue parse

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