Re: Best practice to support multiple database vendors (DB2 or MSSQL Server)

2011-10-14 Thread Francois Eyl
On 14/10/2011 14:39, Aristedes Maniatis wrote: On Fri Oct 14 23:27:33 2011, Francois Eyl wrote: Hi guys, I'm using Cayenne on my project in order to interface it with a third party application through its database. Until now, the database was a DB2 (AS400), but the application now suppo

Best practice to support multiple database vendors (DB2 or MSSQL Server)

2011-10-14 Thread Francois Eyl
Hi guys, I'm using Cayenne on my project in order to interface it with a third party application through its database. Until now, the database was a DB2 (AS400), but the application now supports MS SQL Server as well. So, I need to support both DB2 and MSSQL Server of course. The databases sc

Re: Does cayenne left-trim on ibm system i db2?

2011-01-18 Thread Francois Eyl
m - Cayenne is too eager in its trimming policy. When reading a CHAR value from DB, it should "rtrim", not "trim" the returned value. I think we should fix this one. Thanks, Andrus On Jan 17, 2011, at 6:53 PM, Francois Eyl wrote: Hi guys, I finally found the issue. The default

Re: Does cayenne left-trim on ibm system i db2?

2011-01-17 Thread Francois Eyl
ers, Francois 2011/1/14 Francois Eyl > Hi Michael, > > I don't see explicitly cayenne doing it (according to the log), but, > strings are coming trimmed (leading spaces as well as trailing ones). Plus, > using the same JDBC driver, on same database and the standard > java.sql.S

Re: Does cayenne left-trim on ibm system i db2?

2011-01-14 Thread Francois Eyl
ng spaces, but should leave leading space alone unless there is a configuration that changes it. mrg On Fri, Jan 14, 2011 at 11:56 AM, Francois Eyl wrote: Hi guys, I've been using cayenne in several projects on top of MS SQL Sever, and It just makes the job easier. I'm playing

Does cayenne left-trim on ibm system i db2?

2011-01-14 Thread Francois Eyl
Hi guys, I've been using cayenne in several projects on top of MS SQL Sever, and It just makes the job easier. I'm playing now with it against a DB2 database (embeded in AS400/i5/IBM System i) using the JT400 JDBC Driver. I'm facing to a strange behavior. It looks like cayenne trim the left

Possible bug with addPrefetch ??

2009-04-17 Thread Francois Eyl
When I remove the addPrefetch, my sample 2 is working fine especilly the step 2... I don't think it's a normal behavior. What's your thoughts ? Cheers, Francois Eyl BTW : Sorry for the long mail, I had to detail my issue to be sure that you get all necessary keys to your hands.

Re: EJBQL and parameters

2009-04-09 Thread Francois Eyl
Robert, thanks for your advises, appreciated. I finally made my own EJBQLTemplateQuery using velocity. This works for me. Still, I'm intrigued by the idea of being able to directly script > EJBQLQuery. Anybody else think that's interesting? If there's a favorable > consensus, I'll add an issue an

Re: EJBQL and parameters

2009-04-09 Thread Francois Eyl
t; > Note that EJBQLQuery parsing follows (or is supposed to follow) the JPA 1.0 > spec. So if you can find reference in the spec that says that parameters > can be used anywhere (including column names), then you should file a > feature request. > > Robert > >

Re: EJBQL and parameters

2009-04-08 Thread Francois Eyl
ues, like: > > EJQLQuery query = new EJBQLQuery("select us.sku from UserSchedule us where > us.userId=:id"); > query.setParameter("id",1); > > Robert > > > On Apr 8, 2009, at 4/84:48 AM , Francois Eyl wrote: > > Howdy guys, >> >> I'

EJBQL and parameters

2009-04-08 Thread Francois Eyl
Howdy guys, I'm trying to use EJBQL query and parameters, but I can't get it to work. Is there something special for ? Bellow is a quick sample of what I'm doing : String queryString = "SELECT us.:SKDID FROM :USCHED us WHERE us.:UID=1"; EJBQLQuery query = new EJBQL

Re: Update in cascade

2008-08-01 Thread Francois Eyl
ncois Aristedes Maniatis wrote: On 01/08/2008, at 10:05 PM, Francois Eyl wrote: What I need is, to change the Name (PK) value of my object, and here I need to change the Name in every related object. But I need to do this on the same SQL transaction. The question you'll probably get back

Re: Update in cascade

2008-08-01 Thread Francois Eyl
Not sure that callbacks is enough. What I need is, to change the Name (PK) value of my object, and here I need to change the Name in every related object. But I need to do this on the same SQL transaction. Thanks. Francois Aristedes Maniatis wrote: On 01/08/2008, at 8:12 PM, Francois Eyl

Update in cascade

2008-08-01 Thread Francois Eyl
Hello all, Is there a way with Cayenne to do an update in cascade with relationships (something like the delete in cascade already implemented) ? Thanks. Francois ___ Ce message a été vérifié par l'antivirus de MDaemon 5 . Par précaution, n'o

Re: Unique persistent object and caching issue

2008-07-31 Thread Francois Eyl
Hi guys, I'm working with Laurent on the same project and we have a strange behavior with this architecture. Lets say, we have our MASTER and MASTER_AUX tables, also the right relationship between them. We've set the database up as read only to simulate a database write error. When we ask

Pb to cast Expression to ejbql string

2008-03-16 Thread Francois Eyl
Hi all, I'm getting a strange behavior using expression and its toEJBQL method. I'm using this to create my where close from a given Expression. This works for me in many cases except for this sample : When I run the toString() method I get the following string (this is ok) : scheduleId in (

Re: Pb implement JOIN function

2008-02-12 Thread Francois Eyl
his isn't what you are looking for, look into the SQLTemplate feature. /dev/mrg On Feb 7, 2008 4:44 PM, Francois Eyl <[EMAIL PROTECTED]> wrote: Hello guys, I have a question about how to join multiple object entities. Concrete sample : I have 2 tables with no foreign key betwee

Pb implement JOIN function

2008-02-07 Thread Francois Eyl
Hello guys, I have a question about how to join multiple object entities. Concrete sample : I have 2 tables with no foreign key between them (poor database). The first one is named SMASTER with 5 columns [SKDDATE (PK), SKDID (PK), JOBNAME (PK), JOBSTATUS, STSTATUS]. The second one is named JS