Hi (ni hao :)),
Sounds like a problem with mySQL and character encoding. I haven't used mySQL before, but I believe you can use the parameters:
1) useUnicode : should the driver use Unicode character encodings when handling strings? (true/false) false
2) characterEncoding : if useUnicode is true, what character encoding should the driver use when dealing with strings? none
Are you setting the "useUnicode" parameter in the properties for the datasource that is being used with CMP?
But the jboss will throw exception in this way!
Now I had resolve this problem!
I've encountered the same problem as you, would you mind telling me how you solved the problem?
I have the similar problem. Would you please share your solution?
As a Chinese i suggest you should present your way.It is not friendly to say i have resolved it !
<config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/DBName?useUnicode=true&characterEncoding=Big5</config-property>
<config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String">name</config-property>
<config-property name="Password" type="java.lang.String">password</config-property>