Hi, I forgot to say: this is fixed now (I think even with 1.4.182).
Regards, Thomas On Friday, November 21, 2014, Thomas Mueller <[email protected]> wrote: > Hi, > > Further simplified (in case you are interested): > > public static void main(String... args) throws Exception { > final String url = "jdbc:h2:mem:test"; > Connection conn = DriverManager.getConnection(url); > Statement stat = conn.createStatement(); > stat.execute("create table lob(id identity, lob blob)"); > stat.execute("insert into lob(id, lob) values(null, '')"); > Thread[] threads = new Thread[3]; > final AtomicBoolean stop = new AtomicBoolean(); > for (int i = 0; i < threads.length; i++) { > Thread t = new Thread() { > @Override > public void run() { > try { > Connection conn = DriverManager.getConnection(url); > PreparedStatement prep = conn.prepareStatement( > "update lob set lob=? where id=1"); > Statement stat = conn.createStatement(); > while (!stop.get()) { > prep.setBinaryStream(1, > new ByteArrayInputStream(new > byte[10])); > prep.executeUpdate(); > ResultSet rs = stat.executeQuery( > "select lob from lob where id=1"); > rs.next(); > rs.getBlob(1).getBinaryStream().read(); > } > conn.close(); > } catch (Exception e) { > e.printStackTrace(); > } > } > }; > t.start(); > threads[i] = t; > } > Thread.sleep(100000); > stop.set(true); > for (Thread t : threads) { > t.join(); > } > conn.close(); > } > > > Regards, > Thomas > > > On Thu, Nov 20, 2014 at 6:47 PM, Thomas Mueller < > [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> Hi, >> >> I can now reproduce the problem, using the following test case. Thanks a >> lot! >> >> http://h2database.com/p.html#88f131803abed52292b7a80c33631624 >> >> Regards, >> Thomas >> >> >> On Thursday, November 20, 2014, Benedikt Waldvogel <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >> >>> Hi, >>> >>> On Wed, November 19, 2014 10:25, Thomas Mueller wrote: >>> > To avoid having to change the test case, could you add >>> > ";trace_level_system_out=3" to the database URL, and then send me / >>> post >>> > the resulting output? This should include all the JDBC API calls. That >>> way >>> > it should be quite easy to write a pure JDBC test case. Or append >>> > ";trace_level_file=3" and then send the <databaseName>.trace.db file. >>> >>> please find a trace on https://paste.ee/p/Ri7xi >>> >>> Let me know when you need more info. >>> >>> >>> Best, >>> Benedikt >>> >>> -- >>> 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.
