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
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
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
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