jboss template and MySql

[pjdc_00]

Anyone put jboss template project working with MySQL database? e need some help?

the file .ant.properties come with 2 options:
with this one:
"datasource.name=java:/DefaultDS"
everything ok:
" [test/TestEntity] Created table 'TESTENTITY' successfully."

but with: "datasource.name=java:/MySqlDS"
the jbosscmp-jdbc.xml is generate with this:
"java:/MySqlDS
<datasource-mapping>Hypersonic SQL</datasource-mapping>"
its ok MySqlDS with Hypersonic mapping?

and when jboss deploy it:
" Too big column length for column 'First_Name' (max = 255). Use BLOB instead)]

Any ideia for this? i think i miss some configurations... (the file mysql-service.xml its configured)

Thanks again,

Pedro Cardoso

[junkmail]

use the "mySql" type mapping from the standardjbosscmp-jdbc.xml in the /conf directory