Re[2]: [Hibernate-devel] 0.9.6

[Doug C. <de...@fl...>]

I just sync'd with cvs ran FooBarTest and got the same problem...

Flushing 0 insertions, 1 updates, 0 deletions to 2 objects and updating 6 collections....
from foo in class cirrus.hibernate.test.Foo where foo.string='from BoogieDown  -tinsel town  =!@#$^&*())'
SELECT foo.foo_id, foo.class, foo.foo, foo.long_, foo.integer_, foo.float_, foo.double_, foo.bytes, foo.date_, foo.timestamp_, foo.boolean_, foo.bool_, foo.null_, foo.short_, foo.zero_, foo.int_, foo.string_, foo.byte_, foo.yesno, foo.blobb_, foo.nullBlob, foo.status_, foo.bin_, foo.first_name, foo.surname, foo.count_, foo.name_, foo.subcount, foo.subname, foo.the_time, foo.baz, foo.bar_string, foo.bar_count, foo.name, foo.importantDates FROM foos foo WHERE 1=1 AND ( ( foo.string_='from BoogieDown  -tinsel town  =!@#$^&*())' ) )
Flushing 2 insertions, 1 updates, 0 deletions to 4 objects and updating 30 collections....
 from bar in class cirrus.hibernate.test.Bar where bar.baz.count=667
SELECT DISTINCT baz1.idcode as idcode0, bar.foo_id as foo_id1, baz1.count_count as count_count0, baz1.name_b as name_b0, baz1.stringSet as stringSet0, baz1.stringDateMap as stringDateMap0, baz1.fooArray as fooArray0, baz1.stringArray as stringArray0, baz1.setArray as setArray0, baz1.stringArrayMap as stringArrayMap0, baz1.setList as setList0, baz1.customs as customs0, bar.class as class1, bar.baz as baz1, bar.bar_string as bar_string1, bar.bar_count as bar_count1, bar.name as name1, bar.importantDates as importantDates1, bar.the_time as the_time1, bar.foo as foo1, bar.long_ as long_1, bar.integer_ as integer_1, bar.float_ as float_1, bar.double_ as double_1, bar.bytes as bytes1, bar.date_ as date_1, bar.timestamp_ as timestamp_1, bar.boolean_ as boolean_1, bar.bool_ as bool_1, bar.null_ as null_1, bar.short_ as short_1, bar.zero_ as zero_1, bar.int_ as int_1, bar.string_ as string_1, bar.byte_ as byte_1, bar.yesno as yesno1, bar.blobb_ as blobb_1, bar.nullBlob as nullBlob1, bar.status_ as status_1, bar.bin_ as bin_1, bar.first_name as first_name1, bar.surname as surname1, bar.count_ as count_1, bar.name_ as name_1, bar.subcount as subcount1, bar.subname as subname1 FROM Baz baz1, foos bar WHERE 1=1 and bar.class in ('cirrus.hibernate.test.Bar')  AND ( ( baz1.count_count=667  and bar.baz = baz1.idcode ) )
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at cirrus.hibernate.test.TestCase.run(TestCase.java:46)
        at cirrus.hibernate.test.FooBarTest.main(FooBarTest.java:1006)
Caused by: com.mckoi.database.jdbc.MSQLException: Can not order by field type VARBINARY in 'bin_'
        at com.mckoi.database.jdbcserver.LocalDatabaseInterface.exec(LocalDatabaseInterface.java:194)
        at com.mckoi.database.jdbcserver.LocalDatabaseInterface.execQuery(LocalDatabaseInterface.java:229)
        at com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:265)
        at com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:110)
        at com.mckoi.database.jdbc.MPreparedStatement.executeQuery(com/mckoi/database/jdbc/MPreparedStatement.java:72)
        at cirrus.hibernate.impl.RelationalDatabaseSession.find(RelationalDatabaseSession.java:728)
        at cirrus.hibernate.impl.RelationalDatabaseSession.find(RelationalDatabaseSession.java:677)
        at cirrus.hibernate.impl.RelationalDatabaseSession.find(RelationalDatabaseSession.java:601)
        at cirrus.hibernate.test.FooBarTest.testQuery(FooBarTest.java:345)
        ... 6 more

It's also odd that the order of the columns in the select is
different. Is this perhaps another jdk 1.4 versus ibm jvm 1.3 problem?

e

Monday, February 25, 2002, 2:52:24 AM, you wrote:
> Doug, I can't reproduce that result - what i get is:

> SELECT bar.foo_id as foo_id0, baz1.idcode as idcode1, bar.class as class0,
> bar.baz as baz0, bar.bar_string as bar_string0, bar.bar_count as
> bar_count0, bar.name as name0, bar.importantDates as importantDates0,
> bar.the_time as the_time0, bar.foo as foo0, bar.long_ as long_0,
> bar.integer_ as integer_0, bar.float_ as float_0, bar.double_ as double_0,
> bar.bytes as bytes0, bar.date_ as date_0, bar.timestamp_ as timestamp_0,
> bar.boolean_ as boolean_0, bar.bool_ as bool_0, bar.null_ as null_0,
> bar.short_ as short_0, bar.zero_ as zero_0, bar.int_ as int_0, bar.string_
> as string_0, bar.byte_ as byte_0, bar.yesno as yesno0, bar.blobb_ as
> blobb_0, bar.nullBlob as nullBlob0, bar.status_ as status_0, bar.bin_ as
> bin_0, bar.first_name as first_name0, bar.surname as surname0, bar.count_
> as count_0, bar.name_ as name_0, bar.subcount as subcount0, bar.subname as
> subname0, baz1.count_ as count_1, baz1.name_ as name_1, baz1.stringSet as
> stringSet1, baz1.stringDateMap as stringDateMap1, baz1.fooArray as
> fooArray1, baz1.stringArr
> ay as stringArray1, baz1.setArray as setArray1, baz1.stringArrayMap as
> stringArrayMap1, baz1.setList as setList1, baz1.customs as customs1
> FROM foos bar, Baz baz1
> WHERE 1=1 and bar.class in ('cirrus.hibernate.test.Bar')
> AND ( ( baz1.count_=667  and bar.baz = baz1.idcode ) )


> which still has one slight problem: we unnecessarily grab columns from Baz
> that we arent going to use. I will fix that.

> not sure why you are getting a distinct select....