Current Position:Home > Error using JMS/AQ and Oracle9i

Error using JMS/AQ and Oracle9i

Update:11-30Source: network consolidation
Advertisement
I have managed to get a solution up and running using JMS/AQ inside the database and a servlet that consumes messages. But the database waited for 20-30 seconds before generating a response so I looked in the dump files and found:
Tue Mar 26 15:00:00 2002
Errors in file C:\oracle\admin\orcl\udump\orclS001.TRC:
ORA-00603: ORACLE server session terminated by fatal error
ORA-22303: type "SYS"."AQ$_SIG_PROP" not found
ORA-21522: attempted to use an invalid connection in OCI (object mode only)
ORA-22303: type "SYS"."AQ$_SIG_PROP" not found
ORA-21522: attempted to use an invalid connection in OCI (object mode only)
ORA-03113: end-of-file on communication channel
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3755
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_AQJMS", line 57
ORA-06512: at line 1
Tue Mar 26 15:00:15 2002
found dead shared server 'S000', pid = (8, 40)
found dead shared server 'S001', pid = (13, 34)
found dead shared server 'S002', pid = (12, 30)
Any ideas? The server uses 20-30 seconds on every SQL query when I am running my queue. I have used:
AQjmsFactory.getTopicConnectionFactory("localhost", "ORCL", 1521, "thin");
to set up the connection inside the DB. Is there another way of doing this? The code is running inside the DB.
-Christer

The Best Answer

Advertisement
I tried your suggestion but then the code fails with:
"ORA-14551 cannot perform a DML operation inside a query"
It works if I don't use the default connection. My code looks like:
try
OracleDriver ora = new OracleDriver();
//This one works
//java.sql.Connection con = DriverManager.getConnection(url, "username", "password");
//This one fails
java.sql.Connection con = ora.defaultConnection();
tconn = AQjmsTopicConnectionFactory.createTopicConnection(con);
/* Create a Topic Session */
tsess = tconn.createTopicSession(true, Session.AUTO_ACKNOWLEDGE);
tconn.start();
System.out.println ("Get the Topic...");
topic = ((AQjmsSession)tsess).getTopic("TS","tstopic") ;
System.out.println("Publish messages...") ;
publisher = tsess.createPublisher(topic);
txtmsg = tsess.createTextMessage() ;
txtmsg.setText("Alarm") ;
txtmsg.setStringProperty("alarmID", "12") ;
publisher.publish(topic, txtmsg) ;
txtmsg.clearProperties() ;
tsess.commit() ;
//tsess.close();
//tconn.close();
return "Success";
} catch (Exception e) {
System.out.println("ERROR");
e.printStackTrace();
return e.toString();
}
  • Error using JMS/AQ and Oracle9i Update:11-30

    I have managed to get a solution up and running using JMS/AQ inside the database and a servlet that consumes messages. But the database waited for 20-30 seconds before generating a response so I looked in the dump files and found: Tue Mar 26 15:00:00

  • Error in JMS Communication Channel not raising alert Update:10-11

    Processing Errors in JMS Communication Channel are not raising alerts. The settings on the communication channel retires are set at 3 and 5min interval. In RWB the JMS communication channel shows processing errors but an alert is not raised. The aler

  • Error in JMS adapter MQ to PI Update:10-11

    Hi, We are connecting to Websphere MQ using the JMS adapter. The message coming from MQ is a flat structure. So we have configured the Message Transform Bean to do the conversion from plain to xml structure according to http://wiki.sdn.sap.com/wiki/d

  • Error in JMS Input channels Update:10-11

    Dear all, We have observed a peculiar issue. Some of the JMS Input channels are throwing this error:- "Error establishing JMS connection; error message: MQJMS2005: failed to create MQQueueManager for <IP>:<QM Manager>> MQJE001: An MQEx

  • Oracle Queue Error creating JMS-120: Dequeue failed Update:11-30

    Hi Guys, We are facing serious problems with Oracle queue when dequeuing messages from the queue. Our configuration is the following: - SOA Suit 10.g (10.1.3.5.0) - Dehydration storage - Oracle Database 11gR2 in Exadata Cloud We use standard JMS Adab

  • Error starting JMS-Server Update:11-30

    I get an exception in starting OC4J (oc4j_extended_1013_dp4.zip file, version 10.1.3) java -jar oc4j.jar (SEVERE) Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig[file:/C:/oc4j_1013/j2ee/home/config/jms.xml] Er

  • ACCESS.ERROR#service.jms.default.authorization Errors Update:11-30

    Hi, With standart installation, following errors are filling defaulttrace contiuosly, any idea? #1.#0050568817F2005E000003B00000706600044473E94477A8#1201164532348#/System/Security/Audit/J2EE#sap.com/irj#com.sap.engine.services.security.roles.Security

  • Error creating a database on oracle9i Update:10-11

    I have win2k server SP2 with 30 Gb and 1.7Gb RAM. I installed oracle9i software Ok. But when I create a database an error appears in dbca (read or write error), I tried first a general purpose database, after I tried a new database with less options

  • Error in JMS adapter 11g Update:10-11

    Hi I have configured a JMS Adapter in Jdev 11.1.1.3.0 to consume message from a queue(JNDI Name as eis/wljms/WLQueue) on a weblogic server(10.3.1) in a different domain and deployed my BPM process to the soa server 11g. I created a new outbound conne

  • Error in JMS Adapter Configuration. Update:10-11

    Hi, Its regarding JMS receiver adapter for MQ Series. We  have MQ 6.0 installed on PI server. While trying to connect thorough JMS receiver adapter we are getting a connection failure error at communication channel level. The MQ administrator is of t