Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4511

Error while Retrieving view data from database

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.2.2.0
    • None
    • SQL
    • Urgent
    • Seen in production

    Description

      I am running an application ,in which I have used Apache Derby as a backend.
      While retrieving the values from resultset i am getting below error.

      ERROR 38001: The external routine is not allowed to execute SQL statements.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericAuthorizer.externalRoutineException(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source)
      at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteCascadeResultSet(Unknown Source)
      at org.apache.derby.exe.aceeb848bfx0125xd416xdf4ex00000e7f746f8c.fillResultSet(Unknown Source)
      at org.apache.derby.exe.aceeb848bfx0125xd416xdf4ex00000e7f746f8c.execute(Unknown Source)
      at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
      at com.wm.app.b2b.server.dispatcher.JoinDBUtil.deleteExpiredAndFinishedTriggers(JoinDBUtil.java:396)
      at com.wm.app.b2b.server.dispatcher.JoinManager$JoinManagerTimeoutThread.run(JoinManager.java:200)
      at com.wm.util.pool.PooledThread.run(PooledThread.java:118)
      at java.lang.Thread.run(Thread.java:595)

      Attachments

        Activity

          People

            Unassigned Unassigned
            vinay244 vinay shukl
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: