I have updated my patch to now work with DB2. Everything seems to be working beautifully.
http://torrez.us/2005/08/23/roller/patches/db2_derby.hibernate3.patch Regards, Elias PS> Now onto tagging. Heads up. I would like to add tagging to Roller, possibly using the metadata table. I'll try to draft something up on the wiki. On 9/13/05, Elias Torres <[EMAIL PROTECTED]> wrote: > Hi Everyone, > > After getting the nice upgrade to Hibernate 3 by Dave, I started > working on testing Derby support first, then DB2. I only found a > couple of issues with Derby so far, everything seems to run fine. > > Here's my patch: > http://torrez.us/2005/08/23/roller/patches/derby_hibernate3.patch > > Basically, > > There was a getInt() that doesn't seem to work on strings for Derby, > so I did this: > - dbversion = rs.getInt(1); > + dbversion = Integer.parseInt(rs.getString(1)); > > The next one was a query in HibernateRefererManagerImpl.java which is > not performed via Hibernate and there was a "limit" keyword which is > not supported by Derby. I first tried the HSQL version, but Derby > doesn't support TOP either. I added a check on the loop for max > results, somebody please verify that this is ok. Thanks. > > Elias > > PS> Now onto DB2. >
