Oliver Zeigermann wrote:
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?
No, but
delete from LINKS where LINKS.URI_ID = URI.URI_ID and URI.URI_STRING = ?
might work though. Avoid sub selects where ever you can...
Oooops. Just checked it and it does not work. I guess your example is the right one...
A colleague just told me the number of rows that can be deleted with a subselect are limited. Isn't this slow as well?
Hmmmmmmmmmmmmmmmmmmmmmm.....
Oliver
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
