Kbase 20670: Problem Using Oracle OCI Driver with SonicMQ
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/28/2008 |
|
Status: Verified
SYMPTOM(s):
Problem using the Oracle OCI driver with the default Orasvr8_jdbc.cfg file that is shipped with SonicMQ.
Attempting to restart a broker where there are messages stored in the Oracle database, you will receive the following exception in the broker:
java.io.EOFException
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.io.IOException.<init>(IOException.java:35)
at java.io.EOFException.<init>(EOFException.java:43)
at progress.message.util.server.ByteBufferInputStream.readInt(Compiled
Code)
at progress.message.zclient.Mgram.unserialize(Compiled Code)
at
progress.message.broker.BrokerDatabase.getQMgram(BrokerDatabase.java:4805)
at
progress.message.broker.QueueMsgSaver.retrieveMgram(QueueMsgSaver.java:317)
at progress.message.broker.EnhancedPriorityQueue.restore(Compiled Code)
at progress.message.broker.AgentQueue.FS_(Compiled Code)
at progress.message.broker.AgentQueueProcessor.Yt_(Compiled Code)
at
progress.message.broker.AgentRegistrar.startup(AgentRegistrar.java:716)
at progress.message.broker.Broker.<init>(Compiled Code)
at progress.message.broker.Broker.main(Compiled Code)
FIX:
This solution applies to SonicMQ Version 3.0.x It describes a configuration change necessary to use the Oracle OCI driver when using an Oracle database as the message server's data store.
In order to use the Oracle OCI driver, in the file <SonicMQ 3.0 install dir>\orasvr8_jdbc.cfg, you must change the setting of the DB_SETBYTES parameter from TRUE to FALSE.
Although SonicMQ 3.0 was not certified with the Oracle OCI driver on its commercial release, it has since been tested with versions 8.1.5 through 8.1.7 of the Oracle OCI driver, and has been found to work with the configuration change described above.
References to Written Documentation:
SonicMQ 3.0 Installation Configuration & Administration Guide, Chapter 1, Installation, "Database Options"