db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4511) Error while Retrieving view data from database
Date Mon, 11 Jan 2010 13:48:54 GMT

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


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