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

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

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