MySQL to H2 Converter

A library to convert MySQL statements to H2-compatible statements

License

License

Categories

Categories

MySQL Data Databases H2
GroupId

GroupId

com.parmet.mysql2h2-converter
ArtifactId

ArtifactId

mysql2h2-parent
Last Version

Last Version

0.2.0
Release Date

Release Date

Type

Type

pom
Description

Description

MySQL to H2 Converter
A library to convert MySQL statements to H2-compatible statements
Project URL

Project URL

https://github.com/andrewparmet/mysql2h2-converter
Source Code Management

Source Code Management

https://github.com/andrewparmet/mysql2h2-converter.git

Download mysql2h2-parent

How to add to project

<!-- https://jarcasting.com/artifacts/com.parmet.mysql2h2-converter/mysql2h2-parent/ -->
<dependency>
    <groupId>com.parmet.mysql2h2-converter</groupId>
    <artifactId>mysql2h2-parent</artifactId>
    <version>0.2.0</version>
    <type>pom</type>
</dependency>
// https://jarcasting.com/artifacts/com.parmet.mysql2h2-converter/mysql2h2-parent/
implementation 'com.parmet.mysql2h2-converter:mysql2h2-parent:0.2.0'
// https://jarcasting.com/artifacts/com.parmet.mysql2h2-converter/mysql2h2-parent/
implementation ("com.parmet.mysql2h2-converter:mysql2h2-parent:0.2.0")
'com.parmet.mysql2h2-converter:mysql2h2-parent:pom:0.2.0'
<dependency org="com.parmet.mysql2h2-converter" name="mysql2h2-parent" rev="0.2.0">
  <artifact name="mysql2h2-parent" type="pom" />
</dependency>
@Grapes(
@Grab(group='com.parmet.mysql2h2-converter', module='mysql2h2-parent', version='0.2.0')
)
libraryDependencies += "com.parmet.mysql2h2-converter" % "mysql2h2-parent" % "0.2.0"
[com.parmet.mysql2h2-converter/mysql2h2-parent "0.2.0"]

Dependencies

compile (1)

Group / Artifact Type Version
org.apache.logging.log4j : log4j-core jar 2.8.2

test (1)

Group / Artifact Type Version
junit : junit jar 4.8.1

Project Modules

  • parser
  • converter

mysql2h2-converter

A MySQL to H2 SQL conversion library written in Java.

Parse a MySQL dump and convert it to H2 statements either as an embedded library or as a standalone tool.

Next steps can include:

Other ideas:

Usage

As a library:

private static void convertAndCreate(Statement stmt, String sqlDump) throws SQLException, ParseException {
    Iterator<SqlStatement> sourceIterator = SQLParserManager.parseScript(new StringReader(sqlDump));
    Iterator<SqlStatement> converted = H2Converter.convertScript(sourceIterator);
    while (converted.hasNext()) {
        stmt.execute(converted.next().toString());
    }
}

On the command line:

java -jar lib/mysql2h2.jar demos/disconf-mysql.sql

Building

mvn install will generate the SQL parser and build an executable JAR.

License

This code is provided under the MIT license.

Versions

Version
0.2.0