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
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
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
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
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
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
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.
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
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
>
>
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'
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
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
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
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
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
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 (
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
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
18 matches
Mail list logo