Hi, I've a problem with a MySQL query fulltext to search a word into a text field on DB..

If I set the field as VARCHAR 255, all works very well, but I need more than 255 chars for this field, so cannot use VARCHAR....

If I use TEXT with 500 char, I receive "org.hibernate.MappingException: No Dialect mapping for JDBC type: -1"

I can use VARCHAR or TEXT types only for fulltext search..

Can you help me?

thanks



Hibernate version: 3.1.3

Mapping documents:
<class name="it.occasioni.dbmapping.Annuncio" table="annunci" catalog="occasioni">
<id name="idAnnuncio" type="java.lang.Integer">
<column name="idAnnuncio" />
<generator class="native" />
</id>
<property name="testo" type="java.lang.String">
<column name="testo" length="500" not-null="true" />
</property>
.
.
.other properties

SQL Native Query for Spring:

<sql-query name="getAnnunciCategoriaSelezionataByChiave"><![CDATA[
SELECT DISTINCT a.*
FROM annunci a
WHERE MATCH(testo) AGAINST(:chiave)
]]>
</sql-query>



Full stack trace of any exception that occurs:
2006-07-07 16:35:38,968 [http-8080-Processor24] ERROR it.occasioni.actions.PortaleAction - Ricerca annuncio per categoria: No Dialect mapping for JDBC type: -1; nested exception is org.hibernate.MappingException: No Dialect mapping for JDBC type: -1

Name and version of the database you are using:
EasyPHP 1.8 (MySQL 4.1.9)
Apache Tomcat/5.0.28
MySQL connector 3.1.13
JDK 1.4.2.11
Struts/Spring

The generated SQL (show_sql=true):
CREATE TABLE `annunci` (
`idAnnuncio` int(8) NOT NULL auto_increment,
`testo` text NOT NULL,
`dataInserimento` date NOT NULL default '0000-00-00',
`dataUltimaModifica` date NOT NULL default '0000-00-00',
`tipoAnnuncio` int(1) NOT NULL default '0',
`numeroPubblicazioni` int(3) NOT NULL default '1',
`note` varchar(80) default NULL,
`idStato` int(1) NOT NULL default '0',
PRIMARY KEY (`idAnnuncio`),
FULLTEXT KEY `testo` (`testo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

Hi, fedo. I think the reason Hibernate is complaining about your TEXT datatype is that you're not providing it with any clues about the column's type in your mapping document. Try changing:



to:


I'm not sure the "length" attribute will do anything, since I wasn't aware you could constrain MySQL's TEXT datatype, but if I recall correctly, Hibernate will understand how to translate the "CLOB" type to MySQL. Unfortunately, I don't currently have MySQL installed anywhere locally to test this theory.

Be sure to let me know if this worked! :)

Thanks, but doens't work..

I've created my dialect:



and I've mapped it into hibernate config:




NOW WORKS!!!

Bye

The prop tag that u have used how to incorporate that in the hibernate config file
and should i use that CLOB code as well with the mysql dialect