I submitted a new ant task for 1.6.5 named MySQLExec.java
It handles the mysql specific delimiter command (found in mysqldumps of
triggers and stored procedures) and it handles varchar/text fields that
contain -- such as xml comments stored in a text field.
http://issues.apache.org/bugzilla/show
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
ation and any attachments may contain
confidential
>> and privileged information for 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
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
nts
- Original Message -
From: "Scot P. Floess" <[EMAIL PROTECTED]>
To: "Ant Users List"
Sent: Tuesday, October 24, 2006 10:03 AM
Subject: Re: error loading a mysqldump file
> Can you elaborate more on the error?
>
> Some years ago I was using the sql tas
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"
>
essage -
From: "Scot P. Floess" <[EMAIL PROTECTED]>
To: "Ant Users List"
Sent: Tuesday, October 24, 2006 10:03 AM
Subject: Re: error loading a mysqldump file
> Can you elaborate more on the error?
>
> Some years ago I was using the sql task and had a file full o
Sent: Tuesday, October 24, 2006 10:03 AM
Subject: Re: error loading a mysqldump file
> Can you elaborate more on the error?
>
> Some years ago I was using the sql task and had a file full of SQL
> statements... When I tried to use the sql task I was getting errors as
> well.
More specifically if I had multiple SQL statements, I had to do this:
create table foo \
( \
bar as int \
);
create table alpha \
( \
beta as int \
);
Note that the \ is used until the ;
Scot P. Floess wrote:
Can you elaborate more on the error?
Some years ago I was using the sql task and ha
Can you elaborate more on the error?
Some years ago I was using the sql task and had a file full of SQL
statements... When I tried to use the sql task I was getting errors as
well. The solution, if memory serves, is that I had to use a \
character at the end of each line until SQL terminati
using the sql task's src attribute i source a mysqldump file and it errors.
mysql can source the file with no problems.
but in ant I source it and theres a syntax error.
There is no delimiter being set in the source.
also if take individually two insert statement and source those it works.
but i c
17 matches
Mail list logo
