Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Text(CSV)
Sun Studio Creator
Adrian Hine
2005-09-19 00:00:00.0
Dear Sir/Madam,

I would like to assess the HXTT Driver to see if it works in my application. However I cannot get the driver to work at the moment. Could you please advise whether it is something I am doing incorrectly. I have two questions:

(1) When I run the driver using the following code I get the correct number of columns and rows in csv file but the data values are nonsense. Are the nonsense values deliberate as it is evaluation code or do I need to configure something??

Example Results from query:
[B@1ccb029 [B@1415de6 [B@7bd9f2 [B@121cc40 [B@1e893df [B@443226 null null [B@1386000 null null null null null null null null

(2) Also I would like to use the driver in Sun Studio Creator. This application uses Datasources and JNDI. In your documentation you say that driver properties are set using
Connection con = DriverManager.getConnection(url,properties);

I DO NOT use this method to get a connection from my rowset. How else do I set driver properties using a datasource method?

Re:Mr
HXTT Support
2005-09-19 00:00:00.0
>Example Results from query:
>[B@1ccb029 [B@1415de6 [B@7bd9f2 [B@121cc40 [B@1e893df [B@443226 null null
> [B@1386000 null null null null null null null null
Check your CREATE TABLE sql. You can try to remove your CREATE TABLE sql to get the default varchar value too for CSV file.

>(2) Also I would like to use the driver in Sun Studio Creator.
> This application uses Datasources and JNDI.
HXTT Text (CSV) support JNDI too. For instance:
HxttConnectionPoolDataSource hxttDS = new
HxttConnectionPoolDataSource();
properties.setProperty("url","jdbc:text:////usr/local/ftproot/hxtt");
properties.setProperty("fileExtension","bin");
properties.setProperty("schemaFile","schemaHXTT.txt");
You can read How to set up HXTT Text (CSV) with Tomcat4.1 as PoolableConnection?
in http://www.hxtt.net/text/faq.html#interoperability if you need to set a similar xml setting.


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