portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Custine (JIRA)" <jetspeed-...@jakarta.apache.org>
Subject [jira] Commented: (JS2-160) db.create fails on Postgres
Date Wed, 17 Nov 2004 14:51:28 GMT
     [ 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: 

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) )
> 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:
If you want more information on JIRA, or have a bug to report see:

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

View raw message