[
https://issues.apache.org/jira/browse/DERBY-4511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799122#action_12799122
]
Knut Anders Hatlen commented on DERBY-4511:
-------------------------------------------
The stack trace in the last comment may be from a SELECT ... FOR UPDATE
statement, but the stack trace in the bug description looks like a DELETE
statement. It is true that this error should be raised if SELECT or DELETE is
executed from within a function/procedure declared with NO SQL, but there's no
sign of a function/procedure invocation in the stack traces, so it looks like a
Derby bug to me.
Which version of Derby are you using?
The issue is flagged as a regression. Does this mean that it used to work with
older versions of Derby? If so, which Derby versions have this problem, and
which versions don't?
> Error while Retrieving view data from database
> --------------------------------------------------
>
> Key: DERBY-4511
> URL: https://issues.apache.org/jira/browse/DERBY-4511
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Reporter: vinay shukl
>
> 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)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
