moriya-hm5

max_connections = 100
max_prepared_transactions = 100 # defaultでコメントアウトされている

moriya-hm5

Caused by: org.postgresql.util.PSQLException: ERROR: トランザクションの準備は無効にされているためできません。
  ヒント: max_prepared_transactionsを非ゼロに設定してください。

moriya-hm5

compile group: 'org.springframework.boot', name: 'spring-boot-starter-jta-bitronix', version: '2.2.4.RELEASE'

moriya-hm5

const moment = require('moment-timezone');

exports.handler = async (event) => {
  const dateTimeJst = moment().tz('Asia/Tokyo').format();
  console.log(dateTimeJst);// JST
};

moriya-hm5

package com.example.demo.config;

import java.util.Properties;

import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;

moriya-hm5

// この3行が必要
Properties props = new Properties();
props.setProperty("dbschema", "schemaname");
sqlSessionFactory.setConfigurationProperties(props);

moriya-hm5

@Select(value="select * from ${dbschema}.Employees ")
public Employees findByEmployee();

moriya-hm5

mybatis:
  configuration-properties:
    dbschema: schemaname

moriya-hm5

package jp.co.confrage.config;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;

moriya-hm5

package jp.co.confrage.config;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;