It depends on the database you are using. For example, you could use LONGVARCHAR, or TEXT, or, finally, CLOB. Check the docs for your database supported types.

:- ) wrote:

Thanks so much Alex,

I actually am using standardjbosscmp-jdbc.xml, got a bit confused, sorry!

Anyway, bad news is when I try to deploy using

* @ejb.persistence

* column-name="longString"

* jdbc-type="VARCHAR"

* sql-type="VARCHAR(512) BINARY"

I get an error from Jboss saying:

org.jboss.deployment.DeploymentException: Error while creating table t_account; - nested throwable: (java.sql.SQLException: Invalid argument value, message from server: "Too big column length for column 'longString' (max = 255). Use BLOB instead")

this seems to imply that all I can do is use a blob! Any idea?

thanks again so much,

brian





------------------------------------------------------- This SF. Net email is sponsored by: GoToMyPC GoToMyPC is the fast, easy and secure way to access your computer from any Web browser or wireless device. Click here to Try it Free! https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to