IMO you are correct that the db config is correct. It looks like the titleID is getting mapped to a BLOB column. Maybe it is seen as a plain java object that is getting serialized???
Hi... Thanks for the quick response! My primary key is a serializable java object. (Doesn't seem to be many examples/people which use this approach). It always works when I use the hypersonic db. The primary key object get stored as a blob. It also used to work when I used MySQL with CMP1. Are there any problems with having 'custom' objects as your primary key class when using MySQL etc? It I convert the primary to use an Integer for example everything works fine.
I have included an extract of my ejb-jar file below. Maybe it will help...
Most databases won't let you use a blob as a primary key, because you can't index a blob.
By the look of things MySQL does allow a primary key data type to be larger 255. After careful consideration I have decided to change my approach with regard to using 'custom' java objects as primary keys. I am going to go the unique OID route. I don't want to have to limit my choice in databases because to primary key/indexing restrictions.
Thanks for all the help.