[jira] Commented: (JS2-160) db.create fails on Postgres

["Chris Custine (JIRA)" <je...@portals.apache.org>]

    [ http://issues.apache.org/jira/browse/JS2-160?page=comments#action_12317392 ] 

Chris Custine commented on JS2-160:
-----------------------------------

This issue has been resolved with the fix for JS2-318.

> db.create fails on Postgres
> ---------------------------
>
>          Key: JS2-160
>          URL: http://issues.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://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org