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)
two questions
Paul Kneeland
2005-10-11 00:00:00.0
I am evaluating your driver. I have it working but have two questions:

1) Is there a way to make the driver function on a stream or other in memory repository instead of only files. The reason for this is I have the data already in memory and would rather not have to save them as a file. I am using them read only.

2) I am dealing with line feed terminated fixed formatted rows. However if the data in a row is not complete it is not pad filled. Is there a way to have the driver handle this or do I need to pad the files to the maximum size.
Re:President
HXTT Support
2005-10-11 00:00:00.0
>1) Is there a way to make the driver function on a stream or other in memory
> repository instead of only files. The reason for this is I have the data
> already in memory and would rather not have to save them as a file.
> I am using them read only.
Yeah. We can provide such a function. But how to provide an API for your? Your suggestions are welcome. Can we use "create MEMORY table ..." to provide a table defination? Then
String sql="insert into thatMemoryTable ?;";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setBytes(1,yourBytes);//insert your byte[] data into table thatMemoryTable.
Or
pstmt.setBinaryStream(1,yourStream);//insert yourStream into table thatMemoryTable.
pstmt.executeUpdate();
pstmt.close();
But it seems still complicated for utilzation. What's your opinion and suggestion?

>2) I am dealing with line feed terminated fixed formatted rows. However if
> the data in a row is not complete it is not pad filled. Is there a way to
> have the driver handle this or do I need to pad the files to the
> maximum size.
For instance, you can add "_StuffedColumn char(2) default '\r\n'" as the last column. Default value can be used for any column. Let me know more about your requirement, then I will show you how to use sql or code to solve your issue. You can send text sample to webmaster@hxtt.com too.



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