Problems with table creation in jboss3.0

[anakin]

Hi everybody !!
I'm facing two problems in jaws.xml:
1) i want to create tables according to the name specified in jaws.xml(I specified the name <table-name> tag).
but by default, JAWS creates the tables . The name of the table is the ejb-name of the bean, and the name of the columns will be the names of the CMP fields.
I dont want the name of the tables to be name of my entity beans !! How do i go about it.

2) Even if i dont want to create tables ,the container creates tables .How do i avoid this ?.I have already changed the settings in jaws.xml which i included in my jar.

Thanks in advance

[davidjencks]

maybe you are using cmp2 and should look in jbosscmp-jdbc.xml instead.

[anakin]

Hi David thanks for the reply.
yes i'm using cmp2 ,but i have also changed the settings in jbosscmp-jdbc.xml ("<create-table>false</create-table>")
Still its creating those tables.

[giorgio42]

You have to put the <create-table> and other properties
inside a element at the top.

Two suggestions:
- JBoss should issue a warning when JAWS
is used with CMP 2.x (or even a deployment exception)
- Throw a deployment exception instead of silently
ignoring the settings (or not ignore them).

Georg

[ppetit]

Hi
I'm using CMP 2.0 with JBoss 3.0.0 alpha and this entry works fine :

...

<ejb-name>Meal</ejb-name>
<remove-table>false</remove-table>
<cmp-field>
<cmp-field-name>mealType</cmp-field-name>
<column-name>MEALTYPE</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(24)</sql-type>
</cmp-field>

...

note I'm using <remove-table> tag instead of <create-table>

Hope this helps.
Philippe