[Ds-java-dev] JDBC driver for Excel sheets

[Keith Chapman]

Samisa Abeysinghe wrote:
> What about the user demand for this feature? Would people really use 
> Excel in an "enterprise" setup?

There is a potential use case for this scenario. For e.g Say the HR dept 
has some information in some excel files. With DS you can easily mash it 
up with some other data to provide a useful output. So its fun + useful.

Thanks,
Keith.
> 
> My view is that this feature is fun to have but not that useful feature.
> 
> Thanks,
> Samisa...
> 
> 
> Sumedha Rubasinghe wrote:
>> Hi all,
>> I am planning to give a JDBC interface** to Excel spreadsheets. This 
>> will undoubtedly make DS solution attractive as one can query(CRUD) 
>> spread sheets using SQL.
>>
>> xlSQL[1] seems to be the only OS driver available. There are quite a 
>> number of references to it in the Web too. Wrote few examples & JDBC 
>> interface looks quite flexible. Basically I am comfortable with 
>> features it has.
>>
>> However,initially I had to do a fix to get it working. Later I found 
>> out the same issue is reported on their site as well [2].
>>
>> I would like to know your views on following.
>>
>> 1. Although it looks stable, project seems to be no longer active. 
>> Therefore I do not think sending a patch would work.
>>
>> 2. Since it is licensed under GPL v2.0, we have to ask users to 
>> download it & put into DS solution lib
>>
>> 3. Source for last release is available, is it possible for us to 
>> host(under GPLv2.0) the project with my patch applied?
>> If this option is possible, I am quite OK with it.
>>
>> 4. Are there any other JDBC drivers for Excel that I might have missed?
>>
>> 5. Should we contact xlSQL author[3] & check the possibility of 
>> getting a new release?
>>
>> Thanks,
>> /sumedha
>>
>>
>> **
>> Right now I am using Apache POI to read Excel files. This has many 
>> performance related limitations when it comes to querying.
>>
>>
>> [1] https://xlsql.dev.java.net/
>> [2] https://xlsql.dev.java.net/issues/show_bug.cgi?id=26
>> [3] http://jimcaprioli.blogspot.com/
>>
>> _______________________________________________
>> Ds-java-dev mailing list
>> Ds-java-dev at wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/ds-java-dev
>> ------------------------------------------------------------------------
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.21/1457 - 
>> Release Date: 5/20/2008 4:45 PM
>>   
> 
>