Hi, the StandardRDBMSAdapter uses Sybase / MS SQLServer dialect. Try one of the other adapters for hsqldb.I have heard Postgres is always closest to the standard. To answer the next question: It is called StandardRDBMSAdapter as Sybase / MS SQLServer where the only initially supported databases.
Concerning hsqldb: It used to be supported by Slide, but no longer is as it does not provide proper isolation features as it has no internal locks. Now that Slide has internal locks, support for hsqldb could be an option again. Please report back if you can get it work with hsqldb and how. Oliver On Tue, 28 Dec 2004 16:36:57 +0000, Eirikur Hrafnsson <[EMAIL PROTECTED]> wrote: > Hi, > > this sql fails in HSQLDB: > "delete LOCKS from LOCKS, URI u where LOCK_ID = u.URI_ID and > u.URI_STRING=?"); > > it's from StandardRDBMSAdapter: public void removeLock(Connection > connection, Uri uri, NodeLock lock) > > What does "delete LOCKS from LOCKS" do? Why not just "delete from > LOCKS...." ? > > Best Regards > > Eirikur S. Hrafnsson, [EMAIL PROTECTED] > Chief Software Engineer > Idega Software > http://www.idega.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
