Hello, I have completed the JIRA SIS-180 [1] and sent you the sources in a zip attachment. If there are some troubles in code formatting, warn me. My Eclipse maybe not perfectly set, and myself I have my fancies.
Regards, Marc. [1] https://issues.apache.org/jira/browse/SIS-180 From: Marc LE BIHAN Sent: Tuesday, October 07, 2014 10:15 AM To: dev Subject: Re: Another improvment suggested on JIRA : JDBC driver over DBase 3. Hello, My goals are : 1) query DBF to be able later to join fields from various tables. Some fields from our DBF, or other maybe coming from elsewhere. Currently, I'm beggining this step. Connection and Driver are ok, but they were the easy parts. 2) be able to INSERT, UPDATE and DELETE into this DBF. 3) be able to save a shapefile and re-read it perfectly from another software. Then, the Apache SIS API will allow to enrich a shapefile data with a new field, for example. You are right : responding first to a single "SELECT * FROM TABLE" without involving AntLR will be far easier and safer first. Regards, Marc Le Bihan. 2014-10-07 3:52 GMT+02:00 Martin Desruisseaux <[email protected]>: Hello Marc Thanks for the files. I commented on SIS-179 and while look at them soon. Since this seems a significant amount of work (especially if going ahead with SQL), would it be possible to sign Contributor License Agreement (ICLA) and sent it to the Apache secretary please? (secretary email is given in the ICLA): http://www.apache.org/licenses/icla.txt Chris, Adam or anyone else, please correct me if this is not the correct procedure. Thanks! Martin Le 06/10/14 04:17, Marc Le Bihan a écrit : > Hello again, > > Following the splitting of the Database class from the Shapefile [2], I am attempting a good challenge (of the kind I’m loving) : setting a JDBC driver over our DBase 3 files. > We have no DBase 3 driver available. I have searched a long time but nothing is free, when something exist. > > Relying on our Database class that is able to read a DBF file binary content, I will try to implement a Connection, a Statemement, a ResultSet and a ResultSetMetaData classes, in order to have an embedded JDBC driver inside Apache SIS, and be able to start querying data more easily, by using SQL. > I put some information about how I think I will proceed in a new JIRA [1]. > > Regards, > > Marc Le Bihan > > [1] https://issues.apache.org/jira/browse/SIS-180 > [2] https://issues.apache.org/jira/browse/SIS-179
