Java Mailing List Archive

http://www.ant-tasks.com/

Apache Ant Archive

» Ant Users List
» Ant Developers List
Example: error loading a mysqldump file

Example: error loading a mysqldump file

2006-10-26       - By Scot P. Floess
Reply:     1     2     3     4     5     6     7     8     9     10     >>  

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 <sql> 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 taken ;)

Although, it still "feels" like there ought to be a way to hand off the
whole file's contents to the JDBC layer and do no parsing in the <sql> task.

Scot

Steve Loughran wrote:
> 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...perhaps he is
>> trying to put database creation, or population information there?  
>> I've done it before and I saw no reason why one wouldn't want to do
>> that...
>>
>> And, this isn't an issue of ctrl-M characters...  I had this problem
>> on a Linux system using a ViM created file under Linux...  Ant is
>> treating the newline as a delimiter for the SQL statement.
>>
>
> yes, how <sql> breaks tasks up is pretty messy. I think there are some
> bugs there with anything like a ; followed by whitespace not being
> picked up as a delimiter either.
>
> But I think part of the problem is that sql files found in the field
> are pretty messy too, because different databases handle different
> variations.
>
> -steve
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@(protected)
> For additional commands, e-mail: user-help@(protected)
>
>

--
Scot P. Floess
27 Lake Royale
Louisburg, NC  27549

252-478-8087 (Home)
919-754-4592 (Work)

Chief Architect JPlate  http://sourceforge.net/projects/jplate
Chief Architect JavaPIM http://sourceforge.net/projects/javapim


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)


©2008 ant-tasks.com - Jax Systems, LLC, U.S.A.