[
https://issues.apache.org/jira/browse/AIRAVATA-2276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15752036#comment-15752036
]
ASF subversion and git services commented on AIRAVATA-2276:
-----------------------------------------------------------
Commit c0779c077240dd63a0167eea73ef301cf80b6ba7 in airavata's branch
refs/heads/develop from scnakandala
[ https://git-wip-us.apache.org/repos/asf?p=airavata.git;h=c0779c0 ]
fixing AIRAVATA-2276 SQL escaping error in sharing registry: An error occurred
while parsing the query filter
> 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)
