Thank you very much for your report. Indeed, the catalog is included in the generated SQL when it shouldn't be. Currently, only SQL Server allows for qualifying objects using the catalog.schema.table scheme.
I've created an issue for this: https://github.com/jOOQ/jOOQ/issues/7679 There's currently no other workaround than yours, given that runtime catalog mapping has not yet been implemented: https://github.com/jOOQ/jOOQ/issues/4793 Thanks, Lukas Am Sa., 14. Juli 2018 um 04:54 Uhr schrieb Manuel Rossetti < [email protected]>: > I am working with 'jooq', version: '3.10.4' with postgres > > Schema schema = // from a call to meta() and finding the right schema > > db.getDSLContext().dropSchema(schema.getName()).execute();// works > db.getDSLContext().dropSchema(schema).execute(); // does not work, see > exception below > db.getDSLContext().execute("drop schema jsl_db"); // works > > > The name of my database is "test" and the schema is obviously "jsl_db" > > > Exception in thread "main" org.jooq.exception.DataAccessException: SQL [drop > schema "test"."jsl_db"]; ERROR: syntax error at or near "." > Position: 19 > at org.jooq_3.10.4.POSTGRES.debug(Unknown Source) > at org.jooq.impl.Tools.translate(Tools.java:2239) > at > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:704) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:361) > at > jsl.utilities.reporting.JSLDatabase.dropJSLDbSchema(JSLDatabase.java:345) > at > jsl.utilities.reporting.JSLDatabase.createJSLDatabase(JSLDatabase.java:305) > at > jsl.utilities.reporting.JSLDatabase.createPostgresJSLDatabase(JSLDatabase.java:279) > at > jsl.utilities.reporting.JSLDatabase.createPostgresLocalHostJSLDatabase(JSLDatabase.java:253) > at > ex.queueing.DriverLicenseBureauWithQ.runExperiment(DriverLicenseBureauWithQ.java:264) > at > ex.queueing.DriverLicenseBureauWithQ.main(DriverLicenseBureauWithQ.java:207) > Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near > "." > Position: 19 > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) > at > org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155) > at > org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144) > at > com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) > at > com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) > at > org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:429) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:347) > ... 6 more > > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
