Author |
Message |
Topic: Best way to update DB record? |
spahrson
Replies: 6 Views: 3184
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Feb 17, 2013 11:10 pm Subject: stored procedures |
I recognize the benefit using stored procedures. There are two disadvantages for us:
1) Each message has to be sent to the database over the network (within a clustered environment) regardless whet ... |
Topic: Best way to update DB record? |
spahrson
Replies: 6 Views: 3184
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 08, 2013 12:19 am Subject: Best way to update DB record? |
Hi all,
I need some advice.
I have to update (medium large) messages as fast as possible into a Oracle Database. The Problem, there are a lot of nested tables.
What's your suggestion to do th ... |
Topic: WMB<->ORA DB Session Handling |
spahrson
Replies: 1 Views: 2174
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 25, 2012 1:23 am Subject: WMB<->ORA DB Session Handling |
Hi all,
I have a broker application connected to an oracle mts environment with odbc. I use the data direct odbc driver. Now I have noticed that it is important how I scale the application. Eg. if ... |
Topic: Problems with Broker 7, Oracle 11g and CLOB Datatype... |
spahrson
Replies: 8 Views: 13575
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 24, 2011 12:54 am Subject: Problems with Broker 7, Oracle 11g and CLOB Datatype... |
we'll raise a pmr...  |
Topic: Problems with Broker 7, Oracle 11g and CLOB Datatype... |
spahrson
Replies: 8 Views: 13575
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 18, 2011 2:17 am Subject: Problems with Broker 7, Oracle 11g and CLOB Datatype... |
The ESQL data type is CHARACTER.
In InfoCenter I found the following under Supported databases->ODBC support->Notes
5:Each broker system requires only the Client SDK; install the Dynam ... |
Topic: Problems with Broker 7, Oracle 11g and CLOB Datatype... |
spahrson
Replies: 8 Views: 13575
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 18, 2011 2:07 am Subject: Problems with Broker 7, Oracle 11g and CLOB Datatype... |
Hi.
i tried to insert a CLOB in Oracle 11g over
- 1: INSERT Statement
- 2: PASSTROUGH INSERT Statement
- 3: EXTERNAL PROCEDURE / STORED PROCEDURE
- 4: PASSTROUGH STORED PROCEDURE CALL
We u ... |