Thanks Adrain! 1. I replaced it with:
DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP=? 2. also reduced the DESTINATION VARCHAR(250) to VARCHAR(190) 3. and change BLOB_TYPE=BINARYSTREAM_BLOB. It worked now for jdbc2 PM. I also tested firebird with jdbc3 PM and it worked too. thanks again! <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826215#3826215";>View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826215>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
