You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sis.apache.org by Marc Le Bihan <ml...@gmail.com> on 2014/10/05 21:17:53 UTC
Another improvment suggested on JIRA : JDBC driver over DBase 3.
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
Re: Another improvment suggested on JIRA : JDBC driver over DBase
3.
Posted by Martin Desruisseaux <ma...@geomatys.fr>.
Le 06/10/14 22:12, Adam Estrada a écrit :
> This is outstanding, Marc. Do you envision adding a SQL query layer
> for any supported SIS formats or just for DBF3?
I would suggest to begin with DBF3. Defining a query language for all
supported SIS formats requires that we complete the API of DataStore
base class first. Furthermore, SQL is not quite appropriate for querying
some kind of data like rasters. But some derivative of SQL can fit.
There is some material at OGC about a query language for geospatial
data. We should probably look at them.
Martin
Re: Another improvment suggested on JIRA : JDBC driver over DBase 3.
Posted by Adam Estrada <es...@gmail.com>.
This is outstanding, Marc. Do you envision adding a SQL query layer
for any supported SIS formats or just for DBF3?
Thanks,
Adam
On Sun, Oct 5, 2014 at 3:17 PM, Marc Le Bihan <ml...@gmail.com> wrote:
> 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
Re: Another improvment suggested on JIRA : JDBC driver over DBase 3.
Posted by Adam Estrada <es...@gmail.com>.
Thanks Martin. That form is typically used when project members are
VOTE'd in to the project and have committer access to SVN. Marc is
doing an excellent job of moving the project forward so I am hopeful
that any future VOTE's called for him will be in his favor.
Cheers,
Adam
On Mon, Oct 6, 2014 at 9:52 PM, Martin Desruisseaux
<ma...@geomatys.fr> wrote:
> 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
>
Re: Another improvment suggested on JIRA : JDBC driver over DBase 3.
Posted by Marc Le Bihan <ml...@gmail.com>.
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 <ma...@geomatys.fr>:
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
Re: Another improvment suggested on JIRA : JDBC driver over DBase 3.
Posted by Marc LE BIHAN <ml...@gmail.com>.
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 <
martin.desruisseaux@geomatys.fr>:
> 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
>
>
Re: Another improvment suggested on JIRA : JDBC driver over DBase
3.
Posted by Martin Desruisseaux <ma...@geomatys.fr>.
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