Re: [Geotools-gt2-users] Joining tables from multiple schema's

[Ron L. <rli...@ya...>]

There is also a problem when I join 2 tables of the same Oracle schema:

                Query query = new Query("table1");
                query.setAlias("tab1");
                Join join = new Join("table2", CQL.toFilter("tab1.column1 = tab2.column2"));
                join.setAlias("tab2");
                query.getJoins().add(join);

                FeatureCollection featureCollection = featureSource.getFeatures(query);

I get a RuntimeException saying property tab1/column1 is not found in table1.
Notice that the . in " tab1.column1" is replaced by a / in the exception message.

Ron






________________________________
 From: Ron Lindhoudt <rli...@ya...>
To: "geo...@li..." <geo...@li...> 
Sent: Tuesday, October 23, 2012 3:55 PM
Subject: [Geotools-gt2-users] Joining tables from multiple schema's
 

Is there a way to make an Oracle query that uses tables from 2 different schema's?

There was a posting from Andrea Aime in January 2012:

http://osgeo-org.1560.n6.nabble.com/JDBC-stores-hitting-multiple-schemas-td4265136.html

It looks like it was not possible. What is the situation now?

I would expect something like this:

                Query query = new Query("schema1.table1);
               
 query.setAlias("tab1");
                Join join = new Join("schema2.table2", CQL.toFilter("tab1.ID=tab2.ID"));
                join.setAlias("tab2");
                query.getJoins().add(join);


But at the moment you have to specify the schema at the Datastore and you cannot add a schema to the table-name in Query.


Ron

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
GeoTools-GT2-Users mailing list
Geo...@li...
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users