ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: example for mapping CHAR(n) to String
Date Sat, 17 Sep 2005 12:30:58 GMT
Does the query work with plain JDBC? In MS SQL "TABLE" is a reserved
keyword and should be escaped using "[TABLE]".

Niels

-----Original Message-----
From: Joachim Hoffmann [mailto:j.hoffmann@mine-it.at] 
Sent: woensdag 14 september 2005 19:10
To: user-java@ibatis.apache.org
Subject: example for mapping CHAR(n) to String

Could someone point me to an example how to map a limited text field to 
a string?
I couldn't get it to work for CHAR(n)..

VARCHAR works fine,

but
COMMENT CHAR(30)
...
insert into TABLE (comment) VALUES (#comment#)
...
doesn't work for me.
iBaits returns with a "general error" and advises to check the 
ParameterMap of the insert-statment.

Regards,
JoHo


Mime
View raw message