You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "John Donald (JIRA)" <je...@jakarta.apache.org> on 2004/11/17 05:40:25 UTC
[jira] Commented: (JS2-160) db.create fails on Postgres
[ 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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org