Return-Path: X-Original-To: apmail-openjpa-dev-archive@www.apache.org Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9A1A210996 for ; Mon, 31 Mar 2014 13:00:26 +0000 (UTC) Received: (qmail 12064 invoked by uid 500); 31 Mar 2014 13:00:25 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 11684 invoked by uid 500); 31 Mar 2014 13:00:21 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 11541 invoked by uid 99); 31 Mar 2014 13:00:17 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Mar 2014 13:00:17 +0000 Date: Mon, 31 Mar 2014 13:00:17 +0000 (UTC) From: "Oliver Gierke (JIRA)" To: dev@openjpa.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (OPENJPA-2484) JPA-QL query with byte[] projection fails. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/OPENJPA-2484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13955151#comment-13955151 ] Oliver Gierke commented on OPENJPA-2484: ---------------------------------------- I think the spec is pretty clear on what is a collection-valued persistent field. In section 2.2 it explicitly restricts those to only property of type {{Collection}}, {{List}}, {{Set}} and {{Map}}. So everything but that is to be considered a single-value property. > JPA-QL query with byte[] projection fails. > ------------------------------------------ > > Key: OPENJPA-2484 > URL: https://issues.apache.org/jira/browse/OPENJPA-2484 > Project: OpenJPA > Issue Type: Bug > Components: jpa > Affects Versions: 2.2.2 > Reporter: Thomas Darimont > > Given a User entity with a persistent byte[] field declared as: > @Lob private byte[] binaryData; > When executing the following JPA query: > select u.binaryData from User u where u.id = :id > {code:java} > User user = new User(); > user.setBinaryData("TEST".getBytes()); > em.persist(user); > Object result = em.createQuery("select u.binaryData from User u where u.id = :id").setParameter("id", user.getId()) > .getSingleResult(); > assertThat(result,is(notNullValue())); > {code} > The following exception is thrown: > {code} > org.apache.openjpa.persistence.ArgumentException: Query projections cannot include array, collection, or map fields. Invalid query: "select u.binaryData from User u where u.id = :id" > at org.apache.openjpa.kernel.ExpressionStoreQuery$AbstractExpressionExecutor.assertNotContainer(ExpressionStoreQuery.java:328) > at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.(ExpressionStoreQuery.java:770) > at org.apache.openjpa.kernel.ExpressionStoreQuery.newDataStoreExecutor(ExpressionStoreQuery.java:179) > at org.apache.openjpa.kernel.QueryImpl.createExecutor(QueryImpl.java:749) > at org.apache.openjpa.kernel.QueryImpl.compileForDataStore(QueryImpl.java:707) > at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:689) > 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.example.domain.OpenJpaPlainJpaTests.foo(OpenJpaPlainJpaTests.java:301) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) > at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) > at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) > at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) > at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) > at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) > at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) > at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) > at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) > at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) > at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) > at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) > at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) > at org.junit.runners.ParentRunner.run(ParentRunner.java:309) > at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) > at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) > at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) > {code} > Other JPA implementations like Hibernate or EclipseLink support this. -- This message was sent by Atlassian JIRA (v6.2#6252)