MQSeries.net :: View topic

Fede_patane · Posted: Wed Feb 13, 2008 2:49 am Post subject:

Dear gurus,
i am using WMB 6 on AIX 5.3 and i am developing a flow that uses an ODBC source to an SQL Server Database.

I have created the ODBC source in the /var/mqsi/odbc/.odbc.ini in the following way:

[ArClientes]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKmsss20.so
Description=Base de clientes
Address=mysqlserver
Database=AR_CLIENTES
AnsiNPW=Yes
QuotedId=No

in the flow i am using a compute node on this source and within i excecute several SPs . What I want to do is if any of the SPs fail to rollback all the excecutions.

When i do this even if i explicitly call rollback it does not rollback. I have tried changing the compute node "transaction" from automatic to commit and back and nothing changes. I have also inspected the SPs and none have an explicit commit inside.

I have tried doing this on a db2 database and it worked fine.

Has any of you encountered this problem before.

An example of what i am trying to do would be:

PASSTHRU 'BEGIN TRANSACTION' ;

call SP1 (
...
....
)

if error then
PASSTHRU 'ROLLBACK TRANSACTION' ;
end if;

call SP2 (
...
....
)

if error then
PASSTHRU 'ROLLBACK TRANSACTION' ;
end if;

call SP3 (
...
....
)

if error then
PASSTHRU 'ROLLBACK TRANSACTION' ;
end if;

PASSTHRU 'COMMIT TRANSACTION' ;

Any ideas or sugestions will be welcomed.

Thanx in advance.

Federico
_________________
You ask why are we slaves, but I ask why are you not? What hideous force in the universe could set you free and forever taken away your peace of mind.