Michael TALLET wrote:
None : it's a legacy system (bad designed, no primary keys, no constraints at
all, char columns)
In a perfect world I would have primary keys, varchar columns...
Hmmm.... sounds familiar.... :-(
b
____________________
Michael Tallet
Delta Informatique
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors
Envoyé : vendredi 6 janvier 2006 17:01
À : [email protected]
Objet : Re: How to deal with a char column in select statement
Just curious: What is the added value of using CHAR instead of VARCHAR
in this case?
Larry
On 1/6/06, Michael TALLET <[EMAIL PROTECTED]> wrote:
Hi,
I have to query on tables which have CHAR columns (length 5 for example) as
ID.
Let's say we have some lines with these ID values : XXXXX, YYYYY, ZZZ [2
white spaces at the end]. As u can see there is no restriction about the
length of the value : it can less than five characters.
Here is my select statement in a sql map config file :
<select id="select1" parameterClass="string" parameterMap="result-map" >
Select id, lib1, lib2 from myTable where id = #value#
</select>
Here is the problem : if I use the value "ZZZ" as parameter value then the
statement finds no result. I must pass "ZZZ " value to make the query ok
My connection (an oracle connection actually) has the
"fixed[Default]String" property set to true, provided by an initial
properties file.
The strange thing is : the query (with this "ZZZ" value) works fine with a
spring class like JdbcTemplate
Any help is greatly appreciated
Regards,
____________________
Michael Tallet
Delta Informatique
