Has anyone successfully mapped a java.lang.String to a database type other
than CHAR or VARCHAR using mySQL?  We need to store large text values and
have been unable to get jaws to use TEXT, MEDIUMTEXT or LONGTEXT columns 
for the full round-trip. 

Our application requires that this work but as yet we have been unable to
make it happen.  We can construct a bean with jaws.xml defining one of
several text column types, the column will be created and we have no
problem calling the create() method on the home interface.  An instance is
created and placed in the datbase (external SQL queries verify that the
data is correctly input) however an attempt to find this record produces
an exception.

Before I go about pasting in all my xml configs (of which we've tried
numerous combinations) does anyone know of an sql-type/jdbc-type
combination that will make this work?  CMP Text fields of *longer* than
255 characters?

Thanks.

C=)

--------------------------------------------------------------------------
There are no significant bugs in our released software that any significant 
  number of users want fixed.  -Bill Gates, Focus Magazine, Oct 23, 1995
--------------------------------------------------------------------------
Caskey <caskey*technocage.com>       ///                   TechnoCage Inc.
--------------------------------------------------------------------------
        "Welcome to the slippery slope, here is your handbasket.
             ...say, can you work 70 hours this week?"




--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to