[ http://issues.apache.org/jira/browse/JDO-105?page=all ] Michael Bouschen reopened JDO-105: ----------------------------------
> No authorized routine named 'LIKE' of type 'FUNCTION' having compatible > arguments was found. > -------------------------------------------------------------------------------------------- > > Key: JDO-105 > URL: http://issues.apache.org/jira/browse/JDO-105 > Project: JDO > Type: Bug > Components: tck20 > Reporter: Michelle Caisse > Assignee: Michelle Caisse > > SQL Exception: No authorized routine named 'LIKE' of type 'FUNCTION' having > compatible arguments was found. > Affected tests: > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections > org.apache.jdo.tck.models.fieldtypes.TestHashSetCollections > org.apache.jdo.tck.models.fieldtypes.TestSetCollections > test(org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections)javax.jdo.JDODataStoreException: > Contains request failed : SELECT IDENTIFIER FROM > applicationidentity0.COLLECTION_OF_OBJECT0 WHERE IDENTIFIER = ? AND OBJREF > LIKE ? > at > org.jpox.store.rdbms.scostore.AbstractSetStore.contains(AbstractSetStore.java:357) > at > org.jpox.store.rdbms.scostore.NormalSetStore.add(NormalSetStore.java:578) > at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:458) > at > org.jpox.store.mapping.CollectionMapping.postUpdate(CollectionMapping.java:280) > at > org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266) > at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1810) > at org.jpox.store.StoreManager.update(StoreManager.java:710) > at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4069) > at > org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2917) > at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:431) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.runTest(TestCollectionCollections.java:97) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.test(TestCollectionCollections.java:69) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197) > at > org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128) > at > org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106) > NestedThrowablesStackTrace: > ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having > compatible arguments was found. > at > org.apache.derby.iapi.error.StandardException.newException(StandardException.java) > at > org.apache.derby.impl.sql.compile.LikeEscapeOperatorNode.bindExpression(LikeEscapeOperatorNode.java) > at > org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java) > at > org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(BinaryLogicalOperatorNode.java) > at > org.apache.derby.impl.sql.compile.AndNode.bindExpression(AndNode.java) > at > org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java) > at > org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java) > at > org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java) > at > org.apache.derby.impl.sql.compile.ReadCursorNode.bind(ReadCursorNode.java) > at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java) > at > org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java) > at > org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java) > at > org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java) > at > com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:303) > at > org.jpox.store.rdbms.scostore.AbstractSetStore.contains(AbstractSetStore.java:313) > at > org.jpox.store.rdbms.scostore.NormalSetStore.add(NormalSetStore.java:578) > at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:458) > at > org.jpox.store.mapping.CollectionMapping.postUpdate(CollectionMapping.java:280) > at > org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266) > at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1810) > at org.jpox.store.StoreManager.update(StoreManager.java:710) > at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4069) > at > org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2917) > at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:431) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.runTest(TestCollectionCollections.java:97) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.test(TestCollectionCollections.java:69) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197) > at > org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128) > at > org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106) -- 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
