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?
2. The binding and the statement in the following method does not seem right:
method: public void removeLock(Connection connection, Uri uri, NodeLock lock)
first query:
statement = connection.prepareStatement( "delete LOCKS from LOCKS, URI u where
LOCK_ID = u.URI_ID and u.URI_STRING=?");
statement.setString(1, lock.getLockId());
second query:
statement = connection.prepareStatement( "delete URI from URI, LOCKS l where URI_ID =
l.LOCK_ID and URI_STRING=?");
statement.setString(1, lock.getLockId());
comments:
first query:Should we bind u.URI_STRING to lock_id?
second query: should we delete the uri when we are removing the lock? Not sure.Please
confirm.
3. Adding properties:
In properties table, none of the fields can be null. When I was initializing
domain.xml, I found that some of the fields values like property_type were "", and
oracle would complain with some message like 'cannot insert null into properties
table'. I saw that domain.xml file has <property> tag does not have all the
attributes mandatory. for example, in domain.xml, we have
<property namespace="http://jakarta.apache.org/slide/"; name="password"/>
comments: should I make the fields in Properties table nullable?
I am looking forward to suggestions and instructions regarding how to get it working,
especially items 2 and 3.
Thanks for your help.
Ajay
-----Original Message-----
From: Oliver Zeigermann [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 6:00 AM
To: Ajay K. Mallik
Subject: [Fwd: Re: J2EEContentStore]
Hi Ajay,
I hope you have understood the discussion goes on in the Slide dev-list.
Just wanted to make sure you have seen the post I have forwarded with
this message.
Cheers,
Oliver
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
