org.jkiss.dbeaver.DBException: SQL Error [S1000]: 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 | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Null Pointer Exception in MySQL Procedure Generate DDL and Edit Procedure

    GitHub | 8 months ago | sumisuburaianto
    org.jkiss.dbeaver.DBException: SQL Error [S1000]: 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