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