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]
