You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Leandro Rodrigo Saad Cruz <le...@ibnetwork.com.br> on 2001/12/19 22:28:41 UTC
Problem with examples and transactions
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"
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Problem with examples and transactions
Posted by Leandro Rodrigo Saad Cruz <le...@ibnetwork.com.br>.
On Thu, 2001-12-20 at 22:06, Dirk Verbeeck wrote:
> Normally there should be an error message with the SQLException that
> caused the failure.
> What version are you using ?
There were no exceptions.
I'm using PostgreSQL 7.1.3-4.
When I use mysql everything goes fine.
>
> Can you give the line number in the example that causes the error?
>
>
> Dirk
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
--
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)
http://www.ibnetwork.com.br
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Problem with examples and transactions
Posted by Dirk Verbeeck <di...@pandora.be>.
Normally there should be an error message with the SQLException that
caused the failure.
What version are you using ?
Can you give the line number in the example that causes the error?
Dirk
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Problem with examples and transactions
Posted by Leandro Rodrigo Saad Cruz <le...@ibnetwork.com.br>.
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:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
--
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)
http://www.ibnetwork.com.br
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Problem with examples and transactions
Posted by Jean-Philippe Courson <co...@noos.fr>.
> 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.
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:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>