[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slide-user
Subject:    SQL Script for Slide 2.1 database on DB2 8
From:       Ben Sales <ben.sales () openlogic ! co ! uk>
Date:       2005-05-18 9:52:53
Message-ID: OF33339C2F.002CC451-ON80257005.0035A732-80257005.00364865 () openlogic ! uk ! com
[Download RAW message or body]

--=_mixed 0036485A80257005_=
Content-Type: text/plain; charset="US-ASCII"

Dear All,

I discovered that the db2server.sql database script hasn't been completely 
kept up to date with changes made to the other scripts.  Specifically in 
my case the fix for the length of PROPERTIES.PROPERTY_VALUE not being 
enough hadn't been implemented (Bugzilla bugs 31020, 31118)

I've been through the script and applied changes found in the MySQL 
scripts which appear to work the best.  I've attached the modified DB2 
script.

I also noticed that the maximum possible length for a uri (URI.URI_STRING) 
is 255 characters.  This strikes me as a little short, particularly if you 
have a lot of nested collections.

Regards,

Ben.
-- 
Ben Sales
Open Logic Solutions Limited
Woodside, Perry Wood Walk, Worcester, WR5 1ES
Tel: ++44 (0) 1905 760950 Fax: ++44 (0) 01905 760951
Email: ben.sales@openlogic.co.uk
URL: http:// www.openlogic.co.uk

--=_mixed 0036485A80257005_=
Content-Type: text/plain; charset=us-ascii

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
--=_mixed 0036485A80257005_=--
[prev in list] [next in list] [prev in thread] [next in thread]