[ 
https://issues.apache.org/jira/browse/DERBY-5497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rick Hillegas updated DERBY-5497:
---------------------------------

    Attachment: BinaryArgSimple.java

Attaching BinaryArgSimple.java. Compile this class with source and target = 
"1.4". If you run the class on Java 6, you see this result:

call returnBytesProc( ? ) = [ 0, 2, 4, 6 ]

When I run this on Oracle Java Embedded Client, I see the following stack trace:

java.sql.SQLException: No method was found that matched the method call 
BinaryArg.returnBytesProc(byte[][]), tried all combinations of object and 
primitive types and any possible type conversion for any  parameters the method 
call may have. The method might exist but it is not public and/or static, or 
the parameter types are not method invocation convertible.
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:256)
        at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424)
        at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
        at 
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2290)
        at 
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:82)
        at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:153)
        at 
org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(EmbedCallableStatement.java:70)
        at 
org.apache.derby.impl.jdbc.EmbedCallableStatement169.<init>(EmbedCallableStatement169.java:45)
        at 
org.apache.derby.jdbc.Driver169.newEmbedCallableStatement(Driver169.java:123)
        at 
org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(EmbedConnection.java:1707)
        at 
org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(EmbedConnection.java:1656)
        at BinaryArgSimple.main(BinaryArgSimple.java:28)
        at sun.misc.CVM.runMain(CVM.java:555)
Caused by: ERROR 42X50: No method was found that matched the method call 
BinaryArg.returnBytesProc(byte[][]), tried all combinations of object and 
primitive types and any possible type conversion for any  parameters the method 
call may have. The method might exist but it is not public and/or static, or 
the parameter types are not method invocation convertible.
        at 
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:335)
        at 
org.apache.derby.impl.sql.compile.MethodCallNode.throwNoMethodFound(MethodCallNode.java:385)
        at 
org.apache.derby.impl.sql.compile.MethodCallNode.resolveMethodCall(MethodCallNode.java:736)
        at 
org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(StaticMethodCallNode.java:263)
        at 
org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaToSQLValueNode.java:237)
        at 
org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(CallStatementNode.java:126)
        at 
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:373)
        at 
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:97)
        at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:1103)
        at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:134)
        ... 7 more
                
> Derby cannot resolve BINARY output procedure parameters on CDC/FP 1.1
> ---------------------------------------------------------------------
>
>                 Key: DERBY-5497
>                 URL: https://issues.apache.org/jira/browse/DERBY-5497
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.9.0.0
>            Reporter: Rick Hillegas
>         Attachments: BinaryArgSimple.java
>
>
> I will attach a repro showing this problem.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to