btw. does the spec say about the conversion rules for this ?
/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: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] 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 = "compositekey",
>> query = "select name, model, speed, lname as lastn, fname as
>> firstn, length, width, length * width as surface, length * width *10 as
>> volume from SpaceShip",
>> resultSetMapping = "compositekey")
>> }
>>
>>
>> @SqlResultSetMapping(name = "compositekey",
>> entities = @EntityResult(entityClass =
>> org.hibernate.test.annotations.query.SpaceShip.class,
>> fields = {
>> @FieldResult(name = "name", column = "name"),
>> @FieldResult(name = "model", column = "model"),
>> @FieldResult(name = "speed", column = "speed"),
>> @FieldResult(name = "dimensions.width", column =
>> "width"),
>> @FieldResult(name = "captain.lastname", column =
>> "lastn"),
>> @FieldResult(name = "dimensions.length", column =
>> "length"),
>> @FieldResult(name = "captain.firstname", column =
>> "firstn")
>> }),
>> columns = [EMAIL PROTECTED](name = "surface"),
>> @ColumnResult(name = "volume")})
>>
>>
>>
>> _______________________________________________
>> hibernate-devel mailing list
>> hibernate-devel@lists.sourceforge.net
>> 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
> in
> the hosting industry. Fanatical Support. Click to learn more
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
> _______________________________________________
> hibernate-devel mailing list
> hibernate-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
--
--
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
[EMAIL PROTECTED]
http://hibernate.org
JBoss Inc
[EMAIL PROTECTED]
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=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
