How to mapping mySQL TEXT type?

[andywyj]

How to mapping mySQL TEXT type in JAW? and How to print this type in ejb? tks

[fbiaggi]

Ciao,
VARCHAR, in EJB is a String.

ex.

<sql-type>TEXT</sql-type>
<jdbc-type>VARCHAR</jdbc-type>

[andywyj]

i try to use your reference but have runtime error:

TRANSACTION ROLLBACK EXCEPTION:Load failed;

so i try to use CLOB mapping TEXT


<java-type>java.sql.Clob</java-type>
<jdbc-type>CLOB</jdbc-type>
<sql-type>TEXT</sql-type>


but also have runtime error:

[wbcontentBean] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception is:

java.sql.SQLException: Unable to load a ResultSet column 6 into a variab
le of type 'java.sql.Clob': java.io.StreamCorruptedException: InputStream does n
ot contain a serialized object; nested exception is:
java.rmi.ServerException: Load failed; nested exception is:
java.sql.SQLException: Unable to load a ResultSet column 6 into a variab
le of type 'java.sql.Clob': java.io.StreamCorruptedException: InputStream does n
ot contain a serialized object

who can help me? tks

[fbiaggi]

We have many TEXT types fields, without problems.
Have you the latest mySQL and the latest mm JDBC drivers ?

[andywyj]

mySQL version is 3.23.38
JDBC Driver version is mm.mysql.jdbc 1.2c

[fbiaggi]

I think you should change your mm. drivers,
now at version 2.0.8

Ciao.