Sakai won't start on db2 due to email template issue
GENERAL
TESTING
GENERAL
TESTING
Description
is depended on by
is related to
Activity
Show:
Anthony Whyte November 12, 2010 at 11:20 AM
emailtemplateservice-0.4.x, r84687.
Anthony Whyte November 12, 2010 at 11:16 AM
emailtemplateservice-0.5.x, r84686. Will appear in emailtemplateservice-0.5.0-a03 release.
Hudson CI Server November 4, 2010 at 4:01 PM
Integrated in emailtemplateservice trunk #211 (See http://builds.sakaiproject.org:8080/job/emailtemplateservice%20trunk/211/)
fix db2 startup issue
Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
If you don't set a length in your hbm file hibernate will default varchars to a length of 255. You really need to set lengths so the dialects can determine whether to use varchar, text, clob, or whatever is necessary for that vendor.
Index: api/src/java/org/sakaiproject/emailtemplateservice/hbm/EmailTemplate.hbm.xml
===================================================================
— api/src/java/org/sakaiproject/emailtemplateservice/hbm/EmailTemplate.hbm.xml (revision 84314)
+++ api/src/java/org/sakaiproject/emailtemplateservice/hbm/EmailTemplate.hbm.xml (working copy)
@@ -31,7 +31,7 @@
</property>
<!-- the email template message in html-->
<property name="htmlMessage" type="text">
<column name="HTMLMESSAGE" not-null="false" />
+ <column name="HTMLMESSAGE" not-null="false" length="100000000"/>
</property>
<property name="key" type="java.lang.String" index="email_templ_key">
<column name="TEMPLATE_KEY" not-null="true" length="255"/>