| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Error while querying Oracle DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| kash3338 |
 Posted: Tue Dec 28, 2010 7:31 am Post subject: Error while querying Oracle DB |
 |
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
Hi,
I am trying to fetch few values from Oracle DB through my ESQL code.
When i deployed the BAR file and test for the first time it works fine. When i try to test again i get an error stating "Unresolved SQL Datatype "-9" not supported by Broker".
This is a strange behaviour as the results are fetched the first time after i deploy the BAR file.
My ESQL statement is something like,
SET Environment.Variable.QueueNames[] = PASSTRU('SELECT VALUE1, VALUE2 FROM <TABLENAME> WHERE <CONDITION = ?>', cChar); |
|
| Back to top |
|
 |
| kash3338 |
| Posted: Wed Dec 29, 2010 8:05 am Post subject: |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| Is there any ideas for this issue? We are still stuck with this.. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Dec 29, 2010 8:49 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kash3338 wrote: |
| Is there any ideas for this issue? We are still stuck with this.. |
Doesn't look much like it, though I imagine a number of regular posters are enjoying a seasonal break.
Time for a PMR?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| gunjand |
| Posted: Thu Dec 30, 2010 1:45 pm Post subject: |
|
|
Novice
Joined: 21 May 2009
Posts: 23
|
Hi,
Probably PMR is one option.
Is it the same case for simple select query also forget about where condition or all stuff? Just getting one value.
Is it also that it works every first time you deploy your bar?
I hope you would have tried all possible options. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
