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