db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4511) Error while Retrieving view data from database
Date Fri, 15 Jan 2010 12:17:54 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12800677#action_12800677

Knut Anders Hatlen commented on DERBY-4511:

Thanks for the update, Vinay.

I'm afraid it might be difficult for others to reproduce this. Since you're the only one who
knows exactly what kind of queries that are executed against your database, you're probably
in a better position to find out how to reproduce it. Although it's not required to have a
reproducible test case, having one will greatly increase the chances of getting the bug fixed.

Also, could you please clarify exactly which version of Derby you are seeing this on? I see
one comment stating, and one stating "latest". By "latest", do you mean

> 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:
>            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
> at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source)
> at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteCascadeResultSet(Unknown
> at org.apache.derby.exe.aceeb848bfx0125xd416xdf4ex00000e7f746f8c.fillResultSet(Unknown
> 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.

View raw message