4:14 p.m.
HibernateException in mysql Found: bit, expected: boolean
---------------------------------------------------------
Key: HHH-6935
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6935
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.Final
Environment: spring jpa hibernate project above mysql 5.1
Reporter: orasio spieler
Attachments: hib4-check.zip
Found the problem i also got org.hibernate.HibernateException: Wrong column type ...
Found: bit, expected: boolean
on BooleanType in hibernate 4 they changed the Ctor to
public BooleanType() {
this( org.hibernate.type.descriptor.sql.BooleanTypeDescriptor.INSTANCE,
BooleanTypeDescriptor.INSTANCE );
}
instead of old versions
public BooleanType() {
this( BitTypeDescriptor.INSTANCE, BooleanTypeDescriptor.INSTANCE );
}
spieler.orasio(a)gmail.com
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:53 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6935?page=c...
]
Torsten Krah commented on HHH-6935:
-----------------------------------
Workaround is to use a custom dialect which does map the boolean type to a bit(1) type
which does result in the "old" behaviour:
public class MyDialect extends MySQL5InnoDBDialect {
public MyDialect() {
super();
registerColumnType(Types.BOOLEAN, "bit(1)");
}
}
Now validate passes and all is like before, i'll hope, correct me if not, at least it
works for me.
HibernateException in mysql Found: bit, expected: boolean
---------------------------------------------------------
Key: HHH-6935
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6935
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.Final
Environment: spring jpa hibernate project above mysql 5.1
Reporter: orasio spieler
Labels: BooleanType, mysql
Attachments: hib4-check.zip
Found the problem i also got org.hibernate.HibernateException: Wrong column type ...
Found: bit, expected: boolean
on BooleanType in hibernate 4 they changed the Ctor to
public BooleanType() {
this( org.hibernate.type.descriptor.sql.BooleanTypeDescriptor.INSTANCE,
BooleanTypeDescriptor.INSTANCE );
}
instead of old versions
public BooleanType() {
this( BitTypeDescriptor.INSTANCE, BooleanTypeDescriptor.INSTANCE );
}
spieler.orasio(a)gmail.com
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:11 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
[
https://hibernate.onjira.com/browse/HHH-6935?page=com.atlassian.jira.plug...
]
Manthos commented on HHH-6935:
------------------------------
IMHO priority Critical or Blocker... spring, hibernate, mysql are very common
environment...
HibernateException in mysql Found: bit, expected: boolean
---------------------------------------------------------
Key: HHH-6935
URL: https://hibernate.onjira.com/browse/HHH-6935
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.Final
Environment: spring jpa hibernate project above mysql 5.1
Reporter: orasio spieler
Labels: BooleanType, mysql
Attachments: hib4-check.zip
Found the problem i also got org.hibernate.HibernateException: Wrong column type ...
Found: bit, expected: boolean
on BooleanType in hibernate 4 they changed the Ctor to
public BooleanType() {
this( org.hibernate.type.descriptor.sql.BooleanTypeDescriptor.INSTANCE,
BooleanTypeDescriptor.INSTANCE );
}
instead of old versions
public BooleanType() {
this( BitTypeDescriptor.INSTANCE, BooleanTypeDescriptor.INSTANCE );
}
spieler.orasio(a)gmail.com
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:47 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
[
https://hibernate.onjira.com/browse/HHH-6935?page=com.atlassian.jira.plug...
]
Jan Hodac commented on HHH-6935:
--------------------------------
I have similar problem with this change on MSSQL. When i use HQL query
{code}
session.createQuery("select cast(:p as boolean) from
SomeTable").setBoolean("p", true).uniqueResult();
{code}
on hibernate 3.6.8 its OK but on hibernate 4.0.0.Final results in
{code}
org.hibernate.exception.SQLGrammarException: Type boolean is not a defined system type.
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
{code}
3.6.8 SQL: select cast(? as tinyint) as col_0_0_ from ....
4.0.0 SQL: select cast(? as boolean) as col_0_0_ from ....
I agree with [~Manthos] that this issue is more than Major priority
HibernateException in mysql Found: bit, expected: boolean
---------------------------------------------------------
Key: HHH-6935
URL: https://hibernate.onjira.com/browse/HHH-6935
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.Final
Environment: spring jpa hibernate project above mysql 5.1
Reporter: orasio spieler
Labels: BooleanType, mysql
Attachments: hib4-check.zip
Found the problem i also got org.hibernate.HibernateException: Wrong column type ...
Found: bit, expected: boolean
on BooleanType in hibernate 4 they changed the Ctor to
public BooleanType() {
this( org.hibernate.type.descriptor.sql.BooleanTypeDescriptor.INSTANCE,
BooleanTypeDescriptor.INSTANCE );
}
instead of old versions
public BooleanType() {
this( BitTypeDescriptor.INSTANCE, BooleanTypeDescriptor.INSTANCE );
}
spieler.orasio(a)gmail.com
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:41 a.m.
New subject: [Hibernate-JIRA] (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
4:44 a.m.
New subject: [Hibernate-JIRA] (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
9:18 a.m.
New subject: [Hibernate-JIRA] (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
9:27 a.m.
New subject: [Hibernate-JIRA] (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
6:17 p.m.
New subject: [Hibernate-JIRA] (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
12:51 p.m.
New subject: [Hibernate-JIRA] (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
12:57 p.m.
New subject: [Hibernate-JIRA] (HHH-6935) HibernateException in mysql Found: bit, expected: boolean
4056
days inactive
4489
days old
hibernate-issues@lists.jboss.org
10 comments
8 participants
participants (8)
-
Brett Meyer (JIRA) -
Christoph Keimel (JIRA)
-
Jan Hodac (JIRA)
-
josef (JIRA)
-
Manthos (JIRA)
-
Martin Garton (JIRA)
-
orasio spieler (JIRA)
-
Torsten Krah (JIRA)