Saturday, 12 May 2007

Hibernate bug in subqueries

Mikey logged this bug on Hibernate query generation. We've ended up writing a fair amount of native SQL for Meldware to deal with various limitations in Hibernate and/or MySQL or the sticky goo between them (generally Oracle is fine and frankly PostgreSQL is the most capable, easiest to work with database we test on). This latest bug affects when you have two subqueries and is a straight hibernate bug. If I say "delete from Foo as foo where foo.pid not in (select id from Bar) and foo.pid not in (select id from Goo)"... Hibernate generates something like "delete from FOO where pid not in (select id from BAR) and _foo0.pid not in (select id from GOO)" basically failing to declare its own alias _foo0 and thus erroring at least postgresql. This follows on a more serious Hibernate bug (really JavaAssist) which fortunately did not affect us. Hope the 2609 bug gets fixed soon as Mikey doesn't like it when he's writing native SQL instead of HQL.

Anyhow, M8 is coming soon... I realize it is very late, but it has a lot in it that we hadn't planned on but would have been silly not to do. Clustered IMAP IDLE notifications and nicely working WCAP + freebusy isn't bad for a month and some change huh? I'll have an announcement on Monday as well as some pictures of our official Bunisoft model for LinuxFest Northwest, Francesca...so stay tuned for that. I can't wait to blab on what I'm working on for M9...but I'll save that for even later ;-). I have to say as 1.0 approaches its hard not to start writing 2.0 in the middle of each milestone...but I resist.

Technorati Tags:

Posted by acoliver at 11:51 PM in Buni.org
Responses (3)

Ode to Intel graphics or my downgrade from my MacBookPro

I just bought a relatively inexpensive Gateway 4026 Celeron M laptop from Tom Billman of TriLUG. Tom has a Giant Shoulder and gave a good talk on video editing etc at the last TriLUG meeting using this very laptop and my operating system of choice (Feisty Fawn). He even had the projector working, which is more than I can say for my MacBook Pro. After dealing with the ATI double-suck drivers, I'm now a believer in Intel baby. They actually have open source drivers for their graphics stuff and they support the open source drivers. ATI/AMD think they have some sort of special trade secret to getting a depressing 400-700/fps on Linux. I'm fairly sure this Gateway will have a short life. Its pretty lightweight and without the magnetic power, I will definitely rip the power coupling out some day soon. However, I plan to extend its life by only using it for presentations. I'll continue to use the MBP for every day development. This Gateway is a Tom-special in that it has a atheros wifi in it as opposed to the Broadcom crap it came with (another "trade secret" driver company -- ironically their trade secret as to how to communicate over wifi in a crappy/slow/poor way isn't really that big of a secret). I think that the next laptop I purchase, even if I have to get it custom made (something that Tom increasingly convinces me is possible), will have MacBook style magnetic power, Intel graphics and atheros wifi.

I was simply awestruck when I plugged my "new" Gateway in to my projector and it "just worked". This will make the LUG Tour so much easier.

Technorati Tags:

Posted by acoliver at 12:59 PM in Open Source
Responses (3)
« May »
SunMonTueWedThuFriSat
  12345
6789101112
13141516171819
20212223242526
2728293031