Am trying to build database using sql script with
ant sql task :
<property name="lib.dir" location="lib"/>
<property file="build.properties"/>
<path id="lib.path">
<fileset dir="${lib.dir}">
<include name="*.jar" />
</fileset>
</path>
<!-- - - - - - - - - - - - - - - - - -
target: setup database
- - - - - - - - - - - - - - - - - -->
<target name="setup_db" >
<sql driver="${db.driver}"
url="${db.url}"
userid="${db.username}"
password="${db.password}"
src="is.sql"
print="yes"
classpathref="lib.path"
encoding="UTF-8">
</sql>
</target>
and providing all values using .properties file, this is working fine with mysql but if I use it with MSSQL Server 2000, it give me this error :
[sql] Failed to execute:
java.sql.SQLException: [
SYNNET-SRV]Line 1: Incorrect syntax near 'E'.
any idea will be helpfull