• QueryDSL
• Gradle에서 JPA 2 MetaModel 생성

먼저 Create Oracle database JDBC connection in gradle 를 통해 JDBC Driver를 build script 에서 로딩해야한다.

buildscript {
    dependencies {
        classpath 'com.mysema.querydsl:querydsl-sql-codegen:{version}'
    }
}
 
configurations {
    querydslSqlJdbcDriver
}
 
dependencies {
    querydslSqlJdbcDriver "mysql:mysql-connector-java:${mysqlJdbcDriverVersion}"
    compile "com.mysema.querydsl:querydsl-sql:{version}"
}
 
task generateQueryDslSql {
    // 별도 configuration 에서 JDBC Driver loading 할 것
    File mysql = configurations.querydslSqlJdbcDriver.find { it.toString().contains("mysql-connector-java") }
    URLClassLoader loader = GroovyObject.class.classLoader
    loader.addURL(mysql.toURI().toURL())
 
    DriverManager.registerDriver(loader.loadClass('com.mysql.jdbc.Driver').newInstance())
    Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8", "user", "password")
 
    MetaDataExporter exporter = new MetaDataExporter()
    exporter.namePrefix = 'S'
    exporter.packageName = 'com.coupang.order.domain.querydslsql'
    exporter.targetFolder = file('src/generated/java-jpa')
    exporter.export(connection.getMetaData())
    exporter.export(connection.getMetaData())
 
    connection.close()
}