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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
