Thanks a lot Thomas, it WORKED. But my only concern is it should not effect the existing workspaces that were created before making the change to SchemaObjectPrefix
On Mon, Jan 4, 2010 at 5:50 PM, Thomas Müller <[email protected]>wrote: > 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 <[email protected]> > 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 <[email protected] > >wrote: > > > >> On Thu, Dec 31, 2009 at 19:22, Robin Batra <[email protected]> > 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 > >> [email protected] > >> > > > > > > > > -- > > Regards > > > > Robin Batra > > > -- Regards Robin Batra
