| Author |
Message
|
| mzm.shan |
 Posted: Wed Oct 23, 2013 3:32 am Post subject: DATABASE RETRIEVE NODE WITH JDBC |
 |
|
Apprentice
Joined: 25 Aug 2013
Posts: 39
|
http://www.mqseries.net/phpBB2/viewtopic.php?p=348089&sid=e1539bfac166cb102bc5005ac9a58a8d
hi guys,
i am getting a similar kind of issue as given above. as it was a very old post so i am posting my problem as a new question.......
i have created JDBC Provided written in the way "Creating a JDBC provider entry for an Oracle database" guided. and also Made a Database Definition from File>New>Definition and it was successfully tested. Also, i have added .dbm to my project so that my flows can refer to that definition. still.... i am not able to access this DB definition in Database Retrieve node. it never fill the Table Name dropdown list when i try to ADD Query Elements in the properties of DB Retrieve node.
i am using IIB v9 on windows7.
Please HELP! |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Oct 23, 2013 5:38 am Post subject: Re: DATABASE RETRIEVE NODE WITH JDBC |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mzm.shan wrote: |
| it was successfully tested. |
Tested how? Both on the Toolkit and on the runtime server?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mzm.shan |
| Posted: Wed Oct 23, 2013 7:44 am Post subject: |
|
|
Apprentice
Joined: 25 Aug 2013
Posts: 39
|
| i mean while making Database Definition through wizard it picks the connection which i made through "mqsicreateconfigurableservice" and when i gave UID and PWD it says connection successful. Also, i can see my tables/views/routines in Data Explorer too.. |
|
| Back to top |
|
|
| mzm.shan |
| Posted: Thu Oct 24, 2013 2:24 am Post subject: |
|
|
Apprentice
Joined: 25 Aug 2013
Posts: 39
|
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Oct 24, 2013 5:07 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mzm.shan wrote: |
| Geeks any help? |
You'll get more help if you don't call us "geeks" and remember that people who participate here have day jobs & post as time permits & the charity of their hearts dictates. 
And no, I can't help. The testing you've described sounds fine.
If you want better or faster help, you have the option of a PMR.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mzm.shan |
| Posted: Thu Oct 24, 2013 7:53 am Post subject: |
|
|
Apprentice
Joined: 25 Aug 2013
Posts: 39
|
I am sory if you feel bad by any of my word.
I totally understand the people and their commitments who are participation here and on other professional forums. But i know there could be better ways to response.
Any ways thanks for your suggestion of PMR. |
|
| Back to top |
|
|
|
|
