spring 4.14 + posgresQL 14.2 잘 됨

package com.example.demo.Component;

 

import java.sql.Connection;

import java.sql.Statement;

 

import javax.sql.DataSource;

 

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.ApplicationArguments;

import org.springframework.boot.ApplicationRunner;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Component;

 

@Component

public class PgSQLRunner implements ApplicationRunner {

 

@Autowired

DataSource dataSource;

 

@Autowired

JdbcTemplate jdbcTemplate;

 

@Override

public void run(ApplicationArguments args) throws Exception {

// TODO Auto-generated method stub

System.out.println("PgSQLRunner ===> START ");

 

try(Connection connection = dataSource.getConnection()) {

System.out.println("PgSQLRunner ===>" + dataSource.getClass());

System.out.println("PgSQLRunner ===>" + connection.getMetaData());

System.out.println("PgSQLRunner ===>" + connection.getMetaData().getUserName());

 

Statement statement = connection.createStatement();

String sql = "CREATE TABLE TEST_USER2 (ID INTEGER NOT NULL, name VARCHAR(255), PRIMARY KEY (id))";

statement.executeUpdate(sql);

 

}

jdbcTemplate.execute("INSERT INTO TEST_USER2 values (5, 'fffff')");

}

}

PgSQLRunner ===>class com.zaxxer.hikari.HikariDataSource

PgSQLRunner ===>HikariProxyDatabaseMetaData@425033914 wrapping org.postgresql.jdbc.PgDatabaseMetaData@11d4d979

PgSQLRunner ===>postgres

 

잘됨 pgAdmin 초강력 툴이네.