Marcus Christie created AIRAVATA-2276:
-----------------------------------------
Summary: SQL escaping error in sharing registry: An error occurred
while parsing the query filter
Key: AIRAVATA-2276
URL: https://issues.apache.org/jira/browse/AIRAVATA-2276
Project: Airavata
Issue Type: Bug
Reporter: Marcus Christie
Assignee: Supun Chathuranga Nakandala
I get the following error when I try to create an experiment with name
{{~!@#$%^&*()_+?><,./;'}}.
{noformat}
2016-12-14 11:08:55 [pool-7-thread-49] ERROR o.a.a.a.s.h.AiravataServerHandler
- Error in sharing res
ource with users. Resource ID :
~!@#$%^&*()_+?><,_/;'":_dad1b5f5-025f-452d-9bf0-712277ca36e7 Resource
Type : EXPERIMENT
org.apache.openjpa.persistence.ArgumentException: An error occurred while
parsing the query filter 'S
ELECT p from EntityEntity as p WHERE p.parentEntityId =
'~!@#$%^&*()_+?><,_/;'":_dad1b5f5-025f-452d-9bf0-712277ca36e7' ORDER BY
p.originalEntityCreationTime DESC'. Error message:
org.apache.openjpa.kernel.jpql.TokenMgrError: Lexical error at line 1, column
163. Encountered: <EOF> after : "\":_dad1b5f5-025f-452d-9bf0-712277ca36e7\'
ORDER BY p.originalEntityCreationTime DESC"
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:2405)
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:2388)
at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:49)
at
org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:154)
at
org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:672)
at
org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654)
at
org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)
at
org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)
at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)
at
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:997)
at
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:979)
at
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:102)
at
org.apache.airavata.sharing.registry.db.repositories.AbstractRepository.lambda$select$3(AbstractRepository.java:106)
at
org.apache.airavata.sharing.registry.db.utils.JPAUtils.execute(JPAUtils.java:108)
at
org.apache.airavata.sharing.registry.db.repositories.AbstractRepository.select(AbstractRepository.java:106)
at
org.apache.airavata.sharing.registry.db.repositories.EntityRepository.getChildEntities(EntityRepository.java:48)
at
org.apache.airavata.sharing.registry.server.SharingRegistryServerHandler.shareEntity(SharingRegistryServerHandler.java:780)
at
org.apache.airavata.sharing.registry.server.SharingRegistryServerHandler.shareEntityWithUsers(SharingRegistryServerHandler.java:735)
at
org.apache.airavata.api.server.handler.AiravataServerHandler.shareResourceWithUsers(AiravataServerHandler.java:3917)
at
org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$354caf4d.CGLIB$shareResourceWithUsers$156(<generated>)
at
org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$354caf4d$$FastClassByGuice$$5912d722.invoke(<generated>)
at
com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
at
org.apache.airavata.api.server.security.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:57)
...
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
