Hi , Amazon Redhsift is based on Postgres 8.4 drivers. Is there a possibility to use JOOQ with the same?
Is there any way I can configure jooq to skip sequences, enums etc. I am interested in only 2 tables. The errors I get are : org.jooq.exception.DataAccessException: SQL [select distinct "information_schema"."attributes"."udt_schema", "information_schema"."attributes"."udt_name" from "information_schema"."attributes" where "information_schema"."attributes"."udt_schema" in (?) order by "information_schema"."attributes"."udt_schema" asc, "information_schema"."attributes"."udt_name" asc]; ERROR: relation "information_schema.attributes" does not exist at org.jooq.impl.Utils.translate(Utils.java:1078) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:302) at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:319) at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:1024) at org.jooq.util.postgres.PostgresDatabase.getUDTs0(PostgresDatabase.java:340) at org.jooq.util.AbstractDatabase.getUDTs(AbstractDatabase.java:583) at org.jooq.util.JavaGenerator.generateSchema(JavaGenerator.java:1582) at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:183) at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:174) at org.jooq.util.GenerationTool.run(GenerationTool.java:291) at org.jooq.util.GenerationTool.main(GenerationTool.java:135) at org.jooq.util.GenerationTool.main(GenerationTool.java:122) Caused by: org.postgresql.util.PSQLException: ERROR: relation "information_schema.attributes" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2096) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1829) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379) at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:189) at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:250) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:298) ... 10 more Sep 9, 2013 4:15:58 PM org.jooq.tools.JooqLogger info INFO: ARRAYs fetched : 0 (0 included, 0 excluded) Sep 9, 2013 4:15:58 PM org.jooq.tools.JooqLogger error SEVERE: Error while fetching enums org.jooq.exception.DataAccessException: SQL [select "pg_catalog"."pg_namespace"."nspname", "pg_catalog"."pg_type"."typname", "pg_catalog"."pg_enum"."enumlabel" from "pg_catalog"."pg_enum" join "pg_catalog"."pg_type" on (pg_enum.enumtypid = pg_type.oid) join "pg_catalog"."pg_namespace" on (pg_type.typnamespace = pg_namespace.oid) where "pg_catalog"."pg_namespace"."nspname" in (?) order by "pg_catalog"."pg_namespace"."nspname" asc, "pg_catalog"."pg_type"."typname" asc, "pg_catalog"."pg_enum"."enumlabel" asc]; ERROR: relation "pg_catalog.pg_enum" does not exist at org.jooq.impl.Utils.translate(Utils.java:1078) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:302) at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:319) at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:1024) at org.jooq.util.postgres.PostgresDatabase.getEnums0(PostgresDatabase.java:305) at org.jooq.util.AbstractDatabase.getEnums(AbstractDatabase.java:489) at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:237) at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:174) at org.jooq.util.GenerationTool.run(GenerationTool.java:291) at org.jooq.util.GenerationTool.main(GenerationTool.java:135) at org.jooq.util.GenerationTool.main(GenerationTool.java:122) Caused by: org.postgresql.util.PSQLException: ERROR: relation "pg_catalog.pg_enum" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2096) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1829) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379) at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:189) at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:250) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:298) ... 9 more Regards, Elly -- 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/groups/opt_out.
