create table question

ronster Feb 16, 2002 8:43 AM

CMP automatically created tables always seems to use the data types in the default mappings

eg VARCHAR's are always created with size 255

is there a way of overwriting this on a per field basis?

I having this in my jaws.xml

<cmp-field>
<field-name>city</field-name>
<column-name>city</column-name>
<sql-type>VARCHAR(30)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>

under the entity tag for the bean but it doesn't make any difference

I'm using a mysql database

1. Re: create table question

davidjencks Feb 16, 2002 1:46 PM (in response to ronster)

just to check... you got rid of the old, wrong version of the table each time you tried this?
Actions
2. Re: create table question

giorgio42 Feb 16, 2002 6:03 PM (in response to ronster)

And make sure, you switch to jbosscmp-jdbc.xml,
if you are using CMP2.0. With CMP2.0 your jaws.xml settings will be silently ignored.

Georg
Actions
3. Re: create table question

ronster Feb 17, 2002 2:49 AM (in response to ronster)

I've been removing the tables first

and I'm not using CMP 2.0, should I?
Actions

Go to original post