Se o fluxo de mensagens interagir com um banco de dados Oracle e você desejar coordenar as atualizações feitas no banco de dados com outras ações dentro do fluxo de mensagens, configure o intermediário para gerenciar essas atualizações.
Antes de começar:
Para concluir esta tarefa, você deve ter concluído a seguinte tarefa:
As instruções a seguir descrevem como configurar as origens de dados do Oracle para a coordenação XA. Para obter informações adicionais sobre a configuração do Oracle para coordenação XA com o WebSphere MQ, consulte a seção chamada "Configuração do Oracle" em Administração do Sistema WebSphere MQ.
Para configurar suas origens de dados do Oracle para a coordenação do XA utilizando o WebSphere MQ Versão 5.0 como o coordenador de transação:
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID+ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKoradtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
Campo | Value |
---|---|
SwitchFile | C:\Program Files\IBM\MQSI\6.0\bin\UKor8dtc20.dll |
XAOpenString | ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ |
ThreadOfControl | THREAD |
Para configurar suas origens de dados do Oracle para a coordenação do XA utilizando o WebSphere MQ Versão 6.0 como o coordenador de transação:
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKoradtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
Campo | Value |
---|---|
SwitchFile | UKor8dtc20.dll |
XAOpenString | ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ |
ThreadOfControl | THREAD |