M. Le Bihan created SIS-180:
-------------------------------
Summary: 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
Priority: Minor
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)
