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
