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

Hibernate version: 2.1.6

I am having one table

CREATE TABLE tableA (
table_id varchar(10) NOT NULL default '',
....
PRIMARY KEY (table_id)
);

So here , primary key is on table_id which is of type varchar .

I have mapped this table as shown below :

<class name="A" table="tableA">
<cache usage="read-write"/>

<id name="tableId" column="table_id" unsaved-value="">
<generator class="assigned"/>
</id>
..................
</class>

table_id is case insentitive .

I am using ehche 0.9

My problem is when I specify tableId as "ABC" and as "abc" while fetching it from database , two
entries are being made in the ehcache one for "ABC" and other for "abc" due to that I do not get proper record while
fetching it from the database.
I think the problem is that key for the cache is case sensitive . So it is treating "ABC" and "abc" as differently .
Please help me .
Tx in advance .



Name and version of the database you are using: MySQL 4.0.22

Maybe you should try change the setter of table id as follows

public void setTableID( String ID ){
this._ID = (ID != null )? ID.toLowerCase() : ID;
}

Doing this will make it impossible for your IDs to have different cases and thus EH Cache won't have the same trouble.

Good Luck!