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.

GitHub | sumisuburaianto | 11 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Null Pointer Exception in MySQL Procedure Generate DDL and Edit Procedure

    GitHub | 11 months ago | sumisuburaianto
    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.

    Root Cause Analysis

    1. 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.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      JDBC4DatabaseMetaData.getProcedureColumns
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
      2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
      4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)
      5. com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1633)
      6. com.mysql.jdbc.DatabaseMetaData.getProcedureOrFunctionColumns(DatabaseMetaData.java:3968)
      7. com.mysql.jdbc.JDBC4DatabaseMetaData.getProcedureColumns(JDBC4DatabaseMetaData.java:108)
      7 frames
    3. org.jkiss.dbeaver
      MySQLProcedure.getParameters
      1. org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCDatabaseMetaDataImpl.getProcedureColumns(JDBCDatabaseMetaDataImpl.java:1111)
      2. org.jkiss.dbeaver.ext.mysql.model.MySQLCatalog$ProceduresCache.prepareChildrenStatement(MySQLCatalog.java:578)
      3. org.jkiss.dbeaver.ext.mysql.model.MySQLCatalog$ProceduresCache.prepareChildrenStatement(MySQLCatalog.java:1)
      4. org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructCache.loadChildren(JDBCStructCache.java:90)
      5. org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructCache.getChildren(JDBCStructCache.java:210)
      6. org.jkiss.dbeaver.ext.mysql.model.MySQLProcedure.getParameters(MySQLProcedure.java:224)
      6 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    5. org.jkiss.dbeaver
      RunnableContextDelegate$1.run
      1. org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.extractPropertyValue(DBNDatabaseNode.java:719)
      2. org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.loadTreeItems(DBNDatabaseNode.java:449)
      3. org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.loadChildren(DBNDatabaseNode.java:375)
      4. org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:192)
      5. org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:1)
      6. org.jkiss.dbeaver.ui.editors.entity.properties.ObjectPropertiesEditor.collectNavigatorTabs(ObjectPropertiesEditor.java:422)
      7. org.jkiss.dbeaver.ui.editors.entity.properties.ObjectPropertiesEditor.access$3(ObjectPropertiesEditor.java:415)
      8. org.jkiss.dbeaver.ui.editors.entity.properties.ObjectPropertiesEditor$2.run(ObjectPropertiesEditor.java:382)
      9. org.jkiss.dbeaver.core.DBeaverUI$4.run(DBeaverUI.java:253)
      10. org.jkiss.dbeaver.runtime.RunnableContextDelegate$1.run(RunnableContextDelegate.java:45)
      10 frames
    6. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
      1 frame