JMS Object Message and Oracle AQ

57806

Hi,

I want to be able to send messages from Java to Oracle AQ. I tried using JMS for this, but get the following error --

oracle.jms.AQjmsException: JMS-108: Messages of type ObjectMessage not allowed with Destinations containing payload of type (Oracle Type object) I am setting the object to a model object that implements Serializable.

Two of the fields in the object are defined as Clob in the database. Earlier I have been able to send Strings for Clob. But now I get --

Fail to convert to internal representation

Any idea what could be causing this?

I was able to implement this using AQMessage mentioned elsewhere on the site. I am able to send 100 messages in about 50 seconds by this approach. This is too slow for us to use in production environment.

I would appreciate any help on this.

Thanks,
Swati

962508

hi,

I've been trying out the same thing. One way which i thought (i haven't tried it yet) is to use Oracle type objects itself and then implement STRUCTS,Arraydescriptor to fetch each attribute of the oracle type.

If anyone out there has better solution then pls do share.