| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WMQI 2.1 and external database |
« View previous topic :: View next topic » |
| Author |
Message
|
| satish |
 Posted: Fri Nov 29, 2002 6:02 am Post subject: WMQI 2.1 and external database |
 |
|
Newbie
Joined: 26 Nov 2001
Posts: 9
|
HI all,
We are planning to have a Production system, where WMQI 2.1 broker will be on Windows NT which queries/inserts data from external database Oracle 8.1.7 is on solaris. I have following queries, any help in this regard is appreciated.
1. Solaris box having Oracle does not ODBC, and we cannot install anything on that box. Since WMQI broker is on Windows is is it enough to configure ODBC on windows only or do I have to do anything on Solaris box?
2. I want to have following exception handling strategy:
If error occurs while insetring into Table1, then it must insert into Table2, if even that fails, then I want to append errorcode and description and put it to a error queue. Has anybody done any similar work?
Any help on this regard is highly appreciated..
thanks,
satish |
|
| Back to top |
|
 |
| Ian |
| Posted: Mon Dec 02, 2002 4:17 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Hi Satish,
Question one is answered here.
_________________
Regards, Ian |
|
| Back to top |
|
|
| tictat |
| Posted: Wed Dec 04, 2002 2:11 pm Post subject: |
|
|
Newbie
Joined: 04 Dec 2002
Posts: 1
|
1. Download Oracle client form oracle website.
2. Install in the m/c(winNT) in which you are running MQSI.
2.5. Configure it to connect to the the Oracle server running on Solaris m/c
3. In your winNT m/c Set ODBC connectivity to the Oracle m/c (Using proper TNS name)
4. Try a test connection
Condition: The username with which you are running the MQSI should be registered with the Oracle server with access right to create, select, insert, delete any tables. Use the same username in ODBC connectivity.
Now,
1. use database node to connect to Oracle. For Datasource name give the datasource name which you mentioned in the odbc connectivity.
2. For table name the syntax is SCHEMANAME.TABLENAME.
3. Use PASSTHRU tag if you want to use any Oracle SQL commands inside the ESQL. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
