has anyone else tested this with mysql InnoDB type tables? it is failing for me when it starts to drop foreign key constraints.
ERROR 1025 (HY000) at line 111: Error on rename of './roller_live/website' to './roller_live/#sql2-207-132' (errno: 152) -- Allen On Tue, 2005-09-13 at 18:46, Elias Torres wrote: > 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. > >
