Does anybody get the follow error when running the codegen on MySQL
SELECT command denied to user 'dstack'@'localhost' for table 'proc'
I've included the full stack trace below. In the end it doesn't cause any
problems, but it just makes it seems like the generation failed. I do have
the config
<excludes>.*proc</excludes>
But that doesn't seem to matter. I stepped through the code once and it
seemed to be with the procs that the error happened before it ever
processed the include/exclude logic. (Ignore the fact that you see Drizzle
in the stack trace. I'm using the Drizzle JDBC driver w/ MySQL, its still
MySQL 5.5. Same issue happens with the Connector/J MySQL JDBC driver)
Thanks,
Darren
14:43:08.543 [org.jooq.util.GenerationTool.main()] ERROR
org.jooq.util.AbstractDatabase - Error while fetching functions
org.jooq.exception.DataAccessException: SQL [select `mysql`.`proc`.`db`,
`mysql`.`proc`.`name`, `mysql`.`proc`.`comment`,
`mysql`.`proc`.`param_list`, `mysql`.`proc`.`returns`,
`mysql`.`proc`.`type` from `mysql`.`proc` where `mysql`.`proc`.`db` in (?)
order by `mysql`.`proc`.`db` asc, `mysql`.`proc`.`name` asc]; SELECT
command denied to user 'dstack'@'localhost' for table 'proc'
at org.jooq.impl.Utils.translate(Utils.java:1254)
~[jooq-3.3.0-SNAPSHOT.jar:na]
at
org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:495)
~[jooq-3.3.0-SNAPSHOT.jar:na]
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:326)
~[jooq-3.3.0-SNAPSHOT.jar:na]
at
org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:330)
~[jooq-3.3.0-SNAPSHOT.jar:na]
at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2256)
~[jooq-3.3.0-SNAPSHOT.jar:na]
at
org.jooq.util.mysql.MySQLDatabase.getRoutines0(MySQLDatabase.java:326)
~[jooq-meta-3.3.0-SNAPSHOT.jar:na]
at
org.jooq.util.AbstractDatabase.getRoutines(AbstractDatabase.java:702)
~[jooq-meta-3.3.0-SNAPSHOT.jar:na]
at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:279)
[jooq-codegen-3.3.0-SNAPSHOT.jar:na]
at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:212)
[jooq-codegen-3.3.0-SNAPSHOT.jar:na]
at org.jooq.util.GenerationTool.run(GenerationTool.java:347)
[jooq-codegen-3.3.0-SNAPSHOT.jar:na]
at org.jooq.util.GenerationTool.main(GenerationTool.java:172)
[jooq-codegen-3.3.0-SNAPSHOT.jar:na]
at org.jooq.util.GenerationTool.main(GenerationTool.java:159)
[jooq-codegen-3.3.0-SNAPSHOT.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.7.0_45]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[na:1.7.0_45]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_45]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45]
at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297)
[exec-maven-plugin-1.2.1.jar:na]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
Caused by: java.sql.SQLSyntaxErrorException: SELECT command denied to user
'dstack'@'localhost' for table 'proc'
at
org.drizzle.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:99)
~[drizzle-jdbc-1.2.jar:na]
at
org.drizzle.jdbc.DrizzlePreparedStatement.execute(DrizzlePreparedStatement.java:167)
~[drizzle-jdbc-1.2.jar:na]
at
org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)
~[jooq-3.3.0-SNAPSHOT.jar:na]
at
org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:261)
~[jooq-3.3.0-SNAPSHOT.jar:na]
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:322)
~[jooq-3.3.0-SNAPSHOT.jar:na]
... 15 common frames omitted
Caused by: org.drizzle.jdbc.internal.common.QueryException: SELECT command
denied to user 'dstack'@'localhost' for table 'proc'
at
org.drizzle.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:464)
~[drizzle-jdbc-1.2.jar:na]
at
org.drizzle.jdbc.DrizzlePreparedStatement.execute(DrizzlePreparedStatement.java:164)
~[drizzle-jdbc-1.2.jar:na]
... 18 common frames omitted
--
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.
