| Author |
Message
|
| nilayms |
 Posted: Thu Jul 19, 2007 4:02 am Post subject: Oracle database connectivity querry. |
 |
|
Apprentice
Joined: 01 Jun 2006
Posts: 31
Location: UK
|
Hello all,
I have a development problem at hand. In this i need to connect to oracle database and update the tables with the informtion that is sent by a SIEBEL crm application. I have read that it is not possible to connect to the oracle database in from a LINUX environment as the only supported database type is DB2. We are using UNIX environment for our broker.Is it possible to do the database connection in this case?
Which document will be the best one for this problem to refer to?
any suggestion are most welcome.
thanks and regards,
Nilay sundarkar.
_________________
Regards,
Nilay. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Jul 19, 2007 4:06 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What version?
What linux?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nilayms |
| Posted: Thu Jul 19, 2007 4:56 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2006
Posts: 31
Location: UK
|
we are using WBIMB 6.0 with websphere mq 6.0......not really concerned about the Linux part......just wanted to know about the unix part of it........
_________________
Regards,
Nilay. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 19, 2007 5:17 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The only linux platform on which WMB can't talk to Oracle is zLinux.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nilayms |
| Posted: Thu Jul 19, 2007 5:32 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2006
Posts: 31
Location: UK
|
we have the broker and the websphere mq installed on unix AIX machines.......is there some way to connect to oracle in this case?.....
_________________
Regards,
Nilay. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 19, 2007 5:47 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Yes. It's laid out very well how to do this in the InfoCenter.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nilayms |
| Posted: Thu Jul 19, 2007 5:52 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2006
Posts: 31
Location: UK
|
hey sory for the trouble but could you please tell me where to locate infocenter.....i m very new to WBIMB and also to mqseris.net........please do me the favor....
_________________
Regards,
Nilay. |
|
| Back to top |
|
|
| nilayms |
| Posted: Thu Jul 19, 2007 5:59 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2006
Posts: 31
Location: UK
|
hey got it on IBM.....sorry to trouble you......and thnx for the help
_________________
Regards,
Nilay. |
|
| Back to top |
|
|
| nilayms |
| Posted: Thu Jul 19, 2007 7:34 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2006
Posts: 31
Location: UK
|
right now we are using Java database adaptors to update the database tables......is there some way in which the database node of the broker can directly connect to the oracle database and update the tables?
We have tried doing it for a DB2 databse.....need to remove the database adaptor and put that on the database node of the broker......is it possible??
_________________
Regards,
Nilay. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 19, 2007 8:01 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
All of the database access in broker is done in two ways.
1) Using JDBC code that you write yourself
2) Using ODBC, from database/compute nodes and esql
ODBC doesn't care what *kind* of database is behind it - DB2, Oracle, etc.
So your flow doesn't usually *know* what kind of database it's talking to.
Again. Everything you need to know about connecting to a database is in the Info Center.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nilayms |
| Posted: Fri Jul 20, 2007 5:22 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2006
Posts: 31
Location: UK
|
thnx again dude....
_________________
Regards,
Nilay. |
|
| Back to top |
|
|
|
|
