openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Craig Taylor <ctalk...@ctalkobt.net>
Subject Re: named-native-query with sql-result-set-mapping
Date Thu, 08 Mar 2018 12:46:16 GMT
Try using longs instead of integer.  If you grab the result set without
conversion you should be able to iterate through the list to see what is
being returned.

On Mar 8, 2018 07:38, "Matthew Broadhead" <matthew.broadhead@nbmlaw.co.uk>
wrote:

> hi i am trying to do a NamedNativeQuery with a SqlResultSetMapping and i
> get javax.el.ELException: java.lang.ClassCastException: [Ljava.lang.Object;
> cannot be cast to uk.me.kissy.file.entities.categoryYear.CategoryYearResult.
> is this type of operation not supported?
> my orm.xml is
> <?xml version="1.0" encoding="UTF-8"?>
> <entity-mappings version="2.1"
>     xmlns="http://xmlns.jcp.org/xml/ns/persistence/orm" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
>     xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence/orm
> http://xmlns.jcp.org/xml/ns/persistence/orm_2_1.xsd">
>     <entity class="uk.me.kissy.file.entities.jpa.File" name="File">
>         <named-native-query name="selectCategoryYear"
>             result-set-mapping="CategoryYearMapping">
>             <query><![CDATA[select year(completiondate) as year,
> categoryid, count(id) as count from conveyancing.file where completiondate
> is not null and categoryid is not null group by year, categoryid order by
> year;]]></query>
>         </named-native-query>
>         <sql-result-set-mapping name="CategoryYearMapping">
>             <constructor-result
> target-class="uk.me.kissy.file.entities.categoryYear.CategoryYearResult">
>                 <column name="year" class="java.lang.Integer" />
>                 <column name="categoryid" class="java.lang.Integer" />
>                 <column name="count" class="java.lang.Integer" />
>             </constructor-result>
>         </sql-result-set-mapping>
>     </entity>
> </entity-mappings>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message