[
https://issues.apache.org/jira/browse/DERBY-4511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12801727#action_12801727
]
Knut Anders Hatlen commented on DERBY-4511:
-------------------------------------------
Hi Vinay,
The latest version of Derby is currently 10.5.3.0. It would be great if you
could try that version and see if you get the same problems there. It would
also be great if you could enable more logging by setting the following
properties
derby.stream.error.logSeverityLevel=0
derby.language.logStatementText=true
and attach the contents of derby.log when you see the error.
> 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
> Affects Versions: 10.2.2.0
> 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.
