[
https://issues.apache.org/jira/browse/SIS-180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14169542#comment-14169542
]
Martin Desruisseaux commented on SIS-180:
-----------------------------------------
Thanks Marc. I installed your code on my local copy and looked at it. I didn't
saw any license header, while the Apache foundation requires us to put the
Apache 2 license in every Java source files. I could easily copy-and-paste
them, but can not do that without your formal authorization. Would it be
possible to follow those steps, if you accept of course? It should take only
about 10 minutes:
* Go to http://www.apache.org/licenses/icla.txt
* Print that page.
* Fill it and sign it.
* Scan it as a PDF document
* Send the PDF by email to the Apache secretary (address is given on the page).
* Inform us when you got the reply from the secretary (they are usually fast).
Note that it does not remove any of your rights on your code - you are still
free to do all you want with your original copies.
On technical topics, would you mind if I apply the following editions?
* I would like to put the {{org.apache.sis.storage.database*}} classes as
package-privated classes in {{org.apache.sis.storage.shapefile}} for now. It is
not necessarily forever - we could make them public later. But it is much
easier to start strict, then relax later if needed, than the converse.
* We could integrate the resource files with the Apache SIS resource systems.
It is an extension of the standard {{ResourceBundle}} which take cares of using
{{MessageFormat}} itself, so we don't have to repeat the later in every classes
using resources.
> Place a crude JDBC driver over Dbase files
> ------------------------------------------
>
> Key: SIS-180
> URL: https://issues.apache.org/jira/browse/SIS-180
> Project: Spatial Information Systems
> Issue Type: Improvement
> Components: Storage
> Affects Versions: 0.5
> Reporter: M. Le Bihan
> Assignee: Martin Desruisseaux
> Priority: Minor
> Fix For: 0.5
>
> Attachments: src.zip
>
>
> It would be useful to be able to query DBF content through SQL.
> But there are no free drivers available for the old _Dbase 3_ format.
> The first step is to create short implementations of _Connection_,
> _Statement_, _ResultSet_, _ResultSetMetadata_ interfaces for a JDBC using our
> _Database_ class as core binary loader at the begining.
> The main difficulty is to respond to a SQL request, and first : being able to
> analyze it to understand what is expected.
> The SQL request analysis is a very strong job, but I suggest to ease it a lot
> by relying on _AntLR_ API for grammar analysis, associated with a BNF grammar
> file, maybe taken from ^1^ or from elsewhere (grammars are of public domain).
> The goal of this current JIRA is only to be able to perform a
> _SELECT * FROM <shapefile layer name>_
> The WHERE clause or the selection of fields, will come later in other JIRA.
> No transactions, classic _Statement_ only.
> _PreparedStatement_ would be also implemented later (another JIRA).
> Of course, this improvment can be discarded if an open source or free driver
> is discovered, that would allow us to execute SQL requests on DBase 3 easily.
> ^1^ For example, [http://www.savage.net.au/SQL/] has some BNF, but maybe
> elsewhere they will more compliant with AntLR.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
