You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by "Michelle Caisse (JIRA)" <ji...@apache.org> on 2005/10/10 22:58:48 UTC

[jira] Created: (JDO-182) SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.

SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
-----------------------------------------------------------------------------------------------------------

         Key: JDO-182
         URL: http://issues.apache.org/jira/browse/JDO-182
     Project: JDO
        Type: Bug
    Reporter: Michelle Caisse
 Assigned to: Erik Bengtson 


Affects tests TestSetCollections and TestHashSetCollections

   [java] ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
   [java]      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.LikeEscapeOperatorNode.bindExpression(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
   [java]      at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
   [java]      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
   [java]      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
   [java]      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
   [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
   [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
   [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
   [java]      at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
   [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
   [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
   [java]      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
   [java]      at org.jpox.store.rdbms.scostore.AbstractCollectionStore.contains(AbstractCollectionStore.java:271)
   [java]      at org.jpox.store.rdbms.scostore.AbstractSetStore.remove(AbstractSetStore.java:386)
   [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:459)
   [java]      at org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:291)
   [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
   [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1893)
   [java]      at org.jpox.store.StoreManager.update(StoreManager.java:781)
   [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4338)
   [java]      at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3057)
   [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:436)
   [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.runTest(TestHashSetCollections.java:106)
   [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.test(TestHashSetCollections.java:73)
   [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:204)
   [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:120)
   [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:95)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Reopened: (JDO-182) SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.

Posted by "Michael Bouschen (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JDO-182?page=all ]
     
Michael Bouschen reopened JDO-182:
----------------------------------


> SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
> -----------------------------------------------------------------------------------------------------------
>
>          Key: JDO-182
>          URL: http://issues.apache.org/jira/browse/JDO-182
>      Project: JDO
>         Type: Bug

>   Components: tck20
>     Reporter: Michelle Caisse
>     Assignee: AJSoft

>
> Affects tests TestSetCollections and TestHashSetCollections
>    [java] ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
>    [java]      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.LikeEscapeOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
>    [java]      at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractCollectionStore.contains(AbstractCollectionStore.java:271)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractSetStore.remove(AbstractSetStore.java:386)
>    [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:459)
>    [java]      at org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:291)
>    [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
>    [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1893)
>    [java]      at org.jpox.store.StoreManager.update(StoreManager.java:781)
>    [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4338)
>    [java]      at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3057)
>    [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:436)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.runTest(TestHashSetCollections.java:106)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.test(TestHashSetCollections.java:73)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>    [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>    [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:204)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:120)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:95)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Closed: (JDO-182) SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.

Posted by "Michelle Caisse (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JDO-182?page=all ]
     
Michelle Caisse closed JDO-182:
-------------------------------


> SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
> -----------------------------------------------------------------------------------------------------------
>
>          Key: JDO-182
>          URL: http://issues.apache.org/jira/browse/JDO-182
>      Project: JDO
>         Type: Bug
>   Components: tck20
>     Reporter: Michelle Caisse
>     Assignee: Andy Jefferson

>
> Affects tests TestSetCollections and TestHashSetCollections
>    [java] ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
>    [java]      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.LikeEscapeOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
>    [java]      at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractCollectionStore.contains(AbstractCollectionStore.java:271)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractSetStore.remove(AbstractSetStore.java:386)
>    [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:459)
>    [java]      at org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:291)
>    [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
>    [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1893)
>    [java]      at org.jpox.store.StoreManager.update(StoreManager.java:781)
>    [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4338)
>    [java]      at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3057)
>    [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:436)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.runTest(TestHashSetCollections.java:106)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.test(TestHashSetCollections.java:73)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>    [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>    [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:204)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:120)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:95)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (JDO-182) SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.

Posted by "Michelle Caisse (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JDO-182?page=all ]

Michelle Caisse updated JDO-182:
--------------------------------

    Component: tck20

> SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
> -----------------------------------------------------------------------------------------------------------
>
>          Key: JDO-182
>          URL: http://issues.apache.org/jira/browse/JDO-182
>      Project: JDO
>         Type: Bug
>   Components: tck20
>     Reporter: Michelle Caisse
>     Assignee: Erik Bengtson

>
> Affects tests TestSetCollections and TestHashSetCollections
>    [java] ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
>    [java]      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.LikeEscapeOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
>    [java]      at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractCollectionStore.contains(AbstractCollectionStore.java:271)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractSetStore.remove(AbstractSetStore.java:386)
>    [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:459)
>    [java]      at org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:291)
>    [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
>    [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1893)
>    [java]      at org.jpox.store.StoreManager.update(StoreManager.java:781)
>    [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4338)
>    [java]      at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3057)
>    [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:436)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.runTest(TestHashSetCollections.java:106)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.test(TestHashSetCollections.java:73)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>    [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>    [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:204)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:120)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:95)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Closed: (JDO-182) SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.

Posted by "Michael Bouschen (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JDO-182?page=all ]
     
Michael Bouschen closed JDO-182:
--------------------------------

    Fix Version: JDO 2 beta
     Resolution: Fixed

> SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
> -----------------------------------------------------------------------------------------------------------
>
>          Key: JDO-182
>          URL: http://issues.apache.org/jira/browse/JDO-182
>      Project: JDO
>         Type: Bug

>   Components: tck20
>     Reporter: Michelle Caisse
>     Assignee: AJSoft
>      Fix For: JDO 2 beta

>
> Affects tests TestSetCollections and TestHashSetCollections
>    [java] ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
>    [java]      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.LikeEscapeOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
>    [java]      at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractCollectionStore.contains(AbstractCollectionStore.java:271)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractSetStore.remove(AbstractSetStore.java:386)
>    [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:459)
>    [java]      at org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:291)
>    [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
>    [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1893)
>    [java]      at org.jpox.store.StoreManager.update(StoreManager.java:781)
>    [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4338)
>    [java]      at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3057)
>    [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:436)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.runTest(TestHashSetCollections.java:106)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.test(TestHashSetCollections.java:73)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>    [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>    [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:204)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:120)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:95)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Resolved: (JDO-182) SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.

Posted by "Andy Jefferson (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JDO-182?page=all ]
     
Andy Jefferson resolved JDO-182:
--------------------------------

    Resolution: Fixed
     Assign To: Andy Jefferson  (was: Erik Bengtson)

TestSetCollections and TestHashSetCollections both now pass with JPOX CVS.

> SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
> -----------------------------------------------------------------------------------------------------------
>
>          Key: JDO-182
>          URL: http://issues.apache.org/jira/browse/JDO-182
>      Project: JDO
>         Type: Bug
>   Components: tck20
>     Reporter: Michelle Caisse
>     Assignee: Andy Jefferson

>
> Affects tests TestSetCollections and TestHashSetCollections
>    [java] ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
>    [java]      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.LikeEscapeOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>    [java]      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
>    [java]      at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>    [java]      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractCollectionStore.contains(AbstractCollectionStore.java:271)
>    [java]      at org.jpox.store.rdbms.scostore.AbstractSetStore.remove(AbstractSetStore.java:386)
>    [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:459)
>    [java]      at org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:291)
>    [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
>    [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1893)
>    [java]      at org.jpox.store.StoreManager.update(StoreManager.java:781)
>    [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4338)
>    [java]      at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:3057)
>    [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:436)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.runTest(TestHashSetCollections.java:106)
>    [java]      at org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections.test(TestHashSetCollections.java:73)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>    [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>    [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:204)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:120)
>    [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:95)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira