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

• Key: JDO-182
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: AJSoft
• Reporter: Michelle Caisse
• Component/s: tck2
• Fix Version/s: JDO 2 beta

Description

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)

Comments

TestSetCollections and TestHashSetCollections both now pass with JPOX CVS.

[Michael Bouschen]

Reopened to set the Fix Version/s field to JDO 2 beta.