| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBI + Oracle9i + DataDirect |
« View previous topic :: View next topic » |
| Author |
Message
|
| fmv0202 |
 Posted: Wed Feb 07, 2007 7:23 am Post subject: WBI + Oracle9i + DataDirect |
 |
|
Apprentice
Joined: 13 Dec 2006
Posts: 28
|
Hello Everybody, I'm currently trying to connect to an oracle 9i db running on red hat linux from an IBM AIX server. The version information is listed below.
Versions:
---------
Oracle: 9.2.0.7 (Intel on Linux)
Data Direct 5.0 Driver ivora20.so (AIX)
WBIMB: 5.0.2 (CSD02)
Plattform: IBM 5.2.0.0
When I attempt to run the query, I'm getting an unsupported SQL type error.
| Code: |
(0x03000000):Text = 'The following error occurred during ex
ecution of an SQL statement'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2519
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.WEBOE_REPLY_UpdateDB.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '46.37'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'db'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'SELECT '<MERGED_MSG>' ||SUBSTR(ORIGINAL_MSG, INST
R(ORIGINAL_MSG,'<Request_Message>'), 999999) ||SUBSTR(RESPONSE_MSG, INSTR(RESPON
SE_MSG,'<Reply_Message>'), 999999) ||'</MERGED_MSG>' "Merged_Msg" FROM DB_TABLE
_TRAIL WHERE MESSAGE_ID = '739c8f01:11097c9e592:-7f3b''
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = ''
)
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S500_P/src/DataFlowEngine/ImbOdbc.cpp(
0x03000000):Line = 2423
(0x03000000):Function = 'ImbOdbcDynamicResultSet::initialise'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'Unsupported SQL type'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2324
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'Merged_Msg'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-10'
|
So here are my questions, what does the -10 error indicate? Where should I look to further analyze this problem?
Much Appreciated!!
 |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Feb 07, 2007 7:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| fmv0202 |
| Posted: Wed Feb 07, 2007 10:00 am Post subject: |
|
|
Apprentice
Joined: 13 Dec 2006
Posts: 28
|
Thanks Agian Jeff.
We are actually moving off the broker this year however we are planning to upgrade to FP5 before retire the apps. Speaking of FP5, how was the migration? |
|
| Back to top |
|
|
| fmv0202 |
| Posted: Sun Feb 11, 2007 2:27 pm Post subject: |
|
|
Apprentice
Joined: 13 Dec 2006
Posts: 28
|
Hello Agian,
I seem to be running into trouble with the syntax. I'm using passthru statement and attempting to return a CLOB datatype. As stated before, The WBI toolkit, doesn't seem to support this datatype for the typical query. So, is there a way that I can fool or wrap the toolkit into something that would be interpreted correctly?
I noted that character appears to be the internal type compatible with the CLOB oracle datatype. So can I cast a passthru as a character or something like this?
SET Environment.Message[] = ....... ?
I'm forced into using passthru because the query has backend functions within it. Another note, the clob appears to return a LIST, not a scalar datatype. Any thoughts out there?
 |
|
| 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
|
|
|
|
