[ http://nagoya.apache.org/jira/browse/JS2-160?page=comments#action_55559 ] John Donald commented on JS2-160: ---------------------------------
As a workaround I simply do modify the source file: jakarta-jetspeed-2/src/schema/security-schema.xml and change the default values from 0 to false. > 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]