Luca,
I would prefer to use stored procedures, but they are not implemented
yet in MySQL and we use MySQL in all our applications. MySQL doesn't
suport the begin-end; construction you used below either AFAIK.
/Daniel Fagerstrom
Luca Morandini wrote:
Sylvian,
I'm not completely convinced a rew
Sylvain Wallez wrote:
I consider that getting a connection from the pool for each
creates some unnececessary load on the pool. So I would
go for the first solution (use the same connection).
I will try that.
There will still be a need for new connections for sub queries, to reuse
the same co
> -Original Message-
> From: Sylvain Wallez [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 15, 2002 1:48 PM
> To: [EMAIL PROTECTED]
> Subject: Re: SQLTransformer and Transactions
> In the above example, the transaction is contained in a _single_
> element. Wh
Luca Morandini wrote:
Sylvian,
I'm not completely convinced a rewriting of SQLTransformer is needed to handle transactions... I tried the following:
name="test">
begin
DELETE FROM CRRegion
WHERE Id > 80;
COMMIT;
INSERT INTO CRRegion
(Id, Name)
VALUES
('90', 'Foo');
INSERT
Antonio Gallardo wrote:
Can you explain what you have in mind Sylvain? I dont understand what you
have in mind.
I guess it's the "load on the pool" that is unclear.
What I'm saying is that I consider a waste of CPU to get a connection
from the same pool for each encountered in the
document
-
> -Original Message-
> From: Sylvain Wallez [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 14, 2002 11:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: SQLTransformer and Transactions
>
>
> Daniel Fagerstrom wrote:
>
> > I'd like
Can you explain what you have in mind Sylvain? I dont understand what you
have in mind.
Antonio Gallardo
Sylvain Wallez dijo:
>
> I consider that getting a connection from the pool for each
> creates some unnececessary load on the pool. So I would
> go for the first solution (use the same conne
Daniel Fagerstrom wrote:
I'd like to use transactions in the SQLTransformer and tried something
like:
...
BEGIN;
Do something
Do something that is based on the previous query
COMMIT;
...
This does not work in the current implementation of the SQL
Didier,
let me tell you that your problems are really strange... I think I cannot be of much
assistance though I completed many projects
using your very configuration.
BTW, how (and if) did you manage to solve the empty tag problem ?
Best regards,
P.S.
One more thing, this kind of problems are
Looks A-OK, thanks.
tomK
> -Original Message-
> From: Davanum Srinivas [mailto:[EMAIL PROTECTED]]
> Sent: maandag 20 augustus 2001 19:29
> To: [EMAIL PROTECTED]
> Subject: Re: SQLTransformer: the last one?
>
>
> Tom,
> Checked in. Please cross
Tom,
Checked in. Please cross-check.
Thanks,
dims
--- [EMAIL PROTECTED] wrote:
> Hi all,
>
> With this patch, SQLTransformer seems to behave like a good Transformer to
> me :)
>
> Any comments welcome.
>
>
> tomK
>
>
> ATTACHMENT part 2 application/octet-stream name=SQLTransformer.java.p
7
> To: [EMAIL PROTECTED]
> Subject: Re: SQLTransformer
>
>
> Done. Please cross-check.
>
> Thanks,
> dims
>
> --- [EMAIL PROTECTED] wrote:
> > Continuing on SQLTransformer...
> >
> > I found a finally{} statement that wasn't on the right
> pla
Done. Please cross-check.
Thanks,
dims
--- [EMAIL PROTECTED] wrote:
> Continuing on SQLTransformer...
>
> I found a finally{} statement that wasn't on the right place. Should resolve
> quite a lot of difficulties, I think. This diff is against the current
> version in CVS, so you could disregar
TECTED]
> Subject: RE: SQLTransformer
>
>
> Of course you can :)
> I'm just having trouble with having WinCVS running a diff -u,
> but I just
> downloaded cygwin and that should solve the problem
> somehow... I'll just
> have to find out how
anum Srinivas [mailto:[EMAIL PROTECTED]]
> Sent: dinsdag 14 augustus 2001 16:59
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: SQLTransformer
>
>
> Tom,
> Can i persuade you to run a "cvs diff -u" and submit the
> output? Otherwise i wil
Tom,
Can i persuade you to run a "cvs diff -u" and submit the output? Otherwise i will have
to
integrate changes by hand.
Thanks,
dims
--- [EMAIL PROTECTED] wrote:
> Still progressing slowly but steadily on the SQLTransformer.
>
> From good source, I just learned that you _can_ keep using the
16 matches
Mail list logo
