Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

Name and version of the database you are using:oracle

Hi all,
I use char(2) as primary key in my table in oracle,but I can not get the existing record using session.get(String entityName, Serializable id).

following is mapping file,I use dynamic-class

<class entity-name="A_TEST">
<id name="id" type="string">
<column name="id" sql-type="char(2)"/>
<generator class="assigned"/>
</id>
<property name="name" column="name" type="string"/>
</class>

following is my code:
...
session.get("A_TEST","1");
...
there is a record whose primary key is "1" certainly,why?

char fields in oracle are always same length and there isn't field '1', than '1 '
oracle add padding blank for char field automatic
Don't use it - use varchar2

regards

thx! But I can not alter the table structure..

then add padding blank before query or load

thx for your response!snpesnpe

But I can't catch your meaing of "then add padding blank before query or load",please explain in detail.thx!

call
session.get("A_TEST","1 "); // add blank after 1;
except
session.get("A_TEST","1");

Oracle add blank in char field - you can see this from sqlplus with ;

select id,length(id)
from a_test

length(id) is always 2 if column defined char(2)

regards