Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.142
  HXTT Cobol 5.0.142
  HXTT DBF 7.1.143
  HXTT Excel 6.1.146
  HXTT Json 1.0.114
  HXTT Paradox 7.1.142
  HXTT PDF 2.0.142
  HXTT Text(CSV) 7.1.142
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Word 1.1.142
  HXTT XML 4.0.143
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Text(CSV)
Case Insensitive queries on CSV files through ftp
Francesco Stampacchia
2011-08-03 07:54:00.0
Hello HXTT Team,
I'm working with your TEXT Driver and I'm trying to read data from some CSV files that are stored under a remote server.

When I performed my queries I noticed unfortunatley that they're case-sensitive.

Is there a parameter that has to be specified in the connection url or somewhere else in order to perform a case insensitive query ?

Thanks in advance.
Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-03 08:04:24.0
Because All of http, https, and ftp protocol are case-sensitive, you have to take care of your sql, and use proper table file suffix to avoid FileNotFound exception.
Re:Re:Case Insensitive queries on CSV files through ftp
Francesco Stampacchia
2011-08-03 08:08:42.0
Does this happens even when I specify filters on the queries ?!
Re:Re:Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-03 08:19:12.0
>Does this happens even when I specify filters on the queries ?!
What's your filter samples?
Re:Re:Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-03 08:21:42.0
Whethter you need caseInsensitive connection property for sql?
caseInsensitive: Indicates whether is case insensitve for string comparison. You can use null, true, false
Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
Francesco Stampacchia
2011-08-03 08:26:40.0
Let's say I've got a cell in my cvs that has value 'Naval' and I want to search with LIKE 'na*' and find 'Naval' as well.

So if caseInsensitive property allows me to do that, how do I have to pass this property in my hibernate connection ?

i.e. ftp://domain\user:password@server?_CSV_Separator=/t;caseInsensitive=true

Is this correct ?

Sorry I didn't mention before that I use Hibernate to perform my queries with your driver.
Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-03 08:35:32.0
Then we will provide it in about 2 hours.
Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
Francesco Stampacchia
2011-08-03 08:39:39.0
Thank you very much!
Re:Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-03 09:01:55.0
>i.e. ftp://domain\user:password@server?_CSV_Separator=/t;caseInsensitive=true
>Is this correct ?
Yeah. Now you can download the latest package which has provided caseInsensitive property.
Re:Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
Francesco Stampacchia
2011-08-03 09:14:43.0
Thank you for the package, but is this connection string I'm using on Hibernate correct to perform caseInsensitive queries?

jdbc:csv:ftp://domain\user:password@server?_CSV_Separator=/t;caseInsensitive=true

or do I have to pass multiple parameters in another way, like with an & in between?
Re:Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-03 09:25:20.0
Correct. ; is preferable, & is supported too.
Re:Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
Francesco Stampacchia
2011-08-03 09:40:44.0
Sorry but it still doesn't work neither with the ; nor with the & if I search by a LIKE filter such as LIKE 'n%' it doesn't return 'Naval' or such.

Remember that I'm using Hibernate to do that.

Is there a workaround to this trouble?!
Re:Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-03 09:48:57.0
Check your classpath to make sure that you have removed all older package.
Re:Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
Francesco Stampacchia
2011-08-04 02:43:54.0
I'm developing a web application that is deployed under Tomcat.

So I removed all the old packages under my application ./lib folder and checked that none of the old packages was stored under Tomcat, but it still not able to perform a caseInsensitive query with the parameter specified.
Re:Re:Re:Re:Re:Re:Re:Re:Case Insensitive queries on CSV files through ftp
HXTT Support
2011-08-04 03:17:40.0
>So I removed all the old packages under my application ./lib folder and checked
> that none of the old packages was stored under Tomcat, but it still not able to >perform a caseInsensitive query with the parameter specified.
You can try restart Tomcat since it maybe cached old package in memory.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap