This website uses cookies to ensure you get the best experience. Learn More.
Hypersonic, Mail Portlet and You
While performing a demonstration last week, I added the Mail portlet into a user's private pages and set it up using my Gmail account. Everything went fine during the demo, but when I tried to startup my environment for another demo later in the week, I ran into an issue at startup that confounded me for a few days:"14:59:00,225 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@25a885c3 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: "Digging through my logs, I ran into this:"java.sql.SQLException: error in script file line: 29613 java.io.IOException: org.hsqldb.HsqlException: Value too long"So, I opened up my lportal.script file, went to line 29613 and saw a whole slew of database inserts such as:"INSERT INTO MAIL_ACCOUNT""INSERT INTO MAIL_FOLDER""INSERT INTO MAIL_MESSAGE"As Liferay was integrating my Gmail Inbox, the messages that were being inserted into the DB were too long for Hypersonic to handle. I simply deleted all of the "INSERT INTO MAIL*" lines because I didn't need to have this as part of my standard demo stack. Note that this isn't really a Liferay bug -- it's a limitation of using Hypersonic for your DB. Of course, you should never use Hypersonic SQL in production, but only use it for demonstration / evaluation purposes.