In my "CMS"-like Application (entry point is a servlet) I use slide api directly. For example create: structure.create(slideToken, file, uri); content.create(slideToken, uri, true); NodeRevisionDescriptors revDescriptors = content.retrieve(slideToken, uri); NodeRevisionDescriptor revDescriptor = new NodeRevisionDescriptor(myContent.length()); NodeRevisionContent nrc = new NodeRevisionContent(); nrc.setContent(myContent.toCharArray()); content.create(slideToken, revDescriptors.getUri(), revDescriptor, nrc);
The same for way for retrieving. Tina Jean-Philippe Courson wrote: > How are you creating and trying to retreive content ? > > Tina Yang wrote: > >> Thank you for your quick reply. >> >> I tried postgres; created the tables manually and for content field of >> revisionContent table I used oid but It`s not working. It seems to >> connect correct (for example nodes of Domain.xml are created) but >> creating and trying to retrieve content shows me -> no object >> (structure), no revisioncontent was store in DB. The problem is how to >> find the problem, cause the only exception I'm gettting is >> org.apache.slide.structure.ObjectNotFoundException. >> I am not familiar with database, so I do not know where to find DB >> errors. >> >> Any comment? >> >> Tina >> >> >> >> Jean-Philippe Courson wrote: >> >>>> Hello, >>>> >>>> I want to know: are there any further developements about using >>>> postgres for content storage. >>>> Has one of you guys testet it yet or not? Wrote the subclassed store >>>> or not? >>> >>> >>> >>> >>> >>> It has to be tested but storing content into PostgreSQL should work >>> using oid datatype for content field of revisionContent table. >>> >>> JP >>> >>> >>>> Thanks for your answer. >>>> Tina >>>> >>>> >>>> >>>> Jean-Philippe Courson wrote: >>>> >>>>> I solved my problem by not creating the Revisioncontent table >>>>> (I use Filesystem store for content) >>>>> >>>>> But I visited PostgreSQL JDBC driver web site >>>>> (http://jdbc.postgresql.org) and saw that get/setBinaryStream() >>>>> is supported. >>>>> >>>>> The type to use for SQL script is OID. >>>>> >>>>> I test it and if it works send another SQL script for the web site. >>>>> >>>>> De : "Dirk Verbeeck" <[EMAIL PROTECTED]> >>>>> � : "Slide Users List" <[EMAIL PROTECTED]> >>>>> Envoy� : mercredi 14 novembre 2001 22:32 >>>>> Objet : Re: PostgreSQL support >>>>> >>>>> >>>>> >>>>>> Hi >>>>>> >>>>>> I have looked at the PostgreSQL documentation >>>>>> (http://www.postgresql.org/idocs/index.php?jdbc-lo.html) >>>>>> but it isn't clear if setBinaryStream is supported or not. >>>>>> >>>>>> Subclassing the jdbc store for a specific database is already done >>>>>> for >>>>>> cloudscape and oracle. >>>>>> I don't have PostgreSQL installed but if you can provide a working >>>>>> example of that 'bytea' data type, I can help you write the store. >>>>>> Just look at OracleContentStore.java for an example of subclassing >>>>>> the >>>>>> jdbccontent store. >>>>>> >>>>>> >>>>>> Dirk >>>>>> >>>>>> >>>>>> Jean-Philippe Courson wrote: >>>>>> >>>>>>> Hi >>>>>>> >>>>>>> I wanted to use PostgreSQL as JDBCStore and I saw in JDBC Store >>>>>>> Howto >>>>>>> that Revisioncontent table is using blobs for content. >>>>>>> >>>>>>> I saw in Postgres docs and JDBC driver TODO that Blobs where not >>>>>>> >>>>> currently >>>>> >>>>>>> supported and large binary data was stored using encoded Strings, >>>>>>> >>>>> 'bytea' or >>>>> >>>>>>> others types that seems to do the job quiet well but are not useable >>>>>>> >>>>> with >>>>> >>>>>>> standart >>>>>>> JDBC interface. >>>>>>> >>>>>>> I would like to know if the Revisioncontent table is only use for >>>>>>> contentStore or >>>>>>> if I need to implement a custom store to support Postres. >>>>>>> >>>>>>> Jean-Philippe >>>>>>> > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
