jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Müller <thomas.muel...@day.com>
Subject Re: Branching and workspace creation
Date Mon, 04 Jan 2010 12:20:37 GMT
Hi,

> creation of tables whose name starts with numbers

Yes, quoted names are supported (by all databases): create table "1"(id int);

However Jackrabbit doesn't use quoted names. This will not work, even
in DB2: create table 1(id int);

What about adding a letter prefix: <param name="schemaObjectPrefix"
value="W${wsp.name}_"/>*

Regards,
Thomas



On Mon, Jan 4, 2010 at 10:56 AM, Robin Batra <robin.batra@gmail.com> wrote:
> I tried creating the table in DB2 using its control center and it allows the
> creation of tables whose name starts with numbers. The same is allowed in
> MySql as well.
>
> regarding the schema Object Prefix,
>
> *<param name="schemaObjectPrefix" value="${wsp.name}_"/>*
>
> this is the entry in repository.xml
>
> On Sun, Jan 3, 2010 at 10:06 PM, Alexander Klimetschek <aklimets@day.com>wrote:
>
>> On Thu, Dec 31, 2009 at 19:22, Robin Batra <robin.batra@gmail.com> wrote:
>> > I am working on Windows XP and xp does support creation of folders
>> starting
>> > with numbers. Moreover when i try to create the workspace through my code
>> > the folder is created but when the persistent manager tries to create the
>> > database table corresponding to it an exception is thrown on the server.
>> The
>> > error code returned by DB2 corresponds to "Invalid numeric literal" (i am
>> > using DB2 as the back-end). I think this is the problem of DDL used by
>> the
>> > persistent manager but i am not at all sure.
>>
>> Or maybe DB2 doesn't allow numbers in table / schema names? What are
>> the schemaObjectPrefix'es you have in your repository/workspace.xml?
>>
>> Regards,
>> Alex
>>
>> --
>> Alexander Klimetschek
>> alexander.klimetschek@day.com
>>
>
>
>
> --
> Regards
>
> Robin Batra
>

Mime
View raw message