org.jooq.impl.DefaultConfiguration Java Exaples

Source File: Issue318Test.java From SimpleFlatMapper with MIT License

7 votes

@Test
public void testHsqlDb() throws SQLException {
    Connection conn = DbHelper.objectDb();

    DSLContext dsl = DSL
            .using(new DefaultConfiguration().set(conn)
                    .set(SQLDialect.HSQLDB)
                    .set(SfmRecordMapperProviderFactory.newInstance().ignorePropertyNotFound().newProvider()));

    List<Issue318> list = dsl.select()
            .from("issue318").fetchInto(Issue318.class);

    assertEquals(1, list.size());

    Issue318 value = list.get(0);

    assertTrue(Math.abs(value.getT().atZone(ZoneId.systemDefault()).toInstant().toEpochMilli() - System.currentTimeMillis()) < 10000);
    assertNotNull(value.getId());

}

Source File: MetricsDSLContextTest.java From micrometer with Apache License 2.0

6 votes

@Test
void userExecuteListenerShouldBePreserved() {
    ExecuteListener userExecuteListener = mock(ExecuteListener.class);
    Configuration configuration = new DefaultConfiguration().set(() -> userExecuteListener);

    MetricsDSLContext jooq = withMetrics(using(configuration), meterRegistry, Tags.empty());

    ExecuteListenerProvider[] executeListenerProviders = jooq.configuration().executeListenerProviders();
    assertThat(executeListenerProviders).hasSize(2);
    assertThat(executeListenerProviders[0].provide()).isSameAs(userExecuteListener);
    assertThat(executeListenerProviders[1].provide()).isInstanceOf(JooqExecuteListener.class);

    SelectSelectStep<Record> select = jooq.tag("name", "selectAllAuthors").select(asterisk());
    executeListenerProviders = select.configuration().executeListenerProviders();
    assertThat(executeListenerProviders).hasSize(2);
    assertThat(executeListenerProviders[0].provide()).isSameAs(userExecuteListener);
    assertThat(executeListenerProviders[1].provide()).isInstanceOf(JooqExecuteListener.class);
}

Source File: MetricsDSLContextTest.java From micrometer with Apache License 2.0

6 votes

@NonNull
private MetricsDSLContext createDatabase(Connection conn) {
    Configuration configuration = new DefaultConfiguration()
            .set(conn)
            .set(SQLDialect.H2);

    MetricsDSLContext jooq = withMetrics(DSL.using(configuration), meterRegistry, Tags.empty());

    jooq.execute("CREATE TABLE author (" +
            "  id int NOT NULL," +
            "  first_name varchar(255) DEFAULT NULL," +
            "  last_name varchar(255) DEFAULT NULL," +
            "  PRIMARY KEY (id)" +
            ")");

    jooq.execute("INSERT INTO author VALUES(1, 'jon', 'schneider')");
    return jooq;
}

Source File: JooqHealthCheckTest.java From droptools with Apache License 2.0

6 votes

private HealthCheck.Result runHealthCheck(MockDataProvider provider) throws Exception {
    MockConnection mockConnection = new MockConnection(provider) {
        @Override
        public Savepoint setSavepoint() throws SQLException {
            return new Savepoint() {
                @Override
                public int getSavepointId() throws SQLException {
                    return 0;
                }

                @Override
                public String getSavepointName() throws SQLException {
                    return "savepoint";
                }
            };
        }
    };

    Configuration configuration = new DefaultConfiguration().set(mockConnection);
    configuration.settings().setExecuteLogging(false);
    JooqHealthCheck healthCheck = new JooqHealthCheck(configuration, validationQuery);

    return healthCheck.check();
}

Source File: DatabaseModule.java From curiostack with MIT License

6 votes

@Provides
@Singleton
static DSLContext dbContext(
    DataSource dataSource,
    DatabaseConfig config,
    @ForDatabase ListeningExecutorService dbExecutor) {
  Configuration configuration =
      new DefaultConfiguration()
          .set(dbExecutor)
          .set(SQLDialect.MYSQL)
          .set(new Settings().withRenderSchema(false))
          .set(new DataSourceConnectionProvider(dataSource))
          .set(DatabaseUtil.sfmRecordMapperProvider());
  if (config.getLogQueries()) {
    configuration.set(new QueryLogger());
  }
  DSLContext ctx = DSL.using(configuration);
  // Eagerly trigger JOOQ classinit for better startup performance.
  ctx.select().from("curio_server_framework_init").getSQL();
  return ctx;
}

Source File: JooqMapperTest.java From SimpleFlatMapper with MIT License

6 votes

@Test
public void testIgnoreFields() throws Exception {
	Connection conn = DbHelper.objectDb();

	DSLContext dsl = DSL
			.using(new DefaultConfiguration().set(conn)
					.set(SQLDialect.HSQLDB)
					.set(SfmRecordMapperProviderFactory.newInstance().addAlias("id", "noId").ignorePropertyNotFound().newProvider()));
	
	List<DbObject> list = dsl.select()
			.from("TEST_DB_OBJECT").fetchInto(DbObject.class);
	
	assertEquals(2, list.size());

	assertEquals(0, list.get(0).getId());
	list.get(0).setId(1);
	DbHelper.assertDbObjectMapping(list.get(0));
}

Source File: PostgresInsertReturningTest.java From vertx-jooq with MIT License

6 votes

private <R extends UpdatableRecord<R>,P,T> void runInsertReturning(Table<R> table, R record, Function<JsonObject, P> pojoMapper, CountDownLatch latch, Handler<AsyncResult<T>> resultHandler) throws InterruptedException {
    AsyncCompletableFutureQueryExecutor<R,P,T> queryExecutor = new AsyncCompletableFutureQueryExecutor<>(
            AsyncDatabaseClientProvider.getInstance().getVertx(),
            AsyncDatabaseClientProvider.getInstance().getClient(Credentials.POSTGRES),
            pojoMapper,
            table,
            false
    );
    Configuration configuration = new DefaultConfiguration();
    configuration.set(SQLDialect.POSTGRES);

    CompletableFuture<T> insertReturning = queryExecutor.insertReturning(dslContext -> dslContext
            .insertInto(table)
            .set(record)
            .returning(table.getPrimaryKey().getFieldsArray())
            , keyMapper(table, configuration));
    insertReturning.whenComplete((res,x)-> resultHandler.handle(x==null?Future.succeededFuture(res):Future.failedFuture(x)));
    Assert.assertTrue(latch.await(1, TimeUnit.SECONDS));
}

Source File: AbstractReconSqlDBTest.java From hadoop-ozone with Apache License 2.0

5 votes

@Before
public void createReconSchemaForTest() throws IOException {
  injector = Guice.createInjector(getReconSqlDBModules());
  dslContext = DSL.using(new DefaultConfiguration().set(
      injector.getInstance(DataSource.class)));
  createSchema(injector);
}

Source File: InitialConfiguration.java From tutorials with MIT License

5 votes

public DefaultConfiguration configuration() {
    DefaultConfiguration jooqConfiguration = new DefaultConfiguration();

    jooqConfiguration.set(connectionProvider());
    jooqConfiguration.set(new DefaultExecuteListenerProvider(new ExceptionTranslator()));

    return jooqConfiguration;
}

Source File: PersistenceContextIntegrationTest.java From tutorials with MIT License

5 votes

@Bean
public DefaultConfiguration configuration() {
    DefaultConfiguration jooqConfiguration = new DefaultConfiguration();
    jooqConfiguration.set(connectionProvider());
    jooqConfiguration.set(new DefaultExecuteListenerProvider(exceptionTransformer()));

    String sqlDialectName = environment.getRequiredProperty("jooq.sql.dialect");
    SQLDialect dialect = SQLDialect.valueOf(sqlDialectName);
    jooqConfiguration.set(dialect);

    return jooqConfiguration;
}

Source File: JooqFactory.java From droptools with Apache License 2.0

5 votes

public Configuration build(Environment environment, PooledDataSourceFactory factory, String name) throws ClassNotFoundException {
    final Settings settings = buildSettings();
    final ManagedDataSource dataSource = factory.build(environment.metrics(), name);
    final SQLDialect dialect = determineDialect(factory, dataSource);
    final ConnectionProvider connectionProvider = new DataSourceConnectionProvider(dataSource);
    final Configuration config = new DefaultConfiguration()
            .set(settings)
            .set(dialect)
            .set(connectionProvider);

    environment.lifecycle().manage(dataSource);

    return config;
}

Source File: Issue537Test.java From SimpleFlatMapper with MIT License

5 votes

@Test
public void testHsqlDbAsIssue() throws SQLException {



    SfmRecordMapperProvider recordMapperProvider = SfmRecordMapperProviderFactory
            .newInstance()
            .addColumnProperty( k -> k.getField().getName().equalsIgnoreCase("amount"), new RenameProperty("currencyAndAmount_number"))
            .addColumnProperty( k -> k.getField().getName().equalsIgnoreCase("currencyCode"), new RenameProperty("currencyAndAmount_currency"))
            .newProvider();
    Connection conn = DbHelper.objectDb();

    DSLContext dsl = DSL
            .using(new DefaultConfiguration().set(conn)
                    .set(SQLDialect.HSQLDB)
                    .set(recordMapperProvider));

    List<Issue537> list =
            dsl
                    .select()
                    .from("issue537_b")
                    .fetchInto(Issue537.class);

    assertEquals(1, list.size());

    Issue537 value = list.get(0);

    assertEquals(100, value.currencyAndAmount.getNumber().doubleValue(), 0.00001);
    assertEquals("USD", value.currencyAndAmount.getCurrency().getCurrencyCode());

}

Source File: JooqMapperTest.java From SimpleFlatMapper with MIT License

5 votes

@Test
public void testMapperDbObject() throws Exception {
	Connection conn = DbHelper.objectDb();

	DSLContext dsl = DSL
			.using(new DefaultConfiguration().set(conn)
					.set(SQLDialect.HSQLDB)
					.set(new SfmRecordMapperProvider()));

	List<DbObject> list = dsl.select()
			.from("TEST_DB_OBJECT").fetchInto(DbObject.class);

	assertEquals(2, list.size());
	DbHelper.assertDbObjectMapping(list.get(0));
}

Source File: JooqUnmapperTest.java From SimpleFlatMapper with MIT License

5 votes

@Test
public void testUnmapping() throws Exception {
	Connection conn = DbHelper.objectDb();

	Configuration cfg = new DefaultConfiguration()
			.set(conn)
			.set(SQLDialect.HSQLDB);

	cfg.set(JooqMapperFactory.newInstance().newRecordUnmapperProvider(new DSLContextProvider() {
		@Override
		public DSLContext provide() {
			return DSL.using(cfg);
		}
	}));

	DSLContext dsl = DSL.using(cfg);

	Label label = new Label(1, UUID.randomUUID(), "label", false);

	LabelsRecord labelsRecord = dsl.newRecord(Labels.LABELS, label);

	assertEquals(label.getId(), labelsRecord.getId());
	assertEquals(label.getName(), labelsRecord.getName());
	assertEquals(label.getUuid(), labelsRecord.getUuid());
	assertEquals(label.getObsolete(), labelsRecord.getObsolete());


}

Source File: DITestingConfiguration.java From waltz with Apache License 2.0

5 votes

@Bean
@Autowired
public DSLContext dsl(DataSource dataSource) {
    org.jooq.Configuration configuration = new DefaultConfiguration()
            .set(dataSource)
            .set(SQLDialect.POSTGRES);
    return DSL.using(configuration);
}

Source File: DIBaseConfiguration.java From waltz with Apache License 2.0

5 votes

@Bean
@Autowired
public DSLContext dsl(DataSource dataSource) {
    try {
        SQLDialect.valueOf(dialect);
    } catch (IllegalArgumentException iae) {
        System.err.println("Cannot parse sql dialect: "+dialect);
        throw iae;
    }

    // TODO: remove sql server setting, see #4553
    Settings dslSettings = new Settings()
            .withRenderOutputForSQLServerReturningClause(false);

    if ("true".equals(System.getProperty(JOOQ_DEBUG_PROPERTY))) {
        dslSettings
                .withRenderFormatted(true)
                .withExecuteLogging(true);
    }

    org.jooq.Configuration configuration = new DefaultConfiguration()
            .set(dataSource)
            .set(SQLDialect.valueOf(dialect))
            .set(dslSettings)
            .set(new SlowQueryListener(databasePerformanceQuerySlowThreshold));

    return DSL.using(configuration);
}

Source File: JooqPersistenceModule.java From hadoop-ozone with Apache License 2.0

5 votes

@Provides
@Singleton
Configuration getConfiguration(DefaultDataSourceProvider provider) {
  DataSource dataSource = provider.get();

  return new DefaultConfiguration()
      .set(dataSource)
      .set(new SpringConnectionProvider(dataSource))
      .set(SQLDialect.valueOf(configurationProvider.get().getSqlDialect()));
}

Source File: WikiServer.java From redpipe with Apache License 2.0

5 votes

@Override
protected SQLClient createDbClient(JsonObject config) {
	JsonObject myConfig = new JsonObject();
	if(config.containsKey("db_host"))
		myConfig.put("host", config.getString("db_host"));
	if(config.containsKey("db_port"))
		myConfig.put("port", config.getInteger("db_port"));
	if(config.containsKey("db_user"))
		myConfig.put("username", config.getString("db_user"));
	if(config.containsKey("db_pass"))
		myConfig.put("password", config.getString("db_pass"));
	if(config.containsKey("db_name"))
		myConfig.put("database", config.getString("db_name"));
	myConfig.put("max_pool_size", config.getInteger("db_max_pool_size", 30));
	
	Vertx vertx = AppGlobals.get().getVertx();
	AsyncSQLClient dbClient = PostgreSQLClient.createNonShared(vertx, myConfig);

	Configuration configuration = new DefaultConfiguration();
	configuration.set(SQLDialect.POSTGRES);

	PagesDao dao = new PagesDao(configuration, dbClient);
	
	AppGlobals.get().setGlobal(PagesDao.class, dao);
	
	return dbClient;
}

Source File: PostgresInsertReturningTest.java From vertx-jooq with MIT License

5 votes

private <R extends UpdatableRecord<R>,P,T> void runInsertReturning(Table<R> table, R record, Function<JsonObject, P> pojoMapper, CountDownLatch latch, Handler<AsyncResult<T>> resultHandler) {
    AsyncRXQueryExecutor<R,P,T> queryExecutor = new AsyncRXQueryExecutor<>(
            AsyncRXDatabaseClientProvider.getInstance().getClient(Credentials.POSTGRES),
            pojoMapper,
            table,
            false
    );
    Configuration configuration = new DefaultConfiguration();
    configuration.set(SQLDialect.POSTGRES);
    Single<T> insertReturning = queryExecutor.insertReturning(dslContext -> dslContext
            .insertInto(table)
            .set(record)
            .returning(table.getPrimaryKey().getFieldsArray())
            , keyMapper(table, configuration));
    insertReturning.subscribe(new SingleObserver<T>() {
        @Override
        public void onSubscribe(Disposable d) {

        }

        @Override
        public void onSuccess(T t) {
            resultHandler.handle(Future.succeededFuture(t));
        }

        @Override
        public void onError(Throwable x) {
            resultHandler.handle(Future.failedFuture(x));
        }
    });
    try {
        Assert.assertTrue(latch.await(1, TimeUnit.SECONDS));
    } catch (InterruptedException e) {
        Assert.fail(e.getMessage());
    }
}

Source File: JooqConfig.java From StubbornJava with MIT License

5 votes

public static Configuration defaultConfigFromDataSource(DataSource ds) {
    DataSourceConnectionProvider dcp = new DataSourceConnectionProvider(ds);
    Configuration jooqConfig = new DefaultConfiguration();
    jooqConfig.set(SQLDialect.MYSQL);
    jooqConfig.set(dcp);
    //jooqConfig.set(new ThreadLocalTransactionProvider(dcp));
    jooqConfig.settings()
              .withExecuteWithOptimisticLockingExcludeUnversioned(true);
    return jooqConfig;
}

Source File: HsqldbConfigurationProvider.java From vertx-jooq with MIT License

5 votes

@Override
public org.jooq.Configuration createDAOConfiguration(){
    org.jooq.Configuration configuration = new DefaultConfiguration();
    configuration.set(SQLDialect.HSQLDB);
    try {
        configuration.set(DriverManager.getConnection("jdbc:hsqldb:mem:test", "test", ""));
    } catch (SQLException e) {
        throw new AssertionError("Failed setting up DB.",e);
    }
    return configuration;
}

Source File: JooqConfig.java From StubbornJava with MIT License

5 votes

public static Configuration defaultConfigFromDataSource(DataSource ds) {
    DataSourceConnectionProvider dcp = new DataSourceConnectionProvider(ds);
    Configuration jooqConfig = new DefaultConfiguration();
    jooqConfig.set(SQLDialect.MYSQL);
    jooqConfig.set(dcp);
    //jooqConfig.set(new ThreadLocalTransactionProvider(dcp));
    jooqConfig.settings()
              .withExecuteWithOptimisticLockingExcludeUnversioned(true);
    return jooqConfig;
}

Source File: ScopedContext.java From JOOQ with Apache License 2.0

5 votes

public DSLContext getDSLContext() {
    if (dslContext == null) {
        Configuration defaultConfiguration = new DefaultConfiguration().set(getConnection())
                .set(SQLDialect.MYSQL);

        dslContext = DSL.using(defaultConfiguration);
    }

    return dslContext;
}

Source File: UserDataSources.java From secrets-proxy with Apache License 2.0

5 votes

private DSLContext getDslContext(PlatformTransactionManager txManager, DataSource dataSource) {
  DefaultConfiguration config = new DefaultConfiguration();
  config.set(new DataSourceConnectionProvider(new TransactionAwareDataSourceProxy(dataSource)));
  config.set(new DefaultExecuteListenerProvider(new JooqExceptionTranslator()));
  config.set(new SpringTransactionProvider(txManager));
  return new DefaultDSLContext(config);
}

Source File: JooqMapperTest.java From SimpleFlatMapper with MIT License

4 votes

@Test
public void testMapperDbExtendedType() throws Exception {
	Connection conn = DbHelper.objectDb();

	DSLContext dsl = DSL
			.using(new DefaultConfiguration().set(conn)
					.set(SQLDialect.HSQLDB)
					.set(SfmRecordMapperProviderFactory.newInstance().newProvider()));
	
	List<DbExtendedType> list = dsl.select()
			.from("db_extended_type").fetchInto(DbExtendedType.class);
	
	
	assertEquals(1, list.size());
	DbExtendedType o = list.get(0);
	
	DbExtendedType.assertDbExtended(o);
	
}

Source File: JooqConfigurationFactory.java From micronaut-sql with Apache License 2.0

4 votes

/**
 * Creates jOOQ {@link Configuration}.
 * It will configure it with available jOOQ provider beans with the same qualifier.
 *
 * @param name                   The data source name
 * @param dataSource             The {@link DataSource}
 * @param transactionProvider    The transaction provider
 * @param settings               The settings
 * @param executorProvider       The executor provider
 * @param recordMapperProvider   The record mapper provider
 * @param recordUnmapperProvider The record unmapper provider
 * @param metaProvider           The metadata provider
 * @param ctx                    The {@link ApplicationContext}
 * @return A {@link Configuration}
 */
@EachBean(DataSource.class)
public Configuration jooqConfiguration(
        @Parameter String name,
        DataSource dataSource,
        @Parameter @Nullable TransactionProvider transactionProvider,
        @Parameter @Nullable Settings settings,
        @Parameter @Nullable ExecutorProvider executorProvider,
        @Parameter @Nullable RecordMapperProvider recordMapperProvider,
        @Parameter @Nullable RecordUnmapperProvider recordUnmapperProvider,
        @Parameter @Nullable MetaProvider metaProvider,
        ApplicationContext ctx
) {
    DefaultConfiguration configuration = new DefaultConfiguration();

    JooqConfigurationProperties properties = ctx.findBean(JooqConfigurationProperties.class, Qualifiers.byName(name))
            .orElseGet(JooqConfigurationProperties::new);
    DataSourceResolver dataSourceResolver = ctx.findBean(DataSourceResolver.class).orElse(DataSourceResolver.DEFAULT);
    configuration.setSQLDialect(properties.determineSqlDialect(dataSourceResolver.resolve(dataSource)));

    configuration.setDataSource(dataSource);
    if (transactionProvider != null) {
        configuration.setTransactionProvider(transactionProvider);
    }
    if (settings != null) {
        configuration.setSettings(settings);
    }
    if (executorProvider != null) {
        configuration.setExecutorProvider(executorProvider);
    }
    if (recordMapperProvider != null) {
        configuration.setRecordMapperProvider(recordMapperProvider);
    }
    if (recordUnmapperProvider != null) {
        configuration.setRecordUnmapperProvider(recordUnmapperProvider);
    }
    if (metaProvider != null) {
        configuration.setMetaProvider(metaProvider);
    }
    configuration.setExecuteListenerProvider(ctx.getBeansOfType(ExecuteListenerProvider.class, Qualifiers.byName(name))
            .toArray(new ExecuteListenerProvider[0]));
    configuration.setRecordListenerProvider(ctx.getBeansOfType(RecordListenerProvider.class, Qualifiers.byName(name))
            .toArray(new RecordListenerProvider[0]));
    configuration.setVisitListenerProvider(ctx.getBeansOfType(VisitListenerProvider.class, Qualifiers.byName(name))
            .toArray(new VisitListenerProvider[0]));
    configuration.setTransactionListenerProvider(ctx.getBeansOfType(TransactionListenerProvider.class, Qualifiers.byName(name))
            .toArray(new TransactionListenerProvider[0]));
    configuration.setDiagnosticsListenerProvider(ctx.getBeansOfType(DiagnosticsListenerProvider.class, Qualifiers.byName(name))
            .toArray(new DiagnosticsListenerProvider[0]));

    return configuration;
}

Source File: CategoryConfiguration.java From spring-data-examples with Apache License 2.0

4 votes

public DefaultConfiguration configuration() {
	DefaultConfiguration jooqConfiguration = new DefaultConfiguration();
	jooqConfiguration.set(connectionProvider());
	return jooqConfiguration;
}

Source File: ConfigurationModule.java From guice-persist-jooq with Apache License 2.0

4 votes

protected void configure() {
  DefaultConfiguration configuration = new DefaultConfiguration();
  configuration.setSQLDialect(DIALECT);
  binder().bind(Configuration.class).toInstance(configuration);
}

Source File: Issue587Test.java From SimpleFlatMapper with MIT License

4 votes

@Test
public void testFetchIntoResultSet() throws SQLException {
    Connection conn = DbHelper.getDbConnection(DbHelper.TargetDB.POSTGRESQL);
    if (conn == null) return;
    try  {


        Statement statement = conn.createStatement();

        statement.executeUpdate("CREATE TABLE IF NOT EXISTS issue_587(id int, t timestamptz)");
        statement.executeUpdate("TRUNCATE issue_587");
        statement.executeUpdate("insert into issue_587 values (1, timestamp with time zone '2018-11-15 11:45:11.00000+01:00')");

        DSLContext dsl = DSL
                .using(new DefaultConfiguration().set(conn)
                        .set(SQLDialect.POSTGRES)
                        .set(SfmRecordMapperProviderFactory.newInstance().ignorePropertyNotFound().newProvider()));

        DynamicJdbcMapper<Issue587> mapper = JdbcMapperFactory.newInstance().newMapper(Issue587.class);
        OffsetDateTime date = OffsetDateTime.parse("2018-11-15T11:45:11+01:00", DateTimeFormatter.ISO_OFFSET_DATE_TIME);

        OffsetDateTime expected = date.withOffsetSameInstant(ZoneOffset.UTC);

        SelectWhereStep<Record> select = dsl.selectFrom("issue_587");


        try (ResultSet rs = select.fetch().intoResultSet()) {
            ResultSetMetaData metaData = rs.getMetaData();
            System.out.println("metaData = " + metaData.getColumnType(2));
            System.out.println("metaData = " + metaData.getColumnClassName(2));
            System.out.println("metaData = " + metaData.getColumnTypeName(2));
            while (rs.next()) {
                System.out.println("rs.getObject(2) = " + rs.getObject(2));
            }
        }

        try (ResultSet rs = select.fetch().intoResultSet()) {
            Issue587[] issue587s = mapper.stream(rs).toArray(Issue587[]::new);
            System.out.println("issue587s = " + Arrays.toString(issue587s));

            assertEquals(1, issue587s.length);

            assertEquals(1, issue587s[0].id);
            assertEquals(expected, issue587s[0].t);
        }

    } finally {
        conn.close();
    }


}

Source File: Issue587Test.java From SimpleFlatMapper with MIT License

4 votes

@Test
public void testFetchResultSet() throws SQLException {
    Connection conn = DbHelper.getDbConnection(DbHelper.TargetDB.POSTGRESQL);
    if (conn == null) return;
    try {


        Statement statement = conn.createStatement();

        statement.executeUpdate("CREATE TABLE IF NOT EXISTS issue_587(id int, t timestamptz)");
        statement.executeUpdate("TRUNCATE issue_587");
        statement.executeUpdate("insert into issue_587 values (1, timestamp with time zone '2018-11-15 11:45:11.00000+01:00')");

        DSLContext dsl = DSL
                .using(new DefaultConfiguration().set(conn)
                        .set(SQLDialect.POSTGRES)
                        .set(SfmRecordMapperProviderFactory.newInstance().ignorePropertyNotFound().newProvider()));

        DynamicJdbcMapper<Issue587> mapper = JdbcMapperFactory.newInstance().newMapper(Issue587.class);
        OffsetDateTime date = OffsetDateTime.parse("2018-11-15T11:45:11+01:00", DateTimeFormatter.ISO_OFFSET_DATE_TIME);

        OffsetDateTime expected = date.withOffsetSameInstant(ZoneOffset.UTC);

        SelectWhereStep<Record> select = dsl.selectFrom("issue_587");


        try (ResultSet rs = select.fetchResultSet()) {
            ResultSetMetaData metaData = rs.getMetaData();
            System.out.println("metaData = " + metaData.getColumnType(2));
            System.out.println("metaData = " + metaData.getColumnClassName(2));
            System.out.println("metaData = " + metaData.getColumnTypeName(2));

            while (rs.next()) {
                System.out.println("rs.getObject(2) = " + rs.getObject(2));
            }
        }
        

        try (ResultSet rs = select.fetchResultSet()) {
            Issue587[] issue587s = mapper.stream(rs).toArray(Issue587[]::new);
            System.out.println("issue587s = " + Arrays.toString(issue587s));

            assertEquals(1, issue587s.length);

            assertEquals(1, issue587s[0].id);
            assertEquals(expected, issue587s[0].t);
        }

    } finally {
        conn.close();
    }
    

}

org.jooq.impl.DefaultConfiguration Java Examples