Thanks you very much Thomas. I have no access to a dev environment for the next 2 weeks but I have no doubt you solved my problem. Big THANK YOU !
On Tuesday, August 4, 2015 at 7:45:34 AM UTC+2, Thomas Mueller wrote: > > Hi, > > This should be fixed in version 1.4.188. > > Regards, > Thomas > > > On Thursday, July 23, 2015, Francois Marot <[email protected] > <javascript:>> wrote: > >> Just a few additions. >> >> - I've updated the sample code to: >> - show the problematic behaviour by default instead of the working >> one >> - not require the Lombok library installed in Eclipse so that >> anybody without lombok lib can use his own IDE >> - When I say "the client either becomes stuck in executeUpdate() or >> waits forever", I meant "the client either becomes stuck in >> executeUpdate() >> or exits with connection reset". >> >> >> On Wednesday, July 22, 2015 at 9:06:06 PM UTC+2, Francois Marot wrote: >>> >>> Hello all, >>> >>> I face a problem here with H2. >>> This is reproducible on a few version from 2012 to the latest. >>> When run *in server mode* and storing a large BLOB, the client either >>> becomes stuck in executeUpdate() or waits forever. Depending on the content >>> of the file being sent. >>> It happens only with files nearing 2GB or larger. >>> The problem does NOT happen in embedded mode. >>> >>> I have set up a sample project on github showcasing the problem: >>> https://github.com/fmarot/h2tests >>> >>> Here is the part of my code but I doubt it will teach you anything: >>> >>> try (PreparedStatement pstmt = >>> connection.prepareStatement("INSERT INTO FILES(OID, DATA, >>> FILENAME) VALUES (" 1 + ", ?, '" + filename + "')"); >>> InputStream is = new BufferedInputStream(new >>> FileInputStream(myLargeFile))) { >>> pstmt.setBinaryStream(1, is); >>> pstmt.executeUpdate(); // H2 is stuck here for large >>> files (or exit with connection reset, depending on the content of the file) >>> } >>> >>> Any idea or leads to debug myself are welcome! >>> >>> Wish you the best, >>> Francois >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
