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
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 SQLTransformer
as it gets a ne
