how to save text of the message to JMS_MESSAGES table

[hquang]

hi forum member,

Anyone of you have any idea to save text of the message to JMS_MESSAGES table in oracle database?

The reason why I need it is because, JMS save message in MESSAGEBLOB field which is BLOB data type. The question is my messge is in text and I want to view my message in database.

I am using JMS, database oracle.

Your help on this matter will be highly appreciated.

Regards,
Quang

[genman]

It's because the message is stored as a serialized java object. You'd have to create your own persistence manager to save the text as its own column. This isn't too difficult.

[hquang]

hi genman,

Thanks for your reply. You are right, the msg is stored as s srerialized obj.

Very much appreciated if you could tell me how to create my own persistence manager to save the text.

Thank you.

Best Regards,
Quang