Hello, maybe "SET FOREIGN_KEY_CHECKS=0" is not valid for a JDBC connection.
There are some vendor specific SQL instructions which are not valid inside JDBC. The ant sql task is a wrapper around JDBC. Maybe the task would need to be extended somehow to allow this kind of settings. Regards, Antoine mtbvang wrote: > Hi, > > I am getting the following error when using the > /mysql-connector-java-5.1.10-bin.jar in an Ant 1.7 SQL task. For some reason > a ? is being placed at the beginning of my comment and sql statement lines. > I've included the error from the cmd prompt and my and tasks below. Any one > know what's going on? > > > C:\dev\Projects\project-name>ant database.create > Buildfile: build.xml > Trying to override old definition of datatype resources > > database.create: > [sql] Executing resource: > C:\dev\Projects\project-name\MySQL\project\0.1.0\project-name > .sql > [sql] Failed to execute: ?-- SQL Manager 2007 for MySQL 4.2.0.2 > [sql] SET FOREIGN_KEY_CHECKS=0 > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
