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

[Sumedha Rubasinghe]

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/