[jira] Commented: (DERBY-4511) Error while Retrieving view data from database

["Rick Hillegas (JIRA)" <ji...@apache.org>]

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

Rick Hillegas commented on DERBY-4511:
--------------------------------------

Hi Vinay,

Could you include a test case which shows this problem? The error you are seeing is raised by Derby if you declare that a function/procedure does not issue SQL but it actually does issue SQL when executed. Examine your CREATE FUNCTION or CREATE PROCEDURE statement to make sure that it does not include the NO SQL clause. If the CREATE FUNCTION/PROCEDURE statement does include that clause, then replace the clause with CONTAINS SQL or READS SQL DATA or MODIFIES SQL DATA, depending on what your function/procedure actually does. The meaning of these clauses can be found in the Reference Guide sections on the CREATE FUNCTION and CREATE PROCEDURE statements.

Thanks,
-Rick

> 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.