Testing jdbc Oracle Connection from Datastage

[mandyli]

Hi

I would like to test the jdbc connection from Datastage server.
I tired following way but no luck.

$ java utils.dbping ORACLE scott tiger

Is there any way I can able to test ORACLE jdbc connection via Datastage unix server?

Thanks
Man

[lstsaur]

No, there is no testing facility to test JDBC from DS server. However, there is a place that you can create the JDBC Data Source to test the JDBC connection in the Websphere App. Server (the one used as a part of DS installation). Login the Webspere Admin Console-->Resources-->JDBC Providers to create the JDBC Data Source. After you have filled out all required info, then you will get a test bottom to test the JDBC connection. It will tell you whether the JDBC is successfully connected to the DB or not.
Is that what you want to do? Test the JDBC connection only. Or actually you want to know which Stage can use the JDBC instead of ODBC.
From DS environment, Java stage can use the JDBC connection to connect to the DB instead of ODBC, Web Service job (if there is DB look up involved).

[stuartjvnorton]

Go into one of the source stages in a parallel job and once you have put the details in, try the Test and View Data functions. IIRC they use JDBC, and have to go via the server.

[mandyli]

Thanks Lot.

what you mean IIRC stage ?

I am using DS 8.7.

Thanks
Man

[ArndW]

"IIRC" -> If I Recall Correctly

[mandyli]

Thanks Lot.

Sorry I know that "IIRC" -> If I Recall Correctly But I thought IIRC means is there any new stages on Datastage. That's why I bit confused.

Thanks for correction.


Thanks
Man

[mandyli]

I have fixed this issue.

I have copied latest ojdbc.jar from ORACLE /lib path and then it works fine.


Thanks