Can someone please
tell me why the following entry in a jaws.xml file inside my entity bean's jar
continues to cause jboss to create the table in mysql (named workflowstoragebean
after the EJB) rather than using the one specified in the jaws file
(workflowejb)? When JBoss creates the table, it creates a BLOB rather than
LONGBLOB type for the column and thus limits me to 65k bytes, which is not what
I want. Thus, I have defined the tablename for the CMP but jboss ignores it.
<enterprise-beans>
<entity>
<ejb-name>WorkflowStorageBean</ejb-name>
<table-name>workflowejb</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<cmp-field>
<field-name>workflowId</field-name>
<column-name>workflowId</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(64)</sql-type>
</cmp-field>
<cmp-field>
<field-name>data</field-name>
<column-name>data</column-name>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>
</cmp-field>
</entity>
</enterprise-beans>
<entity>
<ejb-name>WorkflowStorageBean</ejb-name>
<table-name>workflowejb</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<cmp-field>
<field-name>workflowId</field-name>
<column-name>workflowId</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(64)</sql-type>
</cmp-field>
<cmp-field>
<field-name>data</field-name>
<column-name>data</column-name>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>
</cmp-field>
</entity>
</enterprise-beans>
Thanks,
James
