hi all,
I'm having a problem persisting a java.lang.Boolean to a mysql database. Hibernate seems to try to perist this as either 't' or 'f' which mysql ignores.
I'm using mysql 4 and hibernate 2.

The mapping is as follows :



and the relevant log file is :

2004-07-01 16:32:41,092 DEBUG [net.sf.hibernate.type.StringType] binding '111' to parameter: 1
2004-07-01 16:32:41,093 DEBUG [net.sf.hibernate.type.StringType] binding 'MT' to parameter: 2
2004-07-01 16:32:41,093 DEBUG [net.sf.hibernate.type.BooleanType] binding 'true' to parameter: 3
2004-07-01 16:32:41,093 DEBUG [net.sf.hibernate.type.StringType] binding 'ff808081fd7b7bcc00fd7b7d57700002' to parameter: 4
2004-07-01 16:32:41,093 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 5
2004-07-01 16:32:41,093 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 6
2004-07-01 16:32:41,094 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 7
2004-07-01 16:32:41,094 DEBUG [net.sf.hibernate.type.StringType] binding 'ff808081fd7b7bcc00fd7b7e36dd0003' to parameter: 8
2004-07-01 16:32:41,094 DEBUG [net.sf.hibernate.impl.BatcherImpl] Adding to batch
2004-07-01 16:32:41,094 DEBUG [net.sf.hibernate.impl.BatcherImpl] Executing batch size: 1
2004-07-01 16:32:41,125 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
:
:

everything seems to be fine but the sql sent to MySql is :

update hbm_ratecategory set categoryName='111', billType='MO', rpSettable='t',........

mysql ignores the 't' as it is expecting a tinyint. (1 or 0)

not sure if this has anything to do with the 'yes_no' type in hibernate but i want hibernate to just put 1 or 0 in the database.

any ideas or soluitions greatly appreciated.

cheers,
colum.

try using type="boolean"

hi michael,
i've tried setting the type to 'boolean' but this doesn't work either, i still get 't' in the sql that's sent to the database.
i've also upgraded to the latest mysql connector (mysql-connector-java-3.0.14-production-bin.jar) but no joy ;-(

any other ideas?, is this a bug? should i report it?
cheers,
colum.

I am quite sure type="boolean" uses ints - just look at the source. I am sure you are using a differnet type somewhere.

hi michael,
Thanks for your reply. Do you know where else i should look?

My mapping file is :




and the describe in mysql of the table is :

rpSettable tinyint(1)


i've turned on logging of the sql in mysql and the sql received definitly contains 't' instead of '1'.

not sure where else i need to check???

thanks,
colum.

You are mistaken.

hi gavin,
i don't doubt that i'm mistaken but have no idea where???? ;-(

i'm using the latest hibernate (2.1.4) and mysql (4.0.15)

my java code is as follows :

**snip **

i've also tried using java.lang.Boolean for the type.

i'm using xdoclet to generate the hibernate mapping file and it produces :



with hibernate logging turned on i get :



parameter 3 is the problem one, is the mapping correct here???
it all looks ok to me as i'm expecting a 'true' but it seems to go wrong from here on.

i've turned on logging in mysql to see the sql that it receives and it gets :



as you can see the 't' is the problem. ;-(
the definition of the table in mysql has a tinyint(1) for the column 'rpSettable'.

if you can see where i'm going wrong i'd greatly appreciate some help.

cheers,
colum.