Author: echatellier Date: 2015-01-30 09:26:49 +0000 (Fri, 30 Jan 2015) New Revision: 749 Url: http://forge.nuiton.org/projects/sandbox/repository/revisions/749 Log: Initial import. Added: h2j8test/data-backup.sql.gz h2j8test/pom.xml h2j8test/src/ h2j8test/src/main/ h2j8test/src/main/java/ h2j8test/src/main/java/org/ h2j8test/src/main/java/org/test/ h2j8test/src/main/java/org/test/H2J8Test.java h2j8test/src/main/resources/ h2j8test/src/main/resources/log4j.properties h2j8test/src/test/ h2j8test/src/test/java/ Added: h2j8test/data-backup.sql.gz =================================================================== (Binary files differ) Property changes on: h2j8test/data-backup.sql.gz ___________________________________________________________________ Added: svn:mime-type + application/x-gzip Added: h2j8test/pom.xml =================================================================== --- h2j8test/pom.xml (rev 0) +++ h2j8test/pom.xml 2015-01-30 09:26:49 UTC (rev 749) @@ -0,0 +1,20 @@ +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> + <modelVersion>4.0.0</modelVersion> + <groupId>org.test</groupId> + <artifactId>h2j8test</artifactId> + <version>0.0.1-SNAPSHOT</version> + + <dependencies> + <dependency> + <groupId>com.h2database</groupId> + <artifactId>h2</artifactId> + <version>1.4.185</version> + </dependency> + <dependency> + <groupId>junit</groupId> + <artifactId>junit</artifactId> + <version>4.12</version> + <scope>test</scope> + </dependency> + </dependencies> +</project> Property changes on: h2j8test/pom.xml ___________________________________________________________________ Added: svn:mime-type + text/xml Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Added: h2j8test/src/main/java/org/test/H2J8Test.java =================================================================== --- h2j8test/src/main/java/org/test/H2J8Test.java (rev 0) +++ h2j8test/src/main/java/org/test/H2J8Test.java 2015-01-30 09:26:49 UTC (rev 749) @@ -0,0 +1,78 @@ +package org.test; + +import java.io.File; +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.ResultSet; +import java.sql.Statement; + +public class H2J8Test { + + + public static void main(String[] args) throws Exception { + Class.forName("org.h2.Driver"); + + final File f = createDb(); + Thread t = new Thread() { + public void run() { + try { + restoreDb(f); + } catch (Exception e) { + e.printStackTrace(); + } + }; + }; + t.run(); + t.join(); + } + + private static File createDb() throws Exception { + + Connection conn = DriverManager.getConnection("jdbc:h2:./test_" + System.currentTimeMillis()); + Statement stat = conn.createStatement(); + + // this line would initialize the database + // from the SQL script file 'init.sql' + // stat.execute("runscript from 'init.sql'"); + + stat.execute("create table test(id int primary key, name varchar(255))"); + stat.execute("insert into test values(1, 'Hello')"); + ResultSet rs; + rs = stat.executeQuery("select * from test"); + while (rs.next()) { + System.out.println("test1:" + rs.getString("name")); + } + stat.close(); + + // extract + Statement stat2 = conn.createStatement(); + File file = File.createTempFile("h2test-", ".sql"); + stat2.execute("SCRIPT TO '" + file.getAbsolutePath() + "'"); + + //conn.close(); + + return file; + } + + private static void restoreDb(File file) throws Exception { + + Connection conn = DriverManager.getConnection("jdbc:h2:./test2_" + System.currentTimeMillis()); + + Statement stat = conn.createStatement(); + + //stat.execute("RUNSCRIPT FROM '" + file.getAbsolutePath() + "' COMPRESSION GZIP"); + stat.execute("RUNSCRIPT FROM '" + file.getAbsolutePath() + "'"); + //stat.close(); + + // test list + Statement stat2 = conn.createStatement(); + ResultSet rs; + rs = stat2.executeQuery("select * from fisheryregion"); + while (rs.next()) { + System.out.println("test2:" + rs.getString("name")); + } + stat.close(); + + conn.close(); + } +} Property changes on: h2j8test/src/main/java/org/test/H2J8Test.java ___________________________________________________________________ Added: svn:eol-style + native Added: svn:keywords + Author Date Id Revision HeadURL Added: h2j8test/src/main/resources/log4j.properties =================================================================== --- h2j8test/src/main/resources/log4j.properties (rev 0) +++ h2j8test/src/main/resources/log4j.properties 2015-01-30 09:26:49 UTC (rev 749) @@ -0,0 +1,7 @@ +# Global logging configuration +log4j.rootLogger=ERROR, stdout + +# Console output +log4j.appender.stdout=org.apache.log4j.ConsoleAppender +log4j.appender.stdout.layout=org.apache.log4j.PatternLayout +log4j.appender.stdout.layout.ConversionPattern=%d{HH:mm:ss} %-5p %c:%L - %m%n Property changes on: h2j8test/src/main/resources/log4j.properties ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native