| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Database Exception Error |
« View previous topic :: View next topic » |
| Author |
Message
|
| JT |
 Posted: Wed Aug 16, 2006 3:01 pm Post subject: |
 |
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Post the Insert statement. |
|
| Back to top |
|
 |
| manojsu |
| Posted: Sun Aug 20, 2006 9:07 pm Post subject: |
|
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
This is the insert statement..
INSERT INTO Database.{K_DATABASE_SCHEMA}.SUBSCRIPTIONS
(CONSUMER_REFERENCE,
CORRELID,
TOPIC_EXPRESSION,
USE_RAW,
STATUS )
VALUES
(subscribeIRef.consumerReference.address,
correlidC,
subscribeIRef.filter.topicExpression,
useRaw,
status); |
|
| Back to top |
|
|
| JT |
| Posted: Sun Aug 20, 2006 9:38 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Are you absolutely sure the K_DATABASE_SCHEMA variable contains the value you think it should? |
|
| Back to top |
|
|
| manojsu |
| Posted: Sun Aug 20, 2006 9:55 pm Post subject: |
|
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
Yes, but not very confident..
But since its wrt to oracle database, i tried insertion without the SCHEMA name, cos the user is the schema wrt oracle..
still not able to do any thing |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Aug 20, 2006 10:56 pm Post subject: Just to be sure |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Can you check that the node doing the insert has its properties correctly set.
If you don't set (or incorrectly set) the connection in the Compute/Filter/etc node then you can get this sort of problem.
Secondly, if this is a different ODBC DSN than you are using for the broker database, check that the params you used in the mqsisetdbparms are also correct
For example
mqsisetdbparms SKY101 -n REPORTING -u RepoUser -p RepoMan
You need the following to all match
- The ESQL
- The ODBC DSN in the node properties
- The mqsisetdbparms parameters
- The SYSTEM DSN ODBC Definition.
Without ALL FOUR having the correct definitons then it just won't work.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| manojsu |
| Posted: Mon Aug 21, 2006 12:07 am Post subject: |
|
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
| Yes, I have set the properties(Datasource = DSN),and also done addition of it in bar file |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
