Tina Yang wrote:
> 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);
>
Looks good.
Have you verified that nothing was stored into PostgreSQL with a SQL
request ?
If I was you, I would test PostgreSQL oid and JDBC driver with
a very simple example to see what happen. Something like
BufferedInputStream in = new BufferedInputStream(new FileInputStream(new
File("myFile.txt")));
PreparedStatement pstmt = conn.prepareStatement("insert into
revisioncontent values (?,?,?)");
pstmt.setString(1, "uri");
pstmt.setString(2, "xnumber");
pstmt.setBinaryStream(3, in
(int) contentLength);
pstmt.executeUpdate();
...
JP
> 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]>
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
