[ http://nagoya.apache.org/jira/browse/JS2-160?page=comments#action_55581 ] Chris Custine commented on JS2-160: -----------------------------------
I have sent several messages to the mailing ilst about this over the past couple of months but no one has ever responded. Here is the most recent post with detailed information about this problem: http://article.gmane.org/gmane.comp.jakarta.jetspeed.devel/16112 I found several mentions of this problem on the Torque list over the past year or more, but I am not sure there has ever been a resolution. I think the mailing list posting above has a couple of the same options that you mention here. > db.create fails on Postgres > --------------------------- > > Key: JS2-160 > URL: http://nagoya.apache.org/jira/browse/JS2-160 > Project: Jetspeed 2 > Type: Bug > Components: Project Build > Versions: 2.0-dev/cvs > Environment: Postgres 8.0.0beta4, Windows > Reporter: John Donald > Priority: Minor > > I'm having Problems with Postgres. > The relation SiteTable has two columns with type BIT. > The default value is an integer, but postgres expects boolean. > So instead of > <!-- > Create SiteTable > --> > <table name="SSO_SITE"> > <column name="SITE_ID" primaryKey="true" required="true" > type="INTEGER"/> > <column name="NAME" required="true" size="254" type="VARCHAR"/> > <column name="URL" required="true" size="254" type="VARCHAR"/> > <column name="ALLOW_USER_SET" default="0" type="BIT"/> > <column name="REQUIRES_CERTIFICATE" default="0" type="BIT"/> > </table> > it would be correct to have: > ... > <column name="ALLOW_USER_SET" default="false" type="BIT"/> > <column name="REQUIRES_CERTIFICATE" default="false" type="BIT"/> > ... > I guess by simply changing it, other databases may fail. > === > Build output: > db.execute: > [sql] Executing file: > C:\usr\jakarta-jetspeed-2\target\src\sql\postgres\security-schema.sql > [sql] [ERROR] Failed to execute: CREATE TABLE SSO_SITE ( SITE_ID integer > NOT NULL, NAME varchar (254) NOT NULL, URL varchar (254) NOT NULL, > ALLOW_USER_SET b > oolean default 0, REQUIRES_CERTIFICATE boolean default 0, PRIMARY KEY > (SITE_ID) ) > BUILD FAILED > File...... C:\usr\jakarta-jetspeed-2\maven.xml > Element... sql > Line...... 355 > Column.... 39 > java.sql.SQLException: ERROR: column "allow_user_set" is of type boolean but > default expression is of type integer -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://nagoya.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
