[Geotools-gt2-users] Use multiple Oracle database schema's in Query

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

How do I make a query that uses 2 tables from 2 different Oracle schema's?

I 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 this doesn't work because a schema is not allowed before a table name.
Is there another way to achieve this?

There is a posting of Andrea Aime about this issue in January 2012: http://osgeo-org.1560.n6.nabble.com/JDBC-stores-hitting-multiple-schemas-td4265136.html
What is the status?


Thanks.
Ron