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
Testing jdbc Oracle Connection from Datastage
Moderators: chulett, rschirm, roy
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).
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).
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne