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

[Sanjaya Karunasena ( සංජය )]

mmm... Data in the HR department? Yes fun, useful???, but certainly insecure.

On Wednesday 21 May 2008, 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.
>
> 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
>
> _______________________________________________
> Ds-java-dev mailing list
> Ds-java-dev at wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/ds-java-dev