Raw delete

2010-10-20 Thread brd
Hello all, Whats the better way to do a regular delete from in raw sql? I tried a raw sql named query on the modeler but i get a Null PK error, maybe because no data rows are returned? Thank you

Re: Child Contexts

2010-09-21 Thread brd
Hey Michael, How silly of me! Cayenne gives me a even simpler solution for this! Can I use a Cayenne client on each portlet and create a cayenne server on a servlet to receive their requests? this way all database communication is done by the servlet and not by all portlets. Could I also do this?

Re: Child Contexts

2010-09-21 Thread brd
I'm using the regular way, through the Cayenne's DataNode XML file. But I am open to suggestions :). I was thinking about configuring a global resource on tomcat using JNDI that would return a DataContext, but i dont know if everytime an application access the resource a new object is created? Tha

Re: Child Contexts

2010-09-21 Thread brd
Hey Michael and Robert, Ok so i got the difference between context and connection. So how can i close all connections before closing an application, a servlet or a portlet? My main problem here is that on each deploy of a new web application the connections from former deployments stay on (like me

Child Contexts

2010-09-21 Thread brd
Hello all, Do Child Contexts share the connection of a parent connection? When i do a commitChanges on the child the change is made on the database or in the parent? I have already read the Nested Contexts page on the User Guide but this detail was confusing for me. Thank you Bruno

Too Many Connections

2010-09-21 Thread brd
Hello all, I'm using cayenne in conjunction with portlets deployed on liferay. I am having problems with database connections (Too many connections exception). Anyone developed some application on this type of environment? How can I make all portlets share one connection? Can I use child contexts