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