Hello Lukas,
Here my snippet, maybe i am doing something basic the wrong way...
SchemaMapping mapping = new SchemaMapping();
mapping.add(Beree.BEREE, "BEREP");
Factory berechtigung = new Factory(getConnection(), SQLDialect.ORACLE,
mapping);
Query query = berechtigung
.select(Behoerde.KURZBEZEICHNUNG)
.from(Behoerde.BEHOERDE)
.where(Behoerde.BEZEICHNUNG.equal("NAME1"));
System.out.println(query.getSQL());
//not working - console output:
//select BEREE.BEHOERDE.KURZBEZEICHNUNG from BEREE.BEHOERDE where
BEREE.BEHOERDE.BEZEICHNUNG = ?
System.out.println(berechtigung.render(query));
//working - console output:
//select "BEREP"."BEHOERDE"."KURZBEZEICHNUNG" from "BEREP"."BEHOERDE"
where "BEREP"."BEHOERDE"."BEZEICHNUNG" = ?
kind regards
ralf
On 20 Okt., 18:37, Lukas Eder <[email protected]> wrote:
> Hello Bert,
>
> >> But here the schema mapping is not considered => is this the expected
> >> behaviour ?
>
> > That is not expected. Both SQLDialect and SchemaMapping should be
> > considered in this case. I'll further analyse this potential bug:
> >https://sourceforge.net/apps/trac/jooq/ticket/880
>
> I could not reproduce this issue. Query.getSQL() correctly renders
> mapped schemata in my integration tests. Maybe you can provide me with
> some code to reproduce the issue? How are you constructing your Query?
>
> Cheers
> Lukas
