Oliver Zeigermann <[EMAIL PROTECTED]> writes: > Ajay K. Mallik wrote: > > Hi Oliver, I have created the oracle schema and I think I got it > > right, but I am experiencing some issues using > > StandardRDBMSAdapter-the domain initialization fails and cannot load > > the servlet. I think the problem lies in some of the sql statements, > > so I wrote an oracle adapter with the following modifications. In > > this regard, I have a few outstanding questions: > > > 1.delete statments: I have to modify some of the delete statements > > as they don't work: > > > eg, > > existing: > > "delete LINKS from LINKS l, URI u where l.URI_ID = u.URI_ID and u.URI_STRING = ?" > > modified to: > > "delete from LINKS lwhere l.URI_ID in(select u.URI_ID from URI u where > > u.URI_STRING = ?" > > Am I doing it right?
That's exactly the kind statements I had to change for Postgres, because it does not like "delete table from table". I changed it to "delete from LINKS where LINKS.URI_ID = URI.URI_ID and URI.URI_STRING = ?" Martin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
