Reading SQL files (*.sql) - HOW

[ramsbharadwaj]

Hi,
What is the best way to read property files and SQL files (.sql) using Spring API. I know PopertyPlaceHolderConfigurer can be used for variables and ResourceBundle can be used for property/xml files, but for SQL files ...??/

thanks

[dr_pompeii]

Hello

They could be fine.

But if you download STS and create some Spring Templates projects you going to realize that these templates creates the most basic configuration about this.

Check it out

[wims.tijd]

you can use this namespace :

xmlns:jdbc="http://www.springframework.org/schema/jdbc"

http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd

and initialize your datasource with your sql scripts :

<jdbc:initialize-database data-source="dataSource" enabled="true" ignore-failures="DROPS">
	  	<jdbc:script location=""/>
	  </jdbc:initialize-database>