[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1483?page=c...
]
Lars Michele commented on HHH-1483:
-----------------------------------
Hi Gail,
I don't see the necessity for a testcase. Even if the problem occurs with MySQL, it is
not MySQL specific.
A look in Dialect.java shows, what for HibernateTypes are registered:
// register hibernate types for default use in scalar sqlquery type auto detection
registerHibernateType maps java.sql.types to HibernateTypes, but some are missing, what
generates the No Dialect mapping for JDBC type exception.
The missing java.sql.types are
ARRAY, BOOLEAN, DATALINK, DISTINCT, JAVA_OBJECT, LONGVARBINARY, LONGVARCHAR, NULL, OTHER,
REF and STRUCT.
So whenever a native query returns some of these types, an exception is thrown.
Mappable to Hibernate are the following:
registerHibernateType( Types.LONGVARBINARY, Hibernate.BLOB.getName() );
registerHibernateType( Types.LONGVARCHAR, Hibernate.TEXT.getName() );
registerHibernateType( Types.BOOLEAN, Hibernate.BOOLEAN.getName() );
Related issues:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1806
got fixed in the same manner and fixed also (even if not remarked):
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1468
Have a nice weekend,
Lars
MySQL5: No Dialect mapping for JDBC type: -1
--------------------------------------------
Key: HHH-1483
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1483
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.2
Environment: MySQL 5.0.18-nt
Reporter: Sergey Vladimirov
Priority: Minor
Attachments: hhh-1483-patch.txt
MySQL5: No Dialect mapping for JDBC type: -1
SELECT answpos,answer FROM votes_answers WHERE question=? ORDER BY answpos
mysql> describe votes_answers;
+----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| question | int(11) | NO | MUL | | |
| answpos | int(11) | NO | | | |
| answer | text | YES | | NULL | |
+----------+---------+------+-----+---------+-------+
mysql> describe temp;
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| answpos | int(11) | NO | | 0 | |
| answer | text | YES | | NULL | |
+---------+---------+------+-----+---------+-------+
Please, let me know what to add to MySQL5Dialect :)
Will it be ok to add? :
registerColumnType( Types.LONGVARCHAR, "text" );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira