Sure Oliver, I will port it and give it to Slide. Thanks for all your help. --Ajay
-----Original Message----- From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 5:58 PM To: Ajay K. Mallik Subject: Re: J2EEContentStore Hi again Ajay! First of all may I ask you to take this discussion further in the Slide list so others may contribute and participate? Among others the connection thing was one of the reasons we replaced the old J2EE implementation. If this is your problem as well it would be much easier to do the port than to fix the old thing. Schemas for SQLServer, Sybase, MySQL and Postgres are available as a good strarting point I guess. org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter is the default implementation containing all SQL code. It might already do for Oracle, if not you might have to subclass it. Schemas can be found in CVS in the same directory as StandardRDBMSAdapter. For you convenience I will attach the SQLServer schema. Please feel free to ask any question you want to the list. We will be pleased to assist in any way we can. May I suggest if you actually get the port done to donate it to Slide and give the copyright to the Apache Software Foundation? Cheers, Oliver Ajay K. Mallik wrote: > Hi Oliver, > I can create the schema if I have a reference one for the new store schema. But does > the the code take care of BLOBs and so on? > > The problem I am having with the existing implementation is with some serious > connection issues-connection is not being closed. I have to use low level API to > access slide store, and I don't know how to close the connections...In the code of > slidestore.j2ee.J2EEContentStore, I don't see we are closing connections > anywhere-just closing the statements. Am I missing anything? > Here is what I am doing: > --------------------------------- > //get namespace access token 'nat' from context > NamespaceAccessToken nat; > //get content helper > try{ > org.apache.slide.content.Content content=nat.getContentHelper(); > NodeRevisionDescriptors revisionDescriptors=content.retrieve(st,currentPath); > NodeRevisionDescriptor revisionDescriptor=content.retrieve(st,revisionDescriptors); > NodeRevisionContent > revisionContent=content.retrieve(st,revisionDescriptors,revisionDescriptor); > InputStream inputStream = revisionContent.streamContent(); > //process content... > }catch(Exception ex){ > > }finally{ > //???close the connection here??? will nat.disconnect() work??? > } > -------------------------- > I will highly appreciate if you can show me where do we get the connections and > close, that would be great > Thanks for your help. > > > > > -----Original Message----- > From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] > Sent: Monday, February 09, 2004 3:59 PM > To: Ajay K. Mallik > Subject: Re: J2EEContentStore > > > Hi Ajay, > > I am awfully sorry, but there is no support for Oracle, yet :( :( :( :( > A port should be pretty straight forward and may take not much more than > a day of work, but due to lack of time none of us was able to contribute > the port, yet! > > You have three options > 1. Use what ever you had working with Oracle > 2. Contribute the Oracle port yourself (if you could do so I would very > much appreciate this) > 3. Wait a while and hope somebody will came up with the port soon > > Sorry, I could not help more... > > Oliver > > Ajay K. Mallik wrote: > > >>Hi Oliver, >>I am using Oracle. Where can I find the new schema? >>Thanks for your help, Oliver. >>--Ajay >>-----Original Message----- >>From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] >>Sent: Monday, February 09, 2004 3:41 PM >>To: Ajay K. Mallik >>Subject: Re: J2EEContentStore >> >> >>Hi Ajay, >> >>as I already posted to the list the new combined J2EE store is >>org.apache.slide.store.impl.rdbms.J2EEStore >> >>If you want to port your old data to this store you will need work. If >>you have legacy data and are satisfied with it you might consider using >>the old store even though it is completely unsupported now. >> >>Oliver >> >>Ajay K. Mallik wrote: >> >> >> >>>Hi Oliver, >>>Which content store should we use instead of slidestore.j2ee.J2EEContentStore to >>>configure using Domain.xml? >>>Please help!!! >>>Thanks in advance. >>>Ajay >>> >> >> >> >> >> > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
