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]

Reply via email to