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]>