This is because Oracle JDBC driver is not JDBC conformant. Or they want to teach us all how to live. They believe, that using statement.setInputStream(), like jdbc2.PersistenceManager does, is not efficient enough to use, so they limited it to 4kb (actually this is because they passing BLOB as a RAW datatype, because for smaller lengths it is more efficient to include it in row data, which is limited since beginning of time in Oracle to 4k). For larger lengths they force us to use their non standard and crappy oracle.sql.BLOB extension.
So i just written my own patched version of jdbc2.PersistenceManager to use this Oracle's BLOBs extension, which is available here: http://core.swdfactory.com/~oleg/jbossmq-orapm.zip Please keep in mind - it works only with oracle database using Oracle JDBC drivers, developed by Oracle. You can use this freely, but on your own risk. 8-) View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3857524#3857524 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3857524 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
