You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sis.apache.org by "M. Le Bihan (JIRA)" <ji...@apache.org> on 2014/11/03 05:26:33 UTC
[jira] [Comment Edited] (SIS-184) DBase 3 - JDBC : Simple WHERE
CLAUSE and Integer, Double field support
[ https://issues.apache.org/jira/browse/SIS-184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14194232#comment-14194232 ]
M. Le Bihan edited comment on SIS-184 at 11/3/14 4:26 AM:
----------------------------------------------------------
The JDBC objects implement enough methods to allow [Squirrel SQL|http://squirrel-sql.sourceforge.net/] to be used to query data from a DBF file.
*1)* Open Squirrel SQL, and declare a Driver for DBase 3 using _"create a new Driver"_ button in the Drivers tab.
!SIS184_attach_DBase3_driver_to_Squirrel.png!
*2)* Create an alias to the database you want to query, by the _"create a new Alias"_ button in the Aliases tab
!SIS184_create_alias_to_a_dbase3_file.png!
and connect to it :
!SIS184_connect_to_database.png!
(no need to use a user/password)
*3)* Query the table :
At the time this comment is put the table name checking is in progress : you can put the name you want : a _SELECT * FROM <the only table contained in DBF>_ will always be executed.
!SIS184_query_the_table.png!
*4)* You may also get table metadata :
!SIS184_table_metadata.png!
was (Author: mlebihan):
The JDBC objects implement enough methods to allow [Squirrel SQL|http://squirrel-sql.sourceforge.net/] to be used to query data from a DBF file.
*1)* Open Squirrel SQL, and declare a Driver for DBase 3 using _"create a new Driver"_ button in the Drivers tab.
!SIS184_attach_DBase3_driver_to_Squirrel.png!
*2)* Create an alias to the database you want to query, by the _"create a new Alias"_ button in the Aliases tab
!SIS184_create_alias_to_a_dbase3_file.png!
and connect to it :
!SIS184_connect_to_database.png!
(no need to use a user/password)
*3)* Query the table :
At the time this comment is put the table name checking is in progress : you can put the name you want : a _SELECT * FROM <the only table contained in DBF>_ will always be executed.
!SIS184_query_the_table.png!
> DBase 3 - JDBC : Simple WHERE CLAUSE and Integer, Double field support
> ----------------------------------------------------------------------
>
> Key: SIS-184
> URL: https://issues.apache.org/jira/browse/SIS-184
> Project: Spatial Information Systems
> Issue Type: Improvement
> Components: Features, Storage
> Affects Versions: 0.5
> Reporter: M. Le Bihan
> Priority: Minor
> Attachments: SIS184_attach_DBase3_driver_to_Squirrel.png, SIS184_connect_to_database.png, SIS184_create_alias_to_a_dbase3_file.png, SIS184_query_the_table.png, SIS184_table_metadata.png
>
>
> Following the SIS-180 (select * from DBF) this improvment will add the ability to :
> * Obtain field values from Integer and Double fields.
> * Add a simple WHERE clause with = , >, <, >=, <=, <> operators.
> Relational operators (AND, OR) _might be_ implemented too, depending on the ability of parsing the query easily or not. Else, this feature will come in another JIRA.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)