sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin Desruisseaux (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SIS-180) Place a crude JDBC driver over Dbase files
Date Mon, 13 Oct 2014 17:04:34 GMT

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

Mime
View raw message