[JBoss-user] [Persistence & CMP/JBoss] - Re: Jboss 4.02 CMP EntityBean. JBoss creates TABLES in MySQL

[natgross <nu...@jb...>]

. alas... no go.
Please, here is a copy of my ejb-jar.xml. (The name of the sql table is `TypeG`.)

  | <?xml version="1.0" encoding="UTF-8"?>
  | <ejb-jar version="2.1" xmlns="http://java.sun.com/xml/ns/j2ee" 
  | xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  | xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
  | http://java.sun.com/xml/ns/j2ee/ejb-jar_2_1.xsd">
  | 
  |   <display-name>ZTypeG2</display-name>
  |   <enterprise-beans>
  |     <session>
  |       <display-name>TypeGfacadeSB</display-name>
  |       <ejb-name>TypeGfacadeBean</ejb-name>
  |       <home>dbTest.TypeGfacadeRemoteHome</home>
  |       <remote>dbTest.TypeGfacadeRemote</remote>
  |       <ejb-class>dbTest.TypeGfacadeBean</ejb-class>
  |       <session-type>Stateful</session-type>
  |       <transaction-type>Container</transaction-type>
  |       <ejb-local-ref>
  |         <ejb-ref-name>ejb/TypeGBean</ejb-ref-name>
  |         <ejb-ref-type>Entity</ejb-ref-type>
  |         <local-home>dbTest.TypeGLocalHome</local-home>
  |         <local>dbTest.TypeGLocal</local>
  |         <ejb-link>TypeGBean</ejb-link>
  |       </ejb-local-ref>      
  |     </session>
  |     <entity>
  |       <description>TypeG Entity Bean.</description>
  |       <display-name>TypeGEB</display-name>
  |       <ejb-name>TypeGBean</ejb-name>
  |       <local-home>dbTest.TypeGLocalHome</local-home>
  |       <local>dbTest.TypeGLocal</local>
  |       <ejb-class>dbTest.TypeGBean</ejb-class>
  |       <persistence-type>Container</persistence-type>
  |       <prim-key-class>java.lang.Integer</prim-key-class>
  |       <reentrant>false</reentrant>
  |       <abstract-schema-name>TypeG</abstract-schema-name>
  |       <cmp-field>
  |         <field-name>id</field-name>
  |       </cmp-field>
  |       <cmp-field>
  |         <field-name>valueType</field-name>
  |       </cmp-field>
  |       <primkey-field>id</primkey-field>
  |       <query>
  |         <description>find By Id</description>
  |         <query-method>
  |           <method-name>findById</method-name>
  |           <method-params>
  |             <method-param>java.lang.Integer</method-param>
  |           </method-params>
  |         </query-method>
  |         <ejb-ql>SELECT OBJECT(t) FROM TypeG AS t WHERE t.id = ?1</ejb-ql>
  |       </query>
  |       <query>
  |         <description>findByValueType</description>
  |         <query-method>
  |           <method-name>findByValueType</method-name>
  |           <method-params>
  |             <method-param>java.lang.String</method-param>
  |           </method-params>
  |         </query-method>
  |         <ejb-ql>SELECT OBJECT(t) FROM TypeG AS t WHERE t.valueType = ?1</ejb-ql>
  |       </query>
  |       <query>
  |         <query-method>
  |           <method-name>findAll</method-name>
  |           <method-params/>
  |         </query-method>
  |         <ejb-ql>SELECT OBJECT(o) FROM TypeG o</ejb-ql>
  |       </query>
  |     </entity>
  |   </enterprise-beans>
  |   <assembly-descriptor>
  |     <container-transaction>
  |       <method>
  |         <ejb-name>TypeGBean</ejb-name>
  |         <method-name>*</method-name>
  |       </method>
  |       <trans-attribute>Required</trans-attribute>
  |     </container-transaction>
  |     <container-transaction>
  |       <method>
  |         <ejb-name>TypeGfacadeBean</ejb-name>
  |         <method-name>*</method-name>
  |       </method>
  |       <trans-attribute>Required</trans-attribute>
  |     </container-transaction>
  |   </assembly-descriptor>
  | </ejb-jar>
  | 

And the relevant records from the jbosscmp-jdbc.xml:

  | <enterprise-beans>
  | 		<entity>
  | 			<ejb-name>TypeGBean</ejb-name>
  | 			<table-name>TypeG</table-name>
  | 		</entity>		
  | 	</enterprise-beans>
  | 

Again, Thank you much.
-nat


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3883000#3883000

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3883000