I'd rather play golf

Julian Maughan of the NHibernate project and I have recently been conversing through email about the state of the NHibernate dialects for Sybase products, including SQL Anywhere. This morning Julian posted an article on the NHibernate Development Google Group. It’s a request for feedback on a proposal to eliminate the existing SQL Anywhere NHibernate dialects [...]

[Read more →]

In case you missed it, NHibernate 3.0.0 (alpha) was announced in late July, and both binaries and source code for the new release is now available on sourceforge.net. With the 3.0.0 release, NHibernate includes support for LINQ, along with additional features such as: Along with a long list of bug fixes and improvements, it has [...]

[Read more →]

I have uploaded a Sybase PowerDesigner whitepaper entitled Generating Hibernate 3.0 Persistent Objects with PowerDesigner that describes the comprehensive support within PowerDesigner 12 and up for Hibernate object-relational mappings, including generating Hibernate artifacts such as configuration files, mapping files, and Java class files. In subsequent articles, I’ll look at specific functionality within PowerDesigner’s Hibernate support, [...]

[Read more →]

In several earlier posts I have described how to reverse-engineer a SQL Anywhere database to generate Hibernate configuration files and the corresponding Java classes, using Middlegen (now obsolete) with Ant, and the Hibernate Tools plug-in within Eclipse Ganymede. In my experience neither Middlegen nor the Hibernate Tools plug-in are particularly robust. The Middlegen software is [...]

[Read more →]

On Friday I attended a Distributed Systems seminar at the University of Waterloo given by Christopher Ming-Yee Iu, now a PhD student at EPFL in Lausanne studying under Willy Zwaenepoel. Here’s Ming’s abstract: Instead of using a separate query language like SQL to query databases, many programmers prefer using higher-level abstraction layers like Ruby on [...]

[Read more →]

You can find an NHibernate dialect customized for the Sybase SQL Anywhere 12 server (currently in beta) here. This new SQLAnywhere12Dialect offers support for: The TIMESTAMP WITH TIME ZONE data type (also known as the DATETIMEOFFSET data type); and SEQUENCE values using the new SEQUENCE support in the SQL Anywhere 12 server. SQL Anywhere 12 [...]

[Read more →]

On 15 December I presented a webinar entitled “Object-relational Mappers: Friend or foe?”. A flash recording of this webcast is available here. After entering your contact information, you’ll be automatically redirected to another page and the flash recording will begin immediately.

[Read more →]

On Tuesday, 15 December 2009 I’ll be presenting a one-hour webinar entitled “Object-relational Mappers: Friend or foe?”: Object relational mappers (ORMs) such as LINQ, Hibernate, and ActiveRecord bridge the gap between the relational database world, and the object-oriented world. By abstracting the database into “virtual database objects”, they let programmers develop in any language and [...]

[Read more →]

In July I posted a new NHibernate dialect for SQL Anywhere versions 10 and up, which was based on the then-existing NHibernate 2.0.1GA distribution. This week I’ve modified the dialect slightly and compiled and tested it with the latest NHibernate 2.1.0GA distribution; you can download the new dialect source code and NHibernate.DLL libraries here. In [...]

[Read more →]

At June’s 2009 ACM SIGMOD Conference, Surajit Chaudhuri of Microsoft Research presented a thought-provoking paper [1] entitled “Query Optimizers: Time to Rethink the Contract?”. Here is the abstract: Query Optimization is expected to produce good execution plans for complex queries while taking relatively small optimization time. Moreover, it is expected to pick the execution plans [...]

[Read more →]