Re: migration tools support sql comment

2009-08-13 Thread Clinton Begin
Then should support all comment styles from various databases... We don't want DB specific stuff in iBATIS. Clinton On Thu, Aug 13, 2009 at 9:21 AM, Guoyou Jiang wrote: > ok, thanks, > but i think when read line from file, we can search this line, if contains > "--" , just use substring to cut t

Re: migration tools support sql comment

2009-08-13 Thread Guoyou Jiang
ok, thanks, but i think when read line from file, we can search this line, if contains "--" , just use substring to cut the comment begin with "--". 2009/8/13 Clinton Begin > the problem is that many JDBC drivers have problems with newline > characters. So we have to put the SQL all in one line

Re: migration tools support sql comment

2009-08-13 Thread Clinton Begin
the problem is that many JDBC drivers have problems with newline characters. So we have to put the SQL all in one line. I think there's an open request to make it optional, and if I recall correctly, in iBATIS 3 I send the statement as is... so we'll see how many JDBC drivers/databases still have

migration tools support sql comment

2009-08-13 Thread Guoyou Jiang
seems if the sql file contains comment at line end will cause error, like this: CREATE TABLE groups ( id bigserial NOT NULL, *--the primary key* group_code varchar(50),* --code* group_name varchar(50) NOT NULL, group_type varchar(100) N