From: Sachin D. <sa...@dh...> - 2006-10-06 05:03:45
|
Hello Guys, =20 I am using HSQLDB 1.8 with my application.=20 =20 I want to use something like following: =20 CREATE TABLE [IF NOT EXISTS] (table definition) =20 I see that there is no condition like =E2=80=9CIF NOT EXISTS=E2=80=9D in = HSQLDB. Do you know any workaround for this? =20 Please let me know. =20 Thanks, Sachin |
From: Juergen K. <jk...@ne...> - 2006-10-17 06:31:09
|
Sachin Dharmapurikar wrote: > > Hello Guys, > > > > I am using HSQLDB 1.8 with my application. > > > > I want to use something like following: > > > > CREATE TABLE [*IF NOT EXISTS]* (/table definition)/ > > / / > > I see that there is no condition like “IF NOT EXISTS” in HSQLDB. Do > you know any workaround for this? > > > > Please let me know. > > > > Thanks, > > Sachin > > Well, if all else fails maybe you could try and use PL\SQL? kind of try to do a select on this table - if it does not exist, this should deliver an exception and during handling of said exception you create the table? Not tried it out myself but should work? Juergen Key > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > ------------------------------------------------------------------------ > > _______________________________________________ > Hsqldb-user mailing list > Hsq...@li... > https://lists.sourceforge.net/lists/listinfo/hsqldb-user > |