Deploying multiple instances from a single war

2010-09-14 Thread emanuele
I have a Swing ROP application, and i had to create another database, which is equal to the one im using, and i wasen't able to figureout another way to address the other database, cept copying/renaming the webapplication war, and changing the Node.driver.xml. So far now i got WebApp1.war - > http

Re: Cayenne error while committing CLOB on Oracle

2010-09-14 Thread bdflyfisher
In my searching, I found the following, which makes me think this was not an issue in cayenne 2, but is an issue in cayenne 3.0, and will be fixed in cayenne 3.1. Is that true? Here is the link: https://issues.apache.org/jira/browse/CAY-1307 Here is the full error stack: INFO: --- will run 1

Re: Cayenne error while committing CLOB on Oracle

2010-09-14 Thread Andrus Adamchik
Hi there, My memory of this code is a bit rusty now. Could you provide a bigger chunk of the stack please - up to the DataContext commit call? And also maybe an output of DESC CSPROPERTY to see the types of PROPERTYVALUE and CSPROPERTYGUID columns. Andrus On Sep 14, 2010, at 5:23 PM, bdflyf

Re: Bug with EJBQL query referencing two subclasses?

2010-09-14 Thread Andrus Adamchik
Hi Dave, Will be very happy if you can dig to the cause of this issue. EJBQLQuery parsing into SQL starts at org.apache.cayenne.access.jdbc.EJBQLAction. Cayenne walks EJBQL syntax tree, calling visitor callback methods and occasionally switching the visitor object. You may start debugging fro

Cayenne error while committing CLOB on Oracle

2010-09-14 Thread bdflyfisher
Using Cayenne 3.0 against Oracle 11 with driver ojdbc6-11.2.0.1.0.jar. Getting a commit error. We get java.sql.SQLException: Invalid argument(s) in call. Here is part of the info stack: SELECT PROPERTYVALUE FROM CSPROPERTY WHERE CSPROPERTYGUID = ? FOR UPDATE [bind: 1:'...'] INFO: [write LOB:

Re: Keeping hessian servlet session active with a rop client

2010-09-14 Thread emanuele
I'll look into a dummy query to replace getEntityResolver Thanks for the suggestion > Nothing that is built in for this purpose, and IIRC that > 'getEntityResolver' approach may no longer work, as we are caching it now > on the client. You can issue a simple query instead I guess. Something > tha

Bug with EJBQL query referencing two subclasses?

2010-09-14 Thread Dave Lamy
Hello Cayenne gurus-- I hit a SQL syntax problem yesterday while trying to issue a EJBQL query to determine value uniqueness within a given parent "context". The EJBQL query is: SELECT COUNT(distinct a.id) FROM Clip AS a JOIN a.timeline b WHERE a.name = ?1 AND b = ?2[{foo,200}] The interest

Re: Keeping hessian servlet session active with a rop client

2010-09-14 Thread Andrus Adamchik
Nothing that is built in for this purpose, and IIRC that 'getEntityResolver' approach may no longer work, as we are caching it now on the client. You can issue a simple query instead I guess. Something that executes quickly and doesn't bring back any data. It may even end up having better perfor

Keeping hessian servlet session active with a rop client

2010-09-14 Thread emanuele
I've a swing application using cayenne ROP, i had problem with session timeout of the hessian servlet, so far in order to avoid long session timeout, i implemented a thread preforming the following: DataChannel channel; public void run() { for(;;) {