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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
