I imported data from sqlserver to mysql and I mapped it with an hibernate persistant object. when I try to get a collection of records from this table, I always get following error(it only appears in my jboss console windows):
[STDOUT] Error:identifier of an instance of com.xxx.Test1 altered from 30F423C8-E678-426E-91F7-1D76199E168D
[CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc

However, my program can still get the data without throwing an error. here is the ID type i am using:
<id
name="uniqID"
column="uniqID"
type="java.lang.String"
>
<generator class="assigned">
</generator>
</id>

the strange thing is it sometimes returns the result, but sometimes it doesn't. for example, I run my unit test for 10 time, I got about 4 times passed, but 6 times throwing an error. can someone help me?

I suspect you are not closing your sessions properly somewhere. Please check for that.

I've sloved this problem by adding another auto-increment column and change it to the primary key.
it seems Hibernate doesn't support long string as the primary key. I've tried using "uuid.string" and "assigned". both were not supported by hibernate because my primary key is about 36 charecters.

This is nonsense, of course.

uuid is usually about 36 charecters, e.g. 30F423C8-E678-426E-91F7-1D76199E168D

I remember it was supported when I use sql server. since I changed to mysql, it doesn't support it anymore.

any idea?