| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| error with insert-statement |
« View previous topic :: View next topic » |
| Author |
Message
|
| ronq |
 Posted: Mon Apr 07, 2003 2:18 am Post subject: error with insert-statement |
 |
|
Newbie
Joined: 03 Apr 2003
Posts: 8
|
Hi,
I'm using WMQI2.1 CSD4 on AIX4.3.3. The broker-database is oracle 8.1.7.
I want insert the original income message into the database (also oracle). The incoming message is from type blob. Before inserting the msg, i convert it into a character (the string includes carriage return, line feed).
The first msg is less than 1kB and the insert works fine. But the following (2nd) msg is more than 3kB and the insert throws an sql-exception:
| Code: |
DatabaseException BIP2322E: Database error: SQL State 'HY000'; Native Error Code '0'; Error Text '[MERANT][ODBC Oracle 8 driver]Data type for parameter 2 has changed since first SQLExecute call.'.
The error has the following diagnostic information: SQL State 'HY000' SQL Native Error Code '0' SQL Error Text '[MERANT][ODBC Oracle 8 driver]Data type for parameter 2 has changed since first SQLExecute call.'
|
If the incoming msg's are less than 1kB, every call from the insert-statement works fine.
SQL-Statement:
| Code: |
PASSTHRU('INSERT INTO SITA.T_SITA_ORG_MSG(msg_id,org_msg_body,
org_msg_timestamp) values(?,?,sysdate)',
org_msg_id,
CAST(BITSTREAM(InputBody) AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId ENCODING InputRoot.MQMD.Encoding)' |
Has anyone an idea? Could this problem result from implicit cast (from WMQI data-type to sql data-type)?
_________________
RonQ |
|
| Back to top |
|
 |
| danielaphex |
| Posted: Tue Apr 08, 2003 12:39 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2003
Posts: 28
|
Hi rong,
I had exactly the same problem not a long time ago.
I think you should modify the odbc.ini file in the AIX server machine including the following parameters in the part related to the Database you are using for.
The values I would put would be:
[YOUR DATABASE]
You should include:
WorkArounds=536870912
WorkArounds2=2
I hope this could help.
Cheers, |
|
| Back to top |
|
|
| ronq |
| Posted: Tue Apr 08, 2003 1:42 am Post subject: error insert-statement |
|
|
Newbie
Joined: 03 Apr 2003
Posts: 8
|
Hi danielaphex,
after restarting the msqi-broker it worked.
Thanks a lot.
But what do the parameters mean?
_________________
RonQ |
|
| Back to top |
|
|
| danielaphex |
| Posted: Tue Apr 08, 2003 6:40 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2003
Posts: 28
|
It is used to avoid problems when the ODBC driver re-binds parameters with a different scale, precision, or sqltype of which you have in your own Database.
I am very glad this advise could help you
Take care |
|
| 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
|
|
|
|
