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:
Se você deseja utilizar o Oracle nas transações coordenadas:
Consulte as informações fornecidas para a versão do WebSphere MQ que você instalou:
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+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=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+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=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+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=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
SwitchFile: C:\WMQI\BIN\UKor8dtc20.dll
XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID
+ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+
ThreadOfControl: THREAD
Se você deseja utilizar o Oracle nas transações coordenadas:
Os exemplos a seguir mostram o que você deve incluir na sub-rotina XAResourceManager no arquivo qm.ini nos sistemas UNIX e a informação equivalente para o Windows:
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ XACloseString= ThreadOfControl=THREAD
SwitchFile: UKor8dtc20.dll XAOpenString=ORACLE_XA+SQLNET=myserver+HostName=myhostname+PortNumber=myportnumber+Sid=mySID +ACC=P/uid/passwd+sestm=100+threads=TRUE+DataSource=mydatasourcename+DB=mydatasourcename+K=2+ ThreadOfControl: THREAD