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

[Samisa Abeysinghe]

Keith Chapman wrote:
> 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.

Has anyone user asked for this? I mean why is this a priority?

Where can I find the road map for DS?

Thanks,
Samisa...

>
> 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
>>>   
>>
>>
> ------------------------------------------------------------------------
>
>
> 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
>   


-- 
Samisa Abeysinghe 
Director, Engineering; WSO2 Inc.

http://www.wso2.com/ - "The Open Source SOA Company"