How to generate sql without a database connection using jooq

Question

I am playing with some jooq code. I noticed to create sql using jooq it forces you to create a database connection. Wanted to know how to do this without a database connection:

String url = env.getProperty("spring.datasource.url");
String user = env.getProperty("spring.datasource.username");
String pass = env.getProperty("spring.datasource.password");

try (Connection conn = DriverManager.getConnection(url, user, pass)) {
    DSLContext create = DSL.using(conn, SQLDialect.SQLSERVER2014);
    String sql = create.select().from(DATA1).offset(100).limit(20).getSQL();
}
catch (Exception e) {
    e.printStackTrace();
}

No idea what you're doing but you could fire up h2 database embedded within your jvm — lance-java
– lance-java, Commented Mar 17, 2018 at 17:26

Lukas Eder · Accepted Answer · 2018-03-18 11:31:26Z

7

Just don't pass any connection to the using() call:

DSLContext create = DSL.using(SQLDialect.SQLSERVER2014);
String sql = create.select().from(DATA1).offset(100).limit(20).getSQL();

answered Mar 18, 2018 at 11:31

Lukas Eder

223k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to generate sql without a database connection using jooq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related