Re: [Hibernate] New error on Annotation query

[Max R. A. <max...@jb...>]

This should be controlled by calls to Dialect.registerHibernateType() an=
d  =

whatever the underlying db returns.

This has not changed afaik.

/max

> The initial issue is fixed,
> But now I do have some weird type conversion using HSQLDB (didn't trie=
d
> the other ones).
>
> basically I do have
> public Dimension() {
>   private int length;
>   private int width;
> }
>
> ints are converted into INTEGER types at the DB level, fine
>
> The following native SQL query, mapped using scalar autodiscovery
> select length * width as surface, length * width * 10 as volume ...
>
> returns String for the first argument and Double for the second
> The same query used to return BigInteger for the first one and
> BigDecimal for the second.
>
>
>
> Steve Ebersole wrote:
>>
>> Try it again from SVN.
>>
>> -----Original Message-----
>> From: hib...@li...
>> [mailto:hib...@li...] On Behalf Of
>> Emmanuel Bernard
>> Sent: Sunday, June 18, 2006 10:21 PM
>> To: Hibernate development
>> Subject: [Hibernate] New error on Annotation query
>>
>> Has something changed that I haven't propagated in my code?
>>
>>
>> org.hibernate.HibernateException: cannot perform autodiscovery on
>> queries with non-scalar results
>>     at
>> org.hibernate.loader.custom.CustomLoader$NonScalarResultColumnProcess=
or.
>> performDiscovery(CustomLoader.java:453)
>>     at
>> org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoad=
er.
>> java:511)
>>     at org.hibernate.loader.Loader.getResultSet(Loader.java:1677)
>>     at org.hibernate.loader.Loader.doQuery(Loader.java:662)
>>     at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo=
ade
>> r.java:224)
>>     at org.hibernate.loader.Loader.doList(Loader.java:2144)
>>     at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
>>     at org.hibernate.loader.Loader.list(Loader.java:2023)
>>     at
>> org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:290)
>>     at
>> org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)=

>>     at
>> org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:=
142
>> )
>>     at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)
>>     at
>> org.hibernate.test.annotations.query.QueryTest.testNativeQueryAndComp=
osi
>> tePKAndComponents(QueryTest.java:195)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.=
jav
>> a:39)
>>     at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces=
sor
>> Impl.java:25)
>>     at org.hibernate.test.annotations.TestCase.runTest(TestCase.java:=
67)
>>     at
>> com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:=
32)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.=
jav
>> a:39)
>>     at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces=
sor
>> Impl.java:25)
>>     at
>> com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
>>
>>
>>
>> @NamedNativeQuery(name =3D "compositekey",
>>         query =3D "select name, model, speed, lname as lastn, fname a=
s
>> firstn, length, width, length * width as surface, length * width *10 =
as
>> volume from SpaceShip",
>>         resultSetMapping =3D "compositekey")
>>         }
>>
>>
>> @SqlResultSetMapping(name =3D "compositekey",
>>         entities =3D @EntityResult(entityClass =3D
>> org.hibernate.test.annotations.query.SpaceShip.class,
>>                 fields =3D {
>>                 @FieldResult(name =3D "name", column =3D "name"),
>>                 @FieldResult(name =3D "model", column =3D "model"),
>>                 @FieldResult(name =3D "speed", column =3D "speed"),
>>                 @FieldResult(name =3D "dimensions.width", column =3D
>> "width"),
>>                 @FieldResult(name =3D "captain.lastname", column =3D
>> "lastn"),
>>                 @FieldResult(name =3D "dimensions.length", column =3D=

>> "length"),
>>                 @FieldResult(name =3D "captain.firstname", column =3D=

>> "firstn")
>>                         }),
>>         columns =3D {@ColumnResult(name =3D "surface"),
>>         @ColumnResult(name =3D "volume")})
>>
>>
>>
>> _______________________________________________
>> hibernate-devel mailing list
>> hib...@li...
>> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>>
>
>
> All the advantages of Linux Managed Hosting--Without the Cost and Risk=
!
> Fully trained technicians. The highest number of Red Hat certification=
s  =

> in
> the hosting industry. Fanatical Support. Click to learn more
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D107521&bid=3D248729&da=
t=3D121642
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel



-- =

--
Max Rydahl Andersen
callto://max.rydahl.andersen

Hibernate
ma...@hi...
http://hibernate.org

JBoss Inc
max...@jb...