Hi,
I've just set up Mysql + Jboss on a Redhat 9 box. However, I keep getting the following error when I deploy my ejb's:
Invalid argument value, message from server: "Too big column length for column 'id' (max = 255). Use BLOB instead")]
My mysql-ds.xml contains the following:
<local-tx-datasource>
<jndi-name>RAPDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/rap</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>XXX</user-name>
XXX
</local-tx-datasource>
The strange thing is: I've already got this working on in my windows environment. Jboss and MySQL worked seamlessly in this configuration.
For my id's I use the xdoclet GUID (global unique ID's) generator. (see: http://xdoclet.sourceforge.net/bp.html) This generator generates 32 character strings.
Does anyone recognize this problem?
thanks in advance,
Ruben
I solved the problem myself. The <datasource-mapping> in jbosscmp-jdbc should have been mySQL instead of Hypersonic SQL. This was kinda obvious....