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 the problem!
On Thu, Aug 13, 2009 at 8:52 AM, Guoyou Jiang <guoyou.ji...@jsvest.com>wrote: > 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) NOT NULL, > parent_id bigint, > department_type varchar(50), > business_relation_type varchar(50), > business_relation_value varchar(50), > memo varchar(200), > PRIMARY KEY (id), > CONSTRAINT groups_parent_id_fkey FOREIGN KEY (parent_id) > REFERENCES groups (id) > ); > > can we support this type comment? thanks! >
