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)
Error with new version of JAR
Alberto Amerio
2007-06-27 01:36:32.0
My license is laura.massei@ogilvy.com / 610152

this morning I uploaded the last version of JAR file and I have this error
error in opening JAR file C:\jar\_latest\hxtt\Text_JDBC30.jar
What do I do?

I must to send my job today and I'm disperate! Help me please!
Thank you for your attention.
Re:Error with new version of JAR
HXTT Support
2007-06-27 02:37:31.0
Please try to redownload it. Thanks for your patience.
Re:Re:Error with new version of JAR
Alberto Amerio
2007-06-27 02:46:03.0
Thanks.
I've another problem.
I created a file with bulk insert:
The parameters are
..._CSV_Separator char(1) default '|',_CSV_Header boolean default true...

String sql="insert into " + tablename + " ?";
PreparedStatement pstmt = dbm.getHTTXConnection(pathname, info).prepareStatement(sql);
pstmt.setObject(1,rs);//insert a resultSet into table test.
pstmt.executeUpdate();
pstmt.close();

i have a field with no space before text but it's saved with space:
example:

Field1|field2
AAA| BBB

My query returns select ltrim(rtrim(Field1)), ltrim(rtrim(Field2)) and i'm sure that not exists spaces in first char of my field.
What do I do?
Re:Re:Re:Error with new version of JAR
HXTT Support
2007-06-27 02:56:48.0
What's your CREATE TABLE sql for your table? What's your JDBC url?

>i have a field with no space before text but it's saved with space:
1st possibility: the values in source table has space.
2st possibility: you're using varchar(n) or char(n) in CREATE TABLE sql, and you can try longvarchar column type.
Re:Re:Re:Error with new version of JAR
HXTT Support
2007-06-27 02:58:17.0
BTW, you can use:
ALLTRIM(string1): removes all leading and trailing blanks in string1
Or
TRIM([[BOTH | LEADING | TRAILING] [removedstring1] FROM] string1): remove the removedstring1 (a space by default) from the start/end/both ends of the string1.

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