Scot P. Floess wrote:
Steve:
Now that I give this some deeper thought...I see now what the intent
is... I got hung up on dual parsing...one by task and one the the
JDBC layer: clearly one has to be able to issue a sql statement - thus
the delimiter attribute - duh on my part :(
I do see
Steve:
Now that I give this some deeper thought...I see now what the intent
is... I got hung up on dual parsing...one by task and one the the
JDBC layer: clearly one has to be able to issue a sql statement - thus
the delimiter attribute - duh on my part :(
I do see your point...and well t
Scot P. Floess wrote:
Honestly, this is an implementation issue IMHO with regards to Ant. It
is treating each line as ONE sql statement. By using the -line
continuation- character, it should fix the problem - namely the \
character.
Placing SQL statements in a file makes perfect sense...per
the use of the
>> > designated recipients named above. If you are not the intended
>> recipient, you are hereby notified that you have received
>> > this communication in error and that any review, disclosure,
>> dissemination, distribution or copying of it or its
nts
> - Original Message -
> From: "Hunter Peress" <[EMAIL PROTECTED]>
> To: "Ant Users List" ; "Martin Gainty" <
[EMAIL PROTECTED]>
> Sent: Tuesday, October 24, 2006 8:15 PM
> Subject: Example: error loading a mysqldump f
s" <[EMAIL PROTECTED]>
To: "Ant Users List"
Sent: Tuesday, October 24, 2006 9:22 PM
Subject: Re: Example: error loading a mysqldump file
> Honestly, this is an implementation issue IMHO with regards to Ant. It
> is treating each line as ONE sql statement. By using the -line
s" <[EMAIL PROTECTED]>
> To: "Ant Users List" ; "Martin Gainty" <
[EMAIL PROTECTED]>
> Sent: Tuesday, October 24, 2006 8:15 PM
> Subject: Example: error loading a mysqldump file
>
>
>
>> Ant file:
>> &g
sers List" ; "Martin Gainty" <[EMAIL PROTECTED]>
Sent: Tuesday, October 24, 2006 8:15 PM
Subject: Example: error loading a mysqldump file
Ant file:
use what;
wtf.sql:
insert into properties (value) values("");
insert into properties (value
Hunter:
Did you use the \ character between each line? I swear this is exactly
the same problem I had with postgres... Ant is treating each line as
ONE sql statement. If your sql statement doesnt end properly, it will
complain... So, since you span multiple lines...its an issue.
Hunter
t;
Sent: Tuesday, October 24, 2006 8:15 PM
Subject: Example: error loading a mysqldump file
> Ant file:
> classpath="../lib/mysql-connector-java-3.1.12-bin.jar"
> driver="com.mysql.jdbc.Driver"
>
Ant file:
use what;
wtf.sql:
insert into properties (value) values("");
insert into properties (value) values("Hi");
Ok so if in mysql console you source wtf.sql there are no problems, its
valid mysql. But ant bombs on it.
Ant can handle each line ,but put them togeth
11 matches
Mail list logo
