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.
|
Please try to redownload it. Thanks for your patience.
|
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?
|
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.
|
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.
|