You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2011/03/28 20:42:05 UTC
[jira] [Created] (DERBY-5159) ParameterMetaDataJdbc30Test fails
with "'PMDD' is not recognized as a function or procedure"
ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
--------------------------------------------------------------------------------------------
Key: DERBY-5159
URL: https://issues.apache.org/jira/browse/DERBY-5159
Project: Derby
Issue Type: Bug
Components: Test
Affects Versions: 10.8.0.0
Reporter: Knut Anders Hatlen
Seen in nightly testing on Java 7:
http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 47 more
Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 41 more
Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (DERBY-5159) ParameterMetaDataJdbc30Test fails
with "'PMDD' is not recognized as a function or procedure"
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen resolved DERBY-5159.
---------------------------------------
Resolution: Fixed
Issue & fix info: (was: [Patch Available])
Committed revision 1086559.
> ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-5159
> URL: https://issues.apache.org/jira/browse/DERBY-5159
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.8.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: derby-5159-1a.diff, derby-5159-1b.diff
>
>
> Seen in nightly testing on Java 7:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
> 1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 47 more
> Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> ... 41 more
> Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Reopened] (DERBY-5159) ParameterMetaDataJdbc30Test fails
with "'PMDD' is not recognized as a function or procedure"
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden reopened DERBY-5159:
-----------------------------------
> ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-5159
> URL: https://issues.apache.org/jira/browse/DERBY-5159
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.8.1.2
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.8.1.2
>
> Attachments: derby-5159-1a.diff, derby-5159-1b.diff
>
>
> Seen in nightly testing on Java 7:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
> 1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 47 more
> Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> ... 41 more
> Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5159) ParameterMetaDataJdbc30Test fails
with "'PMDD' is not recognized as a function or procedure"
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-5159:
--------------------------------------
Issue & fix info: [Patch Available]
Assignee: Knut Anders Hatlen
> ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-5159
> URL: https://issues.apache.org/jira/browse/DERBY-5159
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.8.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: derby-5159-1a.diff
>
>
> Seen in nightly testing on Java 7:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
> 1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 47 more
> Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> ... 41 more
> Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5159) ParameterMetaDataJdbc30Test fails
with "'PMDD' is not recognized as a function or procedure"
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-5159:
--------------------------------------
Attachment: derby-5159-1a.diff
Attaching a patch that makes both test cases create PMDD first and drop it when completed. This way they should work regardless of the order in which they run.
> ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-5159
> URL: https://issues.apache.org/jira/browse/DERBY-5159
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.8.0.0
> Reporter: Knut Anders Hatlen
> Attachments: derby-5159-1a.diff
>
>
> Seen in nightly testing on Java 7:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
> 1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 47 more
> Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> ... 41 more
> Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (DERBY-5159) ParameterMetaDataJdbc30Test fails with
"'PMDD' is not recognized as a function or procedure"
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden closed DERBY-5159.
---------------------------------
Resolution: Fixed
Fix Version/s: 10.8.1.2
> ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-5159
> URL: https://issues.apache.org/jira/browse/DERBY-5159
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.8.1.2
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.8.1.2
>
> Attachments: derby-5159-1a.diff, derby-5159-1b.diff
>
>
> Seen in nightly testing on Java 7:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
> 1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 47 more
> Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> ... 41 more
> Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5159) ParameterMetaDataJdbc30Test fails
with "'PMDD' is not recognized as a function or procedure"
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13012276#comment-13012276 ]
Dag H. Wanvik commented on DERBY-5159:
--------------------------------------
Patch looks right to me. +1. Factoring out the common string might make it even better. That would get rid of the way too long line in the first CREATE as well.
> ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-5159
> URL: https://issues.apache.org/jira/browse/DERBY-5159
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.8.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: derby-5159-1a.diff
>
>
> Seen in nightly testing on Java 7:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
> 1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 47 more
> Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> ... 41 more
> Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5159) ParameterMetaDataJdbc30Test fails
with "'PMDD' is not recognized as a function or procedure"
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-5159:
--------------------------------------
Attachment: derby-5159-1b.diff
Thanks, Dag! Here's an updated patch that moves the creation of the procedure to decorateSQL() in the CleanDatabaseTestSetup that decorates the test, so that we only need the procedure definition once.
> ParameterMetaDataJdbc30Test fails with "'PMDD' is not recognized as a function or procedure"
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-5159
> URL: https://issues.apache.org/jira/browse/DERBY-5159
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.8.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: derby-5159-1a.diff, derby-5159-1b.diff
>
>
> Seen in nightly testing on Java 7:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/sol32/1085472-suitesAll_diff.txt
> 1) testParameterMetadataWithLITERALParameters(org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test)java.sql.SQLSyntaxErrorException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
> at org.apache.derbyTesting.junit.BaseJDBCTestCase.prepareCall(BaseJDBCTestCase.java:317)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ParameterMetaDataJdbc30Test.testParameterMetadataWithLITERALParameters(ParameterMetaDataJdbc30Test.java:743)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 47 more
> Caused by: ERROR 42Y03: 'PMDD' is not recognized as a function or procedure.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> ... 41 more
> Looks like a problem with the ordering of the test cases. testParameterMetadataWithDECIMALParameters() creates the procedure PMDD, and testParameterMetadataWithLITERALParameters() calls it and drops it. If the test cases run in the opposite order, testParameterMetadataWithLITERALParameters() cannot find the procedure and fails.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira