Re: Example: error loading a mysqldump file

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

Re: Example: error loading a mysqldump file

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

Re: Example: error loading a mysqldump file

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

Re: Example: error loading a mysqldump file

SqlExec is full of bugs (see the bugzilla database). Try using keepformat="true" Peter On 10/25/06, Scot P. Floess <[EMAIL PROTECTED]> wrote: Hunter: OK, I see what you are saying now... Sorry :( Apparently I wasn't paying attention to what you were saying... Its odd to me the implementatio

Re: Example: error loading a mysqldump file

Hunter: OK, I see what you are saying now... Sorry :( Apparently I wasn't paying attention to what you were saying... Its odd to me the implementation isn't taking the character stream verbatim and hading through to JDBC - thus allowing JDBC to parse and do the right thing...so I guess Ant

Re: Example: error loading a mysqldump file

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

Re: Example: error loading a mysqldump file

It is treating each line as ONE sql statement. By using the -line continuation- character, it should fix the problem - namely the \ character. So? I gave 2 statements each on its own line. the problem is that ant thinks the string inside the first quote is an actual sql comment the problem is

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 continuation- character, it should fix the problem - namely the \ character. Placing SQL statements in a file makes perfect sense...perhaps he is trying to pu

Re: Example: error loading a mysqldump file

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

Re: Example: error loading a mysqldump file

Hunter If Im not mistaken I think you just answered your own question so when you put all the SQL statements together on one line then ant can parse the SQL if you break the SQL apart with some varying number of unknown delimiters ant cannot understand your file contents if you absolutely must u