POJO Generator downloads statistics

Generate JPA Entity POJO from database table

Can generate from database table:

• an JPA Entity (JPA Annotated POJO) • There is no relationship between table • JPA annotations are generates over attributes • @GeneratedValue annotation if sequence over column are auto generated (H2, Microsoft SQL Server, MySQL and PostgreSQL) • @ManyToOne and @JoinColumn annotations on columns with foreign key • Generate composite primary key with @IdClass or @EmbeddedId annotations • a Data Transfert Object

Works with H2, Microsoft SQL Server, MySQL, Oracle & PostgreSQL.

Below the default mapping table used by the plugin:

DBMS SQL data type Java data type JPA columnDefinition

H2 BIGINT Long

H2 DATE LocalDate

H2 VARCHAR String

Microsoft SQL Server bigint Long

Microsoft SQL Server bit Boolean

Microsoft SQL Server datetime LocalDateTime

Microsoft SQL Server datetime2 LocalDateTime

Microsoft SQL Server decimal BigDecimal

Microsoft SQL Server int Integer

Microsoft SQL Server nvarchar String

Microsoft SQL Server varchar String

MySQL bigint Long

MySQL bit Boolean

MySQL date LocalDate

MySQL datetime LocalDateTime

MySQL decimal BigDecimal

MySQL double Double

MySQL enum String

MySQL float Float

MySQL int Integer

MySQL json String

MySQL smallint Integer

MySQL text String

MySQL timestamp LocalDateTime

MySQL tinyint java.lang.Byte

MySQL varchar String

Oracle CHAR String CHAR

Oracle DATE LocalDate

Oracle FLOAT Float

Oracle NUMBER Long

Oracle TIMESTAMP LocalDateTime

Oracle VARCHAR2 String

PostgreSQL bigint Long

PostgreSQL boolean Boolean

PostgreSQL date LocalDate

PostgreSQL integer Long

PostgreSQL varchar String

Description from the JetBrains Marketplace listing.