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.
