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