noAccessToProcedureBodies=true Not working with ebean.

[Shobhit Singh]

Hi All,

    We are facing issue with permissions while executing stored procedure on production. We cannot grant select permission on mysql.proc to our user, so wanted to use noAccessToProcedureBodies=true in ebean. I tested this with parameter  noAccessToProcedureBodies=true  in db url but It didn't worked. 

Url used: "jdbc:mysql://192.168.12.12:3306/my_production_db?noAccessToProcedureBodies=true&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull"

Same solution worked while using with jdbc. Can you help how to use this with ebean? Google is of no help currently.

Error:

"javax.persistence.PersistenceException: java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.

at com.avaje.ebeaninternal.server.persist.ExeCallableSql.execute(ExeCallableSql.java:64) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na] at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeSqlCallable(DefaultPersistExecute.java:122) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na] at com.avaje.ebeaninternal.server.core.PersistRequestCallableSql.executeNow(PersistRequestCallableSql.java:49) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na] at com.avaje.ebeaninternal.server.core.PersistRequest.executeStatement(PersistRequest.java:74) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na] at com.avaje.ebeanintern...."

Thanks,

Shobhit

[Shobhit Singh]

Any help with this issue?

[Rob Bygrave]

It's a permission issue. I'd say your DBA's are the ones to help determine the solution.

--

---
You received this message because you are subscribed to the Google Groups "Ebean ORM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ebean+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Shobhit Singh]

Hi Rob, 

 but some how exactly same thing is working with JDBC. same user, same Db, same servers. Only difference, my team is using ebean, and the other team has written wrapper over jdbc.

[Rob Bygrave]

> some how exactly same thing is working with JDBC. same user, same Db, same servers. Only difference, my team is using ebean, and the other team has written wrapper over jdbc.

That is a rather important detail that you have omitted to this point.

Perhaps you could detail exactly the code you are using and exactly the code that they are using?  Are you able to create a reproducable test case?