Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
10.2.2.0
-
None
-
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)