On Wed, 2001-12-19 at 20:55, Jean-Philippe Courson wrote:
> > I am having some probles with version/ example.
> > I tried to modify it to make it store content too.
> > But I am getting this warnings.
> >
> > "org.apache.slide.store.StandardStore - INFO - Delisting service
> > slidestore.reference.JDBCDescriptorsStore@2f35089f from active
> > transaction with failure"
> >
> > AND
> >
> > "WARNING: No active transaction"
> 
> This warning look like if there was not connection to db established.
> Have a look to other log files to see why (wrong user, password,
> incorrect postgresql setup ?).
> Your Domain.xml seem good.

I think there is no problem with my connection. the only thing is
missing is a commit after all these queries.
When I force the query to commit editing
JDBCDescriptorsStore.disconnect() everything is store on DB.
I really don't have a clue of what's wrong.
Did I mention that I'm using postgresql ?

PostgreSQL log -->

query: begin
ProcessUtility: begin
query: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
ProcessUtility: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
query: select * from objects where uri= '/test/arquivo'
query: select * from objects where uri= '/test/arquivo'
query: insert into objects
values('/test/arquivo','org.apache.slide.structure.SubjectNode')

query: select * from objects where uri= '/test'
query: delete from children where uri= '/test'
query: insert into children values('/test', '/test/arquivo')
query: delete from links where link= '/test'
query: select * from revisions where uri= '/test/arquivo'
query: insert into revisions values('/test/arquivo',0,'1.0')
query: insert into revision values('/test/arquivo', '1.0', 'main')
query: insert into property
values('/test/arquivo','1.0','resourcetype','<collection/>','DAV:','',1)

query: insert into property
values('/test/arquivo','1.0','source','','DAV:','',1)

query: insert into property
values('/test/arquivo','1.0','displayname','<![CDATA[arquivo]]>','DAV:','',0)

query: insert into property
values('/test/arquivo','1.0','getlastmodified','Thu, 20 Dec 2001 
13:26:28 GMT','DAV:','',1)

query: insert into property
values('/test/arquivo','1.0','getcontentlength','11','DAV:','',1)

query: insert into property
values('/test/arquivo','1.0','creationdate','2001-12-20T13:26:28Z','DAV:','',1)

query: delete from revisions where uri= '/test/arquivo'
query: delete from workingrevision where uri= '/test/arquivo'
query: delete from latestrevisions where uri= '/test/arquivo'
query: delete from branches where uri= '/test/arquivo'
query: insert into revisions values('/test/arquivo',0,'1.0')
query: insert into latestrevisions values('/test/arquivo','main','1.0')

<-- PostgreSQL log

> 
> JP
> 
> > I think this warnings prevent slide from COMMITING ou ROLLING back the
> > transaction because my logs says that all queries are send to postgresql
> > but neither END nor ABORT are sent.
> >
> > here is my <definition> section from Domain.xml.
> >
> > <definition>
> > <store name="memory">
> > <nodestore classname="slidestore.reference.JDBCDescriptorsStore">
> > <parameter name="driver">org.postgresql.Driver</parameter>
> > <parameter
> > name="url">jdbc:postgresql://ns2.ibnetwork.com.br:5432/slide</parameter>
> > <parameter name="user">user</parameter>
> > <parameter name="password">passwd</parameter >
> > </nodestore>
> > <revisiondescriptorsstore>
> > <reference store="nodestore" />
> > </revisiondescriptorsstore>
> > <revisiondescriptorstore>
> > <reference store="nodestore" />
> > </revisiondescriptorstore>
> > <contentstore
> >   name="file"
> >   classname="slidestore.reference.FileContentStore">
> > <parameter name="rootpath">files</parameter>
> > </contentstore>
> > </store>
> > <scope match="/" store="memory" />
> > </definition>
> >
> > any help ?
> >
> > --
> > Leandro Rodrigo Saad Cruz
> > IT - Inter Business Tecnologia e Servicos (IB)
> > http://www.ibnetwork.com.br
> >
> >
> > --
> > 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]>
-- 
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)
http://www.ibnetwork.com.br


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to