How to scan SQL files for create tables in db?

Question

I need to scan my SQL files, SQL-files for create tables in db. Now I have:

import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration;

@Configuration
@EntityScan({"model"}) //in folder model put SQL-files
@ComponentScan(basePackageClasses = { MyApiServiceImpl.class})
@Import({DataSourceAutoConfiguration.class, HibernateJpaAutoConfiguration.class})
public class TestConfig {
...
}

But this cannot to get SQL-files from model folder, because in model folder must to put entity classes, but I want SQL-files in model folder.

Have a look at stackoverflow.com/questions/11559846/…. It might help you. — Litisqe Kumar
– Litisqe Kumar, Commented Jul 1, 2015 at 11:21

Lucas Saldanha · Accepted Answer · 2015-07-01 13:06:09Z

1

I don't believe that @EntityScan works for scanning sql files (http://docs.spring.io/spring-boot/docs/current/api/org/springframework/boot/orm/jpa/EntityScan.html). Actually it scan classes with the @Entity annotation. If you want your files to be automatically in your application's classpath you should put them in the src/main/resources folder (if you are using maven/gradle).

If you want Spring to execute the sql to create your database schema, you should use a schema.sql file in your classpath (http://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html).

I hope it helps! :)

answered Jul 1, 2015 at 13:06

Lucas Saldanha

8917 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

How to scan SQL files for create tables in db?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related