| Author |
Message
|
| catwood2 |
 Posted: Tue Mar 02, 2004 11:40 am Post subject: Java-Oracle-mQ |
 |
|
Centurion
Joined: 17 May 2002
Posts: 108
|
Hoping someone can provide a pointer:
Anybody have an issue with MQ Connect call to the QMgr (2059) after dropping and loading Oracle database schema?
Db details:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
The Java is run as a procedure inside the database.
We have tested to confirm the error is definitely a result of the database schema activity....just not sure what to do next/how to fix.
thx |
|
| Back to top |
|
 |
| vennela |
| Posted: Tue Mar 02, 2004 12:07 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Is the listener running ? The listener on the QMGR you are trying to connect to might not be running. |
|
| Back to top |
|
|
| catwood2 |
| Posted: Tue Mar 02, 2004 12:42 pm Post subject: |
|
|
Centurion
Joined: 17 May 2002
Posts: 108
|
Vennela-
Yes. In fact, we are able to connect via mq explorer, rfhutil client, and a home grown utility written in C.
We have now reproduced this on multiple servers. Prior to drop and loading of schema - mq calls fine. After drop and load - error 2059 (altho trace files indicate correct qmgr parameters on get call).
We have also dropped the java on a working instance and reloaded to confirm that we are loading good source.
Any thoughts appreciated. |
|
| Back to top |
|
|
| catwood2 |
| Posted: Tue Mar 02, 2004 1:03 pm Post subject: |
|
|
Centurion
Joined: 17 May 2002
Posts: 108
|
Additional logging in oracle trace logs:
java.sql.SQLException: no such java schema object
at oracle.aurora.rdbms.ExportSchemaObjects.copy(ExportSchemaObjects.java)
at oracle.aurora.rdbms.ExportSchemaObjects.exportSource(ExportSchemaObjects.java)
java.sql.SQLException: no such java schema object
at oracle.aurora.rdbms.ExportSchemaObjects.copy(ExportSchemaObjects.java)
at oracle.aurora.rdbms.ExportSchemaObjects.exportSource(ExportSchemaObjects.java) |
|
| Back to top |
|
|
| r2504 |
| Posted: Fri Mar 05, 2004 2:22 am Post subject: Re: Java-Oracle-mQ |
|
|
Novice
Joined: 05 Mar 2004
Posts: 22
|
| catwood2 wrote: |
The Java is run as a procedure inside the database.
|
Do you mean you've loaded com.ibm.mq.jar into Oracle ?
May I ask you which version of MQ... for us it works fine with V5R2, but I can't load the V5R3 version of com.ibm.mq.jar into Oracle anymore. (see other thread). |
|
| Back to top |
|
|
| catwood2 |
| Posted: Fri Mar 05, 2004 5:04 am Post subject: |
|
|
Centurion
Joined: 17 May 2002
Posts: 108
|
MQ 5.2. and yes, the com.ibm.mq.jar
This issue was resolved late yesterday - too exhausted from "needle in a haystacking" with this one. Here's the upshot:
During the import process, the db user roles defined for the ID that the process runs under was altered (java privilages dropped). When we restored the privilages - functionality restored. It is unclear whether this is a bug in the Oracle import utility that the dba used....or whether we were unaware of this aspect of using the utility. That verdict should be in today as Oracle was working on this as a Sev1 for a couple days. I'll post that verdict. |
|
| Back to top |
|
|
| r2504 |
| Posted: Fri Mar 05, 2004 5:10 am Post subject: |
|
|
Novice
Joined: 05 Mar 2004
Posts: 22
|
|
| Back to top |
|
|
|
|
