Mailing-List: contact dev-help@harmony.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@harmony.apache.org
Received-SPF: pass (athena.apache.org: domain of
 christian.peter.io@googlemail.com designates 209.85.220.212 as permitted
 sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=subject:from:to:content-type:date:message-id:mime-version:x-mailer;
        b=WQbtQBOq0ecG6n/d+nM2z68UHa8RLyvWh8ySw4iMva/ceaadcZNBe1kQ2swT2pUp8X
         E0bs2FEO2iOFSJ1GvKhJoRz+0Kf+qI7OQOIduDa91A9BExw8D9iiqlCll+WAV9XHJXp5
         1arz/KX1nL8vfW9HGyP21Jw3YoOIpdKxDcZoE=
Subject: Harmony H2 errors
From: Christian Peter <christian.peter.io@googlemail.com>
To: dev@harmony.apache.org
Content-Type: multipart/mixed; boundary="=-clfPvm6mg7AAghV4GsMi"
Date: Mon, 29 Mar 2010 18:32:06 +0200
Message-ID: <1269880326.20923.16.camel@else.charlysworld.de>
Mime-Version: 1.0

--=-clfPvm6mg7AAghV4GsMi
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Hi list,

I regularly read the Harmony development archives, and there was a post
about Dacapo benchmarks with the H2 database. I also tested some of my
applications against Harmony, and I have problems with H2. I narrowed it
down to a small testcase. RI works fine, Harmony doesn't work (on Fedora
12, all Updates). This is on 32 bit, 64 bit seems to be Ok.

Just use the attached file and the jar file found in
http://www.h2database.com/h2-2010-03-21.zip and let it run.

Regards

Christian Peter

--=-clfPvm6mg7AAghV4GsMi
Content-Disposition: attachment; filename="Simple.java"
Content-Type: text/x-java; name="Simple.java"; charset="UTF-8"
Content-Transfer-Encoding: 7bit

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class Simple {

    public static void main(String... args) {
        try {
            System.out.println(Runtime.getRuntime().maxMemory());
            Class.forName("org.h2.Driver");
            String url = "jdbc:h2:data;CACHE_SIZE=10000";
            Connection conn = DriverManager.getConnection(url);
            Statement stat = conn.createStatement();
            stat.execute("drop table account if exists");
            stat.execute("create table account(name varchar primary key)");
            PreparedStatement prep = conn.prepareStatement("insert into account(name) values(?)");
            
            for (int i = 0; i < 90000; i++) {
                prep.setString(1, "Test" + i);
                prep.execute();
            }
            
            conn.close();
        } catch (Throwable t) {
            t.printStackTrace();
        }
    }
    
}

--=-clfPvm6mg7AAghV4GsMi--