How can i make a init-sql in Spring Boot-1.4.1-RELEASE

Question

I am developing a spring boot application:

using dependencies:

    dependencies {
    compile("org.springframework.boot:spring-boot-starter-web:1.4.1.RELEASE")
    compile('org.springframework.boot:spring-boot-starter-data-jpa:1.4.1.RELEASE')
    compile('mysql:mysql-connector-java:5.1.39')
}

I want to run sql on init:

SET NAMES 'utf8mb4'

to support emoji read/write

I make these configs on application.properties

spring.datasource.tomcat.init-sql=SET NAMES 'utf8mb4'
spring.datasource.init-sql=SET NAMES 'utf8mb4'
spring.datasource.connection-init-sql=SET NAMES 'utf8mb4'

But i can't make it work, and there no log for this on application startup.

Where did you get these init-sql properties from? I can't find any kind of documentation on them. — Gimby, Nov 10 '16 at 12:34
https://github.com/spring-projects/spring-boot/wiki/Spring-Boot-1.4.0-M1-Configuration-Changelog — kvh, Nov 10 '16 at 14:44

score 8 · Accepted Answer · edited May 23 '17 at 12:17

8

I think i found the answer, according to this answer:

the right properties will be:

spring.datasource.tomcat.initSQL=SET NAMES 'utf8mb4'

then this will exec on connection.

edited May 23 '17 at 12:17

Community

1
1

answered Nov 10 '16 at 15:02

kvh

2,118
19
29

score 0 · Answer 2 · answered Nov 10 '16 at 12:59

0

Please look at the related spring-boot doc

As stated, you need to create a file called schema.sql, or schema-mysql.sql if the script is mysql specific, and put your scripts there. Also, make sure that you set spring.jpa.hibernate.ddl-auto=none.

you can read the details in the doc.

answered Nov 10 '16 at 12:59

Gokhan Oner

3,237
19
25

i just want to execute some sql lines: like SET NAMES 'utf8mb4', will this work? – kvh Nov 10 '16 at 14:50
Should be. schema.sql file is where you put DML scripts. – Gokhan Oner Nov 10 '16 at 14:53

score 0 · Answer 3 · answered Mar 02 '22 at 12:43

First you can create configuration bean:

@Configuration
public class JdbcConfig {
    @Bean
    @Primary
    @ConfigurationProperties("db.datasource")
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }
}

And then add to your application.yaml:

db:
    datasource:
        driverClassName: oracle.jdbc.driver.OracleDriver
        jdbcUrl:
        username:
        password:
        initSQL: "YOUR INIT SQL HERE"

How can i make a init-sql in Spring Boot-1.4.1-RELEASE

3 Answers3

Linked