jpa java.sql. sql语法错误异常：未找到具有兼容参数的名为“LIKE”、类型为“FUNCTION”的授权例程

cmssoen2 于 2023-01-21 发布在 Java

关注(0)|答案(5)|浏览(153)

我尝试在数据库中搜索一个int（通常是id号），然后将关于这个id号的所有细节返回给用户。

public List<Userdetails> searchByInt(int parseInt) {
    Query q = em.createQuery("SELECT u FROM Userdetails u WHERE u.id LIKE :pattern");
    q.setParameter("pattern", parseInt);
    return q.getResultList();
}

但是，它抛出了以下异常：

WARNING:   Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments was found.
Error Code: -1
Call: SELECT ID, USERNAME FROM USERDETAILS WHERE ID LIKE ?
    bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=Userdetails sql="SELECT ID, USERNAME FROM USERDETAILS WHERE ID LIKE ?")
    at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:679)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
    at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1995)
    at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
    at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2714)
    at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2667)
    at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:477)
    at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1155)
    at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
    at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1114)
    at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:402)
    at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1202)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2894)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1797)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1779)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1744)
    at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
    at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:468)
    at Richard.beans.UserdetailsFacade.searchByInt(UserdetailsFacade.java:44)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
    at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
    at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4695)
    at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:630)
    at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
    at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:582)
    at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
    at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
    at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
    at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:582)

这是如何造成的，我如何解决它？

jpa

来源：https://stackoverflow.com/questions/20146512/java-sql-sqlsyntaxerrorexception-no-authorized-routine-named-like-of-type-fu

5条答案

按热度按时间

e0bqpujr1#

LIKE predicate 似乎是作为数据库引擎中的一个函数实现的，它通常应用于字符操作数，而您似乎试图将它用于整数。您的数据库试图找到接受整数参数的LIKE函数，但它不在那里。

赞(0）回复(0）举报 2023-01-21

d5vmydt92#

predicate LIKE用于检查文本是否对应于模式。
要检查是否相等，只需使用=。

SELECT u FROM Userdetails u WHERE u.id = :pattern

赞(0）回复(0）举报 2023-01-21

okxuctiv3#

我认为将LIKE与ID一起使用没有意义（如果ID是NUMBER（Oracle）或INTEGER（SQL '99））。请尝试使用equasion（=）。
SELECT .... WHERE id = :pattern

赞(0）回复(0）举报 2023-01-21

1l5u6lss4#

试试这个：

LIKE VARCHAR('%'||USER.NAME||'%')

取代：

LIKE '%'||USER.NAME||'%'

赞(0）回复(0）举报 2023-01-21

h7wcgrx35#

在我的例子中，我使用了Derby数据库并尝试使用TIMESTAMP列。因此，在使用LIKE之前，需要将其转换为CHAR。

SELECT * FROM table WHERE CAST(column AS CHAR(28)) LIKE '%2023-01-17%';

赞(0）回复(0）举报 2023-01-21

我来回答

jpa java.sql. sql语法错误异常：未找到具有兼容参数的名为“LIKE”、类型为“FUNCTION”的授权例程

5条答案

相关问题

热门标签

最新问答