Menu
▾
▴
Re: [Hibernate] New error on Annotation query
|
From: Steve E. <ste...@jb...> - 2006-06-21 21:11:00
|
I just ran this on Oracle-10g and HSQLDB and both worked fine for me.
On Oracle, the discovered types were BigDecimalType and BigDecimalType.
On HSQLDB, the discovered types were BigIntegerType and BigDecimalType
-----Original Message-----
From: hib...@li...
[mailto:hib...@li...] On Behalf Of
Steve Ebersole
Sent: Wednesday, June 21, 2006 3:55 PM
To: Max Andersen; Emmanuel Bernard
Cc: Hibernate development
Subject: Re: [Hibernate] New error on Annotation query
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...
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications
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
|
