| Author |
Message
|
| goldym |
 Posted: Wed Jun 07, 2006 12:07 pm Post subject: Mapping node Issue |
 |
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
I am attempting to use the mapping node to map from a database to XML. I have two Issues
1. When I create my connection to Oracle none of the tables show up. There is no + there to see my view my folders?
2. I created a connection DB2 but it is not available to me in the Mapping Node editor?
Did I miss a step? |
|
| Back to top |
|
 |
| neerav |
| Posted: Wed Jun 07, 2006 2:15 pm Post subject: |
|
|
Novice
Joined: 31 May 2006
Posts: 22
|
I had a similar requirement with just the fact that i was trying to send message to Oracle (XML to oracle table schema).
I had tried using the RDB Definition File. But when you were to choose the required table while creating the RDB Definition file, NO tables show up in my new MessageMap. And if you were to create the RDB Definition file with its default table selection settings then it would import ALL the table definitions of the database.
Ultimately i had to make my destination schema as an XSD (matching the DB schema) and go ahead. |
|
| Back to top |
|
|
| goldym |
| Posted: Wed Jun 07, 2006 6:25 pm Post subject: |
|
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
| Are you saying that creating this connection doesnt work with Oracle DB does anyone know? |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Jun 07, 2006 8:00 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi goldym,
Had made this note on how to configure the database node sometime back...You could check if it works...I remember getting the list of tables with it....for Oracle database.
| Quote: |
Database Name: Service Name(Oracle),Datasource name DB2)
UserId/Password: Database Vendor Type: OracleXi, DB2 Universal Database VX.X (X-Version)
For Oracle Host: XXX.XXX.XXX.XX
For Oracle Port: 1521
JDBC Driver: Oracle JDBC Driver(Oracle), IBM DB2 APP DRIVER(DB2)
Class location: C:\oracle\ora90\jdbc\lib\classes12.zip(Oracle), C:\IBM\SQLLIB\java\db2java.zip(DB2) |
Regards. |
|
| Back to top |
|
|
| goldym |
| Posted: Thu Jun 08, 2006 4:22 am Post subject: |
|
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
| Do you know if Oracle needs to be installed locally if you are trying to connect to a remote DB? |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Jun 08, 2006 4:26 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi goldym,
Atleast an Oracle client will need to be installed.
Regards. |
|
| Back to top |
|
|
| goldym |
| Posted: Thu Jun 08, 2006 4:27 am Post subject: |
|
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
| Ok Will give that a try. Thanks |
|
| Back to top |
|
|
| goldym |
| Posted: Thu Jun 08, 2006 9:01 am Post subject: |
|
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
[quote="goldym"]Ok Will give that a try. Thanks[/quote]
I am trying to connect to Oracle Database version 8 I wonder what version of the oracle client I will need? Any ideas? |
|
| Back to top |
|
|
| goldym |
| Posted: Thu Jun 08, 2006 10:04 am Post subject: |
|
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
[quote="goldym"][quote="goldym"]Ok Will give that a try. Thanks[/quote]
I am trying to connect to Oracle Database version 8 I wonder what version of the oracle client I will need? Any ideas?[/quote]
Oracle v8 is not supported by WBIMB 5 or 6. |
|
| Back to top |
|
|
| wschutz |
| Posted: Thu Jun 08, 2006 10:24 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
|
|
