db2 8.1

[toddmcgrath <mc...@supergloo.com>]

Hi,

Using Jackrabbit 1.3.1, BundleDbPersistenceManager with DB2 8.1

When running on db2 8.1, an index called USERGROUPS_BUNDLE_IDX is attempted
to be created.  The max length for an index name is 18 characters.  Any work
around suggestions?  

Might be of interest: https://issues.apache.org/jira/browse/JCR-846

Thanks in advance,
Todd
-- 
View this message in context: http://www.nabble.com/db2-8.1-tf4436619.html#a12657656
Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.

Re: db2 8.1

[Stefan Guggisberg <st...@gmail.com>]

hi todd,

On 9/13/07, toddmcgrath <mc...@supergloo.com> wrote:
>
> Hi,
>
> Using Jackrabbit 1.3.1, BundleDbPersistenceManager with DB2 8.1
>
> When running on db2 8.1, an index called USERGROUPS_BUNDLE_IDX is attempted
> to be created.  The max length for an index name is 18 characters.  Any work
> around suggestions?

schema objects created by the pm are by default prefixed by the workspace name.
you could therefore either

a) choose a shorter workspace name (e.g. "USRGRPS")

or

b) change the 'schemaObjectPrefix' parameter of the
    PersistenceManager configuration in the appropriate
    workspace.xml file, e.g.

    <param name="schemaObjectPrefix" value="USRGRPS_"/>


hope this helps, cheers
stefan

>
> Might be of interest: https://issues.apache.org/jira/browse/JCR-846
>
> Thanks in advance,
> Todd
> --
> View this message in context: http://www.nabble.com/db2-8.1-tf4436619.html#a12657656
> Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.
>
>