I've found the source of my problems and found other bugs and even workarounds.
The first problem was invalid createdb.sql for mysql, derby and others. The culprit was an extra incorrect definition of BOOLEAN_SQL_TYPE_TRUE in some .properties files. I have removed those and I'll be committing the changes. Regarding the problem with $ADDL_FK_PARAMS showing up in the SQL, I found a quick fix by using Quiet Reference Notation [1]. So in the createdb.vm I now use $!ADDL_FK_PARAMS and others that should be blank when null (note the !). I'm committing this too. Now after some more testing on Derby, I found that I was getting an exception when inserting the RefererData: SQL Exception: An attempt was made to get a data value of type 'CLOB' from a data value of type 'VARCHAR'. I did some googling and ended it up at this JIRA BUG [2] currently unassigned. I'm copying Kevin Foster from Derby at IBM to let him know about it and in the meantime I'll turn a null into an empty string for a quick workaround. If this is too hackish, please let me know or just undo my change. I'll leave a thorough note. I was getting some derby startup errors on Tomcat, so I remembered about a Lifecycle events article on dW [3] I had read before. I decided to grab that lifecycle listener and modify it [4] accordingly for derby. It works fine and if you guys like I can check it in. I also got this error on Hibernate, anyone has seen this before. I'm just trying to be thorough. [[[ ERROR 2005-12-23 10:38:09,654 HibernateWeblogManagerImpl:getComments - org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: org.roller.pojos.WeblogEntryData ]]] I'll keep on hacking, maybe do some on tags as well. Regards, Elias [1] http://tinyurl.com/cszr8 [2] http://issues.apache.org/jira/browse/DERBY-628 [3] http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408bader/ [4] http://tinyurl.com/duct9 On 12/22/05, Elias Torres <[EMAIL PROTECTED]> wrote: > I'm trying to catchup with roller-dev, I've checked out and try > building but I found a couple of problems with mysql db script > generation. > > First I noticed that ADDL_FK_PARAMS is not being replaced with the > empty string in the createdb.sql because it's null, so if I remember > correctly, velocity just echoes the variable name. Is there a way to > turn that off? > > I'm also having problems with boolean_type_true "bit default 1" in > mysqld 4.1.12-Debian_1ubuntu3-log. > > I have to run off to do some mingling with the family (I'm on > holiday), so I'll try to figure this out later tonight or something. > > Regards, > > Elias >
