| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle Database not getting updated |
« View previous topic :: View next topic » |
| Author |
Message
|
| next |
 Posted: Sun May 02, 2010 4:08 am Post subject: Oracle Database not getting updated |
 |
|
Voyager
Joined: 02 May 2010
Posts: 75
|
Hi ,
I am using oracle 10g Enterprise Edition Release 10.2.0.3.0 database with message broker 6.0.
I have configured the datasource in .odbc.ini file and created TNS names in tnsnames.ora file. I have set the username and password for the datasource using mqsisetdbparms.
When i try to insert data into a table, it is not throwing any error. But it is not inserting either.
But it throws errors on constraint violations.
Could anybody tell me how to troubleshoot this.
Regards,
Suresh. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Sun May 02, 2010 4:15 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi next,
Check the primary keys of the table...see if the record you are inserting has the same values as that already existing in the table for those primary key columns.
Regards. |
|
| Back to top |
|
|
| next |
| Posted: Sun May 02, 2010 4:25 am Post subject: |
|
|
Voyager
Joined: 02 May 2010
Posts: 75
|
Hi Padawan,
Actually, the problem is, broker is able to throw exceptions on the constraints. But it is not able to insert select or update the table.
It is not about the values.
Regards,
Suresh. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Sun May 02, 2010 5:04 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi next,
| next wrote: |
Actually, the problem is, broker is able to throw exceptions on the constraints. But it is not able to insert select or update the table.
It is not about the values. |
Why don't you let us decide for ourselves. Paste the esql insert statement, the error thats being thrown, and the output of the describe statement run on your oracle table.
Regards. |
|
| Back to top |
|
|
| vikashsharma85 |
| Posted: Sun May 02, 2010 9:32 pm Post subject: |
|
|
Novice
Joined: 19 Mar 2010
Posts: 15
|
| Can u please check the transactionality of your message flow. Is your flow completing the success full processing? |
|
| 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
|
|
|
|
