Re: [Hibernate] New error on Annotation query

[Steve E. <ste...@jb...>]

I am creating a similar test in the core testsuite and see if I can
reproduce.

-----Original Message-----
From: Max Andersen=20
Sent: Wednesday, June 21, 2006 3:53 PM
To: Emmanuel Bernard; Steve Ebersole
Cc: Hibernate development
Subject: Re: [Hibernate] New error on Annotation query


This should be controlled by calls to Dialect.registerHibernateType()
and =20
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
tried
> 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$NonScalarResultColumnProcessor.
>> performDiscovery(CustomLoader.java:453)
>>     at
>>
org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.
>> 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(Loade
>> 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.testNativeQueryAndComposi
>> 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(DelegatingMethodAccessor
>> 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(DelegatingMethodAccessor
>> 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 =
as
>> 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
certifications =20
> in
> the hosting industry. Fanatical Support. Click to learn more
>
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D107521&bid=3D248729&dat=3D=
121642
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel



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

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

JBoss Inc
max...@jb...