Any chance you are using cmp2 in enough places so that jbosscmp-jdbc.xml
would be the place to specify this?  I think the pm (jaws/cmp2) is
specified somewhere in the container configuration.

david jencks

On 2002.04.23 19:05:20 -0400 James Higginbotham wrote:
> 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>
> 
>  
> Thanks,
> James
> 
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD><TITLE>Message</TITLE>
> <META http-equiv=Content-Type content="text/html; charset=us-ascii">
> <META content="MSHTML 6.00.2715.400" name=GENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=794470023-23042002><FONT face=Arial size=2>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. 
> </FONT></SPAN></DIV>
> <DIV><SPAN class=794470023-23042002><FONT face=Arial 
> size=2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=794470023-23042002><FONT face=Arial 
> 
>size=2>&nbsp;&lt;enterprise-beans&gt;<BR>&nbsp;&nbsp;&lt;entity&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;ejb-name&gt;WorkflowStorageBean&lt;/ejb-name&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;table-name&gt;workflowejb&lt;/table-name&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;create-table&gt;false&lt;/create-table&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;remove-table&gt;false&lt;/remove-table&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;cmp-field&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;field-name&gt;workflowId&lt;/field-name&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;column-name&gt;workflowId&lt;/column-name&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 
> &lt;jdbc-type&gt;VARCHAR&lt;/jdbc-type&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 
> 
>&lt;sql-type&gt;VARCHAR(64)&lt;/sql-type&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;/cmp-field&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;cmp-field&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;field-name&gt;data&lt;/field-name&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;column-name&gt;data&lt;/column-name&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 
> 
>&lt;jdbc-type&gt;JAVA_OBJECT&lt;/jdbc-type&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 
> 
>&lt;sql-type&gt;BLOB&lt;/sql-type&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;/cmp-field&gt;<BR>&nbsp;&lt;/entity&gt;<BR>&nbsp;&lt;/enterprise-beans&gt;<BR></FONT></SPAN></DIV>
> <DIV><SPAN class=794470023-23042002><FONT face=Arial 
> size=2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=794470023-23042002><FONT face=Arial 
> size=2>Thanks,</FONT></SPAN></DIV>
> <DIV><SPAN class=794470023-23042002><FONT face=Arial 
> size=2>James</DIV></FONT></SPAN></BODY></HTML>
> 

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to