RE: Cayenne files and WEB application classpath

2009-02-26 Thread Marc Gabriel-Willem
Re, Thanks to the WebApplicationContextFilter and the FileConfiguration, I found a nice solution to my problem. Thank you very much Marc -Original Message- From: Marc Gabriel-Willem Sent: Thursday, February 26, 2009 4:54 PM To: user@cayenne.apache.org Subject: Cayenne files and WEB

Cayenne files and WEB application classpath

2009-02-26 Thread Marc Gabriel-Willem
Hello, I've the following question regarding the configuration of the following cayenne files: C:\temp\dir1\cayenne.xml C:\temp\dir2\map\xxx.driver.xml Using the web.xml file, I would like to specify more than one path. For example: - one for C:\temp\dir1 - a second

Two tables with the same name in two different data model !

2008-12-18 Thread Marc Gabriel-Willem
). It is an historical reason for us... and we cannot modify that name in our db schemas! How can we handle this situation? Thank you for your help. Marc GABRIEL-WILLEM Java Consultant EastNets(tm) LU Route des Trois Cantons, 11 L-8399 WINDHOF Luxembourg Skype: eneumwillem

Teradata + Cayenne

2008-10-28 Thread Marc Gabriel-Willem
Hi, I'd like to use Cayenne with the Teradata database. Is is possible ? Could you give me some advice for this ? Thank you in advance Marc GABRIEL-WILLEM Java Consultant EastNets(tm) LU Route des Trois Cantons, 11 L-8399 WINDHOF Luxembourg Skype: eneumwillem

Multiple queries using the same DB session !

2008-10-06 Thread Marc Gabriel-Willem
the same DB session? Thanks & regards Marc GABRIEL-WILLEM Java Consultant EastNets(tm) LU Route des Trois Cantons, 11 L-8399 WINDHOF Luxembourg Skype: eneumwillem Email: [EMAIL PROTECTED] Fax: +32 (0)2 6560070 http://www.eastnets.com <http://www.eastnets.com/>

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-29 Thread Marc Gabriel-Willem
I'll need to try it with 2.0 in my next test... Andrus On Apr 29, 2008, at 12:00 PM, Marc Gabriel-Willem wrote: > Hello Andrus, > > We've set the autocommit to true using a TransactionDelegate but > somehow, it appears the flag is later on reset automatically to f

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-29 Thread Marc Gabriel-Willem
user@cayenne.apache.org Subject: Re: Stored proc returning result set (and output params) with MS SQL server On Apr 28, 2008, at 3:41 PM, Marc Gabriel-Willem wrote: > Dear Andrus, > > Have you got a chance to work on the problem? No, not yet. > For a summary, our investigations show that usin

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-28 Thread Marc Gabriel-Willem
params) with MS SQL server Ah, I used the MS driver. Let me also try it with jTDS when I have a bit more time. Andrus On Apr 22, 2008, at 10:59 AM, Marc Gabriel-Willem wrote: > Hello Andrus, > > In our test cases, the manual transaction did not avoid the > exception in > erro

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-22 Thread Marc Gabriel-Willem
esday, April 22, 2008 10:06 AM To: user@cayenne.apache.org Subject: Re: Stored proc returning result set (and output params) with MS SQL server Ah, I used the MS driver. Let me also try it with jTDS when I have a bit more time. Andrus On Apr 22, 2008, at 10:59 AM, Marc Gabriel-Willem wrote:

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-22 Thread Marc Gabriel-Willem
n would prevent an exception and I could read the out parameters without a problem, even on error conditions. Andrus On Apr 21, 2008, at 6:20 PM, Marc Gabriel-Willem wrote: > Hi Andrus, > > We are using intensively the QueryResponse ;) > > Here is the problem; the call of the &

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-21 Thread Marc Gabriel-Willem
result.next()) { List outParams = result.currentList(); } if(result.next()) { List actualResult = result.currentList(); } Andrus On Apr 21, 2008, at 5:51 PM, Marc Gabriel-Willem wrote: > Hello, > > Thank you for your investigation. > > Your workaround solves partially

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-21 Thread Marc Gabriel-Willem
Hello, Thank you for your investigation. Your workaround solves partially the problem. It is a good think that we can 'commit' or 'rollback' the transaction ourself. But it remains a major problem regarding the QueryResponse returned by the 'performGenericQuery' method. Our low level layer requi

RE: Stored proc returning result set (and output params) with MS SQL server

2008-04-15 Thread Marc Gabriel-Willem
ayenne.apache.org Subject: Re: Stored proc returning result set (and output params) with MS SQL server Hi Marc Gabriel, > > For information, using JDBC directly the situation is handled > correctly. Could you post the JDBC code you used to read the data? Andrus On Apr 10,

Stored proc returning result set (and output params) with MS SQL server

2008-04-10 Thread Marc Gabriel-Willem
Dear all, First of all, thank you for your great product. We are using it successfully since last year and we are very happy of the product quality. Few days ago, we found a problem with our stored procedures access. In order to illustrate you the problem in the best possible way, I'm

RE: Identity PK value

2007-06-15 Thread Marc Gabriel-Willem
wrote: > It's relatively easy to build your own custom PK generator, using > whatever logic you want. > Take a look at the various database implementations for examples, such > as the OpenBase one. > > On 6/14/07, Marc Gabriel-Willem > <[EMAIL PROTECTED]> wrote: >>

Identity PK value

2007-06-14 Thread Marc Gabriel-Willem
Dear all, We have a problem regarding the PK value access. My db schema and my business logic require me to get the next identity of a particular table before inserting the new record. We must use the identity column defined at the table level (cannot use a stored procedure + pk specific

Oracle stored procedure - registering out ref cursor

2007-05-15 Thread Marc Gabriel-Willem
Dear all, We are trying to map the following oracle stored procedure using the cayenne modeler. Please find below all the details of the PL/SQL required to create the stuff. --- create table tTest ( id int NOT NULL, data varchar2(200)

RE: Stored procedure question ?

2007-05-15 Thread Marc Gabriel-Willem
egards, Marc -Original Message- From: Andrus Adamchik [mailto:[EMAIL PROTECTED] Sent: Monday, May 14, 2007 4:04 PM To: user@cayenne.apache.org Subject: Re: Stored procedure question ? This doesn't make sense to me either. So what happens of you remove the first parameter and set &q

Stored procedure question ?

2007-05-14 Thread Marc Gabriel-Willem
Dear all, I've a question regarding stored procedure in MS SqlServer 2005. I would like to understand why I have to specify the following cayenne mapping in order to be able to use my procedure properly. This is my stored procedure: CREATE PROCEDURE dbo.spViewCustomer @ID as int, @User

RE: Optimistic locking

2007-04-11 Thread Marc Gabriel-Willem
/doc20/configuring-caching-behavior.html /dev/mrg On 4/11/07, Marc Gabriel-Willem <[EMAIL PROTECTED]> wrote: > > Thank you for your reply. > > For information, I'm working on a JSF web application. > I was doing test using two different browsers (Firefox + IE) in order to &

RE: Optimistic locking

2007-04-11 Thread Marc Gabriel-Willem
javas synchronization instead. but i am somewhat surprised that two different data-contexts are notified of a change of one object. kind regards, peter -Ursprüngliche Nachricht- Von: Marc Gabriel-Willem [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 11. April 2007 09:34 An: user@cayenne.apac

RE: Optimistic locking

2007-04-11 Thread Marc Gabriel-Willem
meone else on the list can help. Thanks, /dev/mrg On 4/10/07, Marc Gabriel-Willem <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have some trouble with the optimistic locking function. > > I set the 'optimistic locking' option to an ObjEntity and moreo

Optimistic locking

2007-04-10 Thread Marc Gabriel-Willem
Hi, I have some trouble with the optimistic locking function. I set the 'optimistic locking' option to an ObjEntity and moreover I set an attribute as "used for locking". I'm in a web environment. When I do some modification in a DataObject, the 'log' displayed by Cayenne displays prop

DataContext cleanup

2007-04-10 Thread Marc Gabriel-Willem
Hi, In some situation, I'm creating a child data context. Is there a good way to clean-up that child data context properly (in order to facilitate the JVM GC process) when I finished with it ? Thank you. Marc

RE: Cayenne -- Apache automatic deploy problem

2007-04-05 Thread Marc Gabriel-Willem
state. I only want to write out specific objects for performance reasons. When you serialize a DataObject without a DataContext, it's your responsibility to reconnect your DataObject back to a DataContext. On 4/3/07, Marc Gabriel-Willem <[EMAIL PROTECTED]> wrote: > What your

RE: Cayenne -- Apache automatic deploy problem

2007-04-03 Thread Marc Gabriel-Willem
tiveException("Can't deserialize object for id '" + getObjectId() + "' - no DataContext bound to thread."); } // return context.registeredObject(getObjectId()); return con

RE: Cayenne -- Apache automatic deploy problem

2007-04-02 Thread Marc Gabriel-Willem
http://svn.apache.org/repos/asf/cayenne/main/branches/STABLE-2.0/ cayenne/cayenne-java/src/cayenne/java/org/apache/cayenne/access/ DataContext.java On Mar 30, 2007, at 10:55 AM, Marc Gabriel-Willem wrote: > Hello, > > I checked the entity resolver value. > Indeed, in this situation the

RE: Cayenne -- Apache automatic deploy problem

2007-03-30 Thread Marc Gabriel-Willem
tEntityResolver() != null Andrus On Mar 30, 2007, at 5:24 PM, Marc Gabriel-Willem wrote: > Hello, > > Sorry, it is the first time I'm using a list like this one. So, I'm > doing some crazy error with it :) For example, I hope my "reply > all" is > a correct ac

RE: Cayenne -- Apache automatic deploy problem

2007-03-30 Thread Marc Gabriel-Willem
30, 2007 3:09 PM To: user@cayenne.apache.org Cc: Marc Gabriel-Willem Subject: Re: Cayenne -- Apache automatic deploy problem Hi, See my original reply asking for more information here: http://objectstyle.org/cayenne/lists/cayenne-user/2007/03/0101.html BTW, it would be much easier to communicate if yo

Cayenne -- Apache automatic deploy problem

2007-03-30 Thread Marc Gabriel-Willem
Hi, Sorry to repost that question, but I was not properly register to the mailing list, so I was unable to reply properly. I'm using Cayenne (2.0.2) with the apache web server (5.5.20) and I'm facing to the following problem. When apache does an automatic deploy, all objects are seriali

Cayenne -- Apache re-deploy problem -- NullPointerException

2007-03-14 Thread Marc Gabriel-Willem
Hi, I'm using Cayenne (2.0.2) with the apache web server (5.5.20) and I'm facing to the following problem. When apache does an automatic deploy, all objects are serialized / deserialized without any error. But after that, when the code accesses a cayenne persistent object (member variable

Cayenne -- Apache re-deploy problem -- NullPointerException

2007-03-13 Thread Marc Gabriel-Willem
Hi, I'm using Cayenne (2.0.2) with the apache web server (5.5.20) and I'm facing to the following problem. When apache does an automatic deploy, all objects are serialized / deserialized without any error. But after that, when the code accesses a cayenne persistent object (member variable