A Database Dialect Tool
jDialects supports DDL creation, paging, function transformation, type conversion and major JPA annotation parsing functions for up to 80 database dialects.
It is usually used in combination with JDBC tools and as part of other Dao tools such as jSqlBox.
jDialects requires JDK1.6+
- No intrusion: jDialects works based on transforming SQL text without any impact on your existing persistence layer tools.
- ** Less dependency**: Only rely on a single jar file, about 280k in size.
- Create DDL from Annotation: Support build DDL from major JPA annotations
- Create DDL from Java methods: Provide Java method configuration to create DDL, the same Java methods can also used at runtime.
- Primary Key Generator: Provides ten primary key generators and supports custom primary key generators. A distributed primary key generator is also provided.
- Paging: Provides a cross-database pagination method.
- Function transformation: Parse different databases' functions corresponding dialects.
- ** type conversion**: Provides mutual transformation with Java types for different database data types.
- Reserved Word Check: Provides database reserved word checking.
Download here
Or put below in pom.xml:
<dependency>
<groupId>com.github.drinkjava2</groupId>
<artifactId>jdialects</artifactId>
<version>5.0.12.jre8</version> <!-- Or newest version -->
</dependency>Welcome post issue to help improve jDialects.