Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-13 Thread Andrea Aime
On Thu, Nov 13, 2014 at 10:20 AM, fmd85 wrote: > I've just upgraded to Version 12, but the error stays the same: > If you look at the ticket, you'll see the first release to have the fix is going to be 12.1, which should be released next week. In the meantime you can build from sources, using th

Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-13 Thread fmd85
geowolf wrote > On Wed, Nov 12, 2014 at 2:16 PM, fmd85 < > florian-dietz@ > > wrote: > >> geowolf wrote >> > Hi, >> > I've never tried, but did you setup the store to expose the primary key >> as >> > normal >> > attributes? I don't think we have a way to join on the feature >> identifiers >> >

Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-12 Thread Andrea Aime
On Wed, Nov 12, 2014 at 2:16 PM, fmd85 wrote: > geowolf wrote > > Hi, > > I've never tried, but did you setup the store to expose the primary key > as > > normal > > attributes? I don't think we have a way to join on the feature > identifiers > > (which > > is what the primary keys become when ge

Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-12 Thread fmd85
Ron Lindhoudt wrote > Did you try to add " around the column names?What database do you > use?Maybe you can turn on GeoTools logging to see what SQL statement is > executed.You can turn on JDBC logging in logging.properties : > org.geotools.jdbc.level=FINESTorg.geotools.jdbc.SQLDialect.level=FINEST

Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-12 Thread Ron Lindhoudt
Did you try to add " around the column names?What database do you use?Maybe you can turn on GeoTools logging to see what SQL statement is executed.You can turn on JDBC logging in logging.properties : org.geotools.jdbc.level=FINESTorg.geotools.jdbc.SQLDialect.level=FINEST On Wednesday, 12

Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-12 Thread fmd85
geowolf wrote > Hi, > I've never tried, but did you setup the store to expose the primary key as > normal > attributes? I don't think we have a way to join on the feature identifiers > (which > is what the primary keys become when geotools handles them) Hi, at the beginning i used DataStore ds= D

Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-12 Thread Andrea Aime
Hi, I've never tried, but did you setup the store to expose the primary key as normal attributes? I don't think we have a way to join on the feature identifiers (which is what the primary keys become when geotools handles them) Cheers Andrea On Wed, Nov 12, 2014 at 7:50 AM, fmd85 wrote: > Hi,

Re: [Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-11 Thread Ron Lindhoudt
Try exposing the primary key columns with:             ((JDBCFeatureSource) featureSource).setExposePrimaryKeyColumns(true); Also use "" around the ID-column names.And use table aliases in the filter (not really necessary in your case but in that way you can use ID as PK-column-name in all your

[Geotools-gt2-users] Join on Primary Keys in a Query

2014-11-11 Thread fmd85
Hi, i'm trying to join two tables in a Query. They should be joined with their primary keys. If i define the join in the query i get an IllegalArgumentException, Attribute "ID_A" not present in table A or table B (defining Filters on a primary key column also fails). *The tables:* Columns Table A