search

michaelcgood / Spring-Batch-CSV-Example

Example Spring Batch application for importing large CSV file as described on my blog
GNU General Public License v3.0
22 stars 34 forks source link

Error with running sql server datasource. #1

Open b4uazam opened 6 years ago

b4uazam commented 6 years ago

Hi Michaelc, Thanks for your code share, We are running application with spring boot 2.0.4, on Eclipse IDE maven build with the Sql server datasource, getting below error. Did you tried this application by runnign with the sql server datasource? Please share the code base if you able to run this with sql server datasource successfully. Thanks in advance

o.s.boot.autoconfigure.jdbc.Datasource.initailizer disabled(not running DDL scripts)

at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE where JOB_NAME = ? order by JOB_INSTANCE_ID desc]; nested exception is java.sql.SQLServerException: Invalid object name 'BATCH_JOB_INSTANCE'.

marccollin commented 5 years ago

you need to create schema in your db check

https://github.com/spring-projects/spring-batch/tree/master/spring-batch-core/src/main/resources/org/springframework/batch/core