JarCasting
JarCasting JarCasting

jpa-schema-maven-plugin

Maven plugin for generate database schema or DDL scripts from JPA entities.

License

License
Categories

Categories

Maven Build Tools
GroupId

GroupId

io.github.divinespear
ArtifactId

ArtifactId

jpa-schema-maven-plugin
Last Version

Last Version

0.2.1
Release Date

Release Date
Type

Type

maven-plugin
Description

Description

jpa-schema-maven-plugin
Maven plugin for generate database schema or DDL scripts from JPA entities.
Project URL

Project URL

http://divinespear.github.io/jpa-schema-maven-plugin
Source Code Management

Source Code Management

https://github.com/divinespear/jpa-schema-maven-plugin

Download jpa-schema-maven-plugin

Filename Size
jpa-schema-maven-plugin-0.2.1.pom
jpa-schema-maven-plugin-0.2.1.jar 25 KB
jpa-schema-maven-plugin-0.2.1-sources.jar 10 KB
jpa-schema-maven-plugin-0.2.1-javadoc.jar 37 KB
Browse

How to add to project

<plugin>
    <groupId>io.github.divinespear</groupId>
    <artifactId>jpa-schema-maven-plugin</artifactId>
    <version>0.2.1</version>
</plugin>

Dependencies

compile (3)

Group / Artifact Type Version
org.codehaus.plexus : plexus-utils jar 3.0.22
commons-lang : commons-lang jar 2.6
org.springframework.data : spring-data-jpa jar 1.9.2.RELEASE

provided (10)

Group / Artifact Type Version
org.apache.maven : maven-core jar 3.3.1
org.apache.maven : maven-aether-provider jar 3.3.1
org.apache.maven : maven-compat jar 3.3.1
org.apache.maven : maven-plugin-api jar 3.3.1
org.apache.maven.plugin-tools : maven-plugin-tools-generators jar 3.4
org.apache.maven.plugin-tools : maven-plugin-tools-annotations jar 3.4
org.eclipse.persistence : org.eclipse.persistence.jpa jar 2.6.1
org.eclipse.persistence : org.eclipse.persistence.oracle jar 2.6.1
org.hibernate : hibernate-entitymanager jar 5.0.7.Final
org.datanucleus : datanucleus-accessplatform-jpa-rdbms pom 4.2.3

test (6)

Group / Artifact Type Version
junit : junit jar 4.12
org.mockito : mockito-core jar 1.9.5
org.hamcrest : hamcrest-all jar 1.3
org.apache.maven.plugin-testing : maven-plugin-testing-harness jar 3.3.0
org.apache.maven.shared : maven-invoker jar 2.2
com.h2database : h2 jar [1.4, 1.9)

Project Modules

There are no modules declared in this project.

jpa-schema-maven-plugin

Build Status

Maven plugin for generate schema or DDL scripts from JPA entities using JPA 2.1 schema generator. for Gradle, see Gradle Plugin.

Currently support EclipseLink (Reference Implementation) and Hibernate.

Before Announce...

READ MY LIP; JPA DDL GENERATOR IS NOT SILVER BULLET

Sometimes (most times exactly :P) JPA will generate weird scripts so you SHOULD modify them properly.

Announce 0.2

Finally, I got some times, and 0.2 is here.

  • Support generate without persistence.xml (like spring-data, spring-boot, ...) related #14
  • Changed default version of implementations.
    • Eclipselink: 2.6.1
    • Hibernate: 5.0.7.Final
  • Added properties property.
  • Removed properties namingStrategy and dialect cause Hibernate 4.x to 5.x is cataclysm. please use properties instead.

On 0.2.x, plugin required

Unfortunately, DataNucleus does not support on maven plugin... but I will find a way. I always have.

How-to Use

Define plugin at your maven pom.xml file like below.

<project>
	...
	<build>
		<plugins>
			<plugin>
				<groupId>io.github.divinespear</groupId>
				<artifactId>jpa-schema-maven-plugin</artifactId>
				<version>0.1.12</version>
				<configuration>
					...
				</configuration>
				<executions>
					<!-- if you want auto-generate schema on lifecycle. default lifecycle is "process-classes". -->
					...
				</executions>
				<dependencies>
					<!-- JDBC driver here (if you don't defined in dependencies) -->
					...
				</dependencies>
			</plugin>
			...
		</plugins>
	</build>
	...
</project>

To generate, use goal

mvn jpa-schema:generate

or use default lifecycle

mvn process-classes

To see configuration parameters, see here.

Database Product Names

It's about databaseProductName property. If not listed below, will work as basic standard SQL.

for EclipseLink

databaseMajorVersion and databaseMinorVersion is not required.

  • Oracle12 = Oracle 12c
  • Oracle11 = Oracle 11g
  • Oracle10: Oracle 10g
  • Oracle9: Oracle 9i
  • Oracle: Oracle with default compatibility
  • Microsoft SQL Server
  • DB2
  • MySQL
  • PostgreSQL
  • SQL Anywhere
  • Sybase SQL Server
  • Adaptive Server Enterprise = Sybase
  • Pointbase
  • Informix Dynamic Server
  • Firebird
  • ingres
  • Apache Derby
  • H2
  • HSQL Database Engine

for Hibernate

Some products uses different dialect by databaseMajorVersion and/or databaseMinorVersion. You can override using hibernate.dialect property.

  • CUBRID
    • org.hibernate.dialect.CUBRIDDialect = all version
  • HSQL Database Engine
    • org.hibernate.dialect.HSQLDialect = all version
  • H2
    • org.hibernate.dialect.H2Dialect = all version
  • MySQL
    • org.hibernate.dialect.MySQL5Dialect = 5.x
    • org.hibernate.dialect.MySQLDialect = 4.x or below
    • org.hibernate.dialect.MySQLMyISAMDialect
    • org.hibernate.dialect.MySQLInnoDBDialect
    • org.hibernate.dialect.MySQL5InnoDBDialect
    • org.hibernate.dialect.MySQL57InnoDBDialect
  • PostgreSQL
    • org.hibernate.dialect.PostgreSQL94Dialect = 9.4 or above
    • org.hibernate.dialect.PostgreSQL92Dialect = 9.2 or above
    • org.hibernate.dialect.PostgreSQL9Dialect = 9.x
    • org.hibernate.dialect.PostgreSQL82Dialect = 8.2 or above
    • org.hibernate.dialect.PostgreSQL81Dialect = 8.1 or below
  • Apache Derby
    • org.hibernate.dialect.DerbyTenSevenDialect = 10.7 or above
    • org.hibernate.dialect.DerbyTenSixDialect = 10.6
    • org.hibernate.dialect.DerbyTenFiveDialect = 10.5
    • org.hibernate.dialect.DerbyDialect = 10.4 or below
  • ingres
    • org.hibernate.dialect.Ingres10Dialect = 10.x
    • org.hibernate.dialect.Ingres9Dialect = 9.2 or above
    • org.hibernate.dialect.IngresDialect = 9.1 or below
  • Microsoft SQL Server
    • org.hibernate.dialect.SQLServer2012Dialect = 11.x
    • org.hibernate.dialect.SQLServer2008Dialect = 10.x
    • org.hibernate.dialect.SQLServer2005Dialect = 9.x
    • org.hibernate.dialect.SQLServerDialect = 8.x or below
  • Sybase SQL Server
    • org.hibernate.dialect.SybaseASE15Dialect = all version
    • org.hibernate.dialect.SybaseASE17Dialect
  • Adaptive Server Enterprise = Sybase
  • Adaptive Server Anywhere
    • org.hibernate.dialect.SybaseAnywhereDialect = all version
  • Informix Dynamic Server
    • org.hibernate.dialect.InformixDialect = all version
  • DB2 UDB for AS/390
    • org.hibernate.dialect.DB2390Dialect
  • DB2 UDB for AS/400
    • org.hibernate.dialect.DB2400Dialect = all version
  • start with DB2/
    • org.hibernate.dialect.DB2Dialect = all version
  • Oracle
    • org.hibernate.dialect.Oracle12cDialect = 12.x
    • org.hibernate.dialect.Oracle10gDialect = 11.x, 10.x
    • org.hibernate.dialect.Oracle9iDialect = 9.x
    • org.hibernate.dialect.Oracle8iDialect = 8.x or below
  • Firebird
    • org.hibernate.dialect.FirebirdDialect = all version

License

Source Copyright © 2013 Sin-young "Divinespear" Kang. Distributed under the Apache License, Version 2.0.

Versions

Version
0.2.1
0.2.0
0.1.12
0.1.10
0.1.9-1
0.1.9
0.1.8
0.1.7
0.1.6
0.1.5
0.1.4
0.1.3-1
0.1.3
0.1.2
0.1.1
0.1.0