Hi Andy, Before you embark on that, can I ask you to have a look at the current org.jboss.mail.store implemenation (the old one will suffice, but it will be updated this weekend). I went through most of the pain of using the MySQL emulated locators when I had my very first attempts at implementing the store. In fact the Blob[Input/Output]Stream classes were written to solve this very problem.
Also MySQL blobs are very buggy, see this thread: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=59236 Apparently they have fixed Bug 8096, but haven't indicated which release it will be in. Also they suck when it comes to performance. Try loading a 128MB blob in 1MB pieces and watch the MySQL process eat itself (takes around 15 minutes). From the work I have done so far it looks like most of the problems are not so much with the JDBC driver by the database. I should really get on the mailing list and bitch a little louder about blob support. Regards, Mike. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3868927#3868927 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3868927 ------------------------------------------------------- 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://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development