CMP in jboss with informix
annapurna Aug 24, 2004 3:43 PMHi,
I have worked quite a bit on BMP"s in jboss. CMP is new to me. I tried setting up all the necessary files. Jboss does throw any errors but does not return the correct results also. Can someone please review my files.
When I try to call FindAllAccounts I am getting a empty collection. In jboss deployment I see
InformixDS bound.Is there anything I am missing?
This is from server.log in jboss
15:07:34,524 INFO [MainDeployer] Starting deployment of package: file:/usr/local/jboss-3.0.8_tomcat-4.1.24/server/default/deploy/entitlements.jar
15:07:34,741 INFO [EJBDeployer]
Bean : agent
Section: 10.6.2
Warning: The entity bean class must be defined as public and abstract.
15:07:34,790 INFO [EjbModule] Creating
15:07:34,828 INFO [EjbModule] Deploying agent
15:07:35,680 INFO [JDBCInitCommand] Table 'agent' already exists
15:07:35,689 INFO [EjbModule] Created
15:07:35,694 INFO [EjbModule] Starting
15:07:35,716 INFO [EjbModule] Started
15:07:35,721 INFO [MainDeployer] Deployed package: file:/usr/local/jboss-3.0.8_tomcat-4.1.24/server/default/deploy/entitlements.jar
Does this mean informix is bound...
Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/InformixDS'
Any help is greatly appreciated.
I have pasted a part of my code here...
Deployment Descriptors...
<jbosscmp-jdbc>
java:/InformixDS
<datasource-mapping>InformixDB</datasource-mapping>
<enterprise-beans>
<ejb-name>agent</ejb-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<table-name>agent</table-name>
<cmp-field>
<field-name>userId</field-name>
<column-name>userid</column-name>
</cmp-field>
<cmp-field>
<field-name>password</field-name>
<column-name>password</column-name>
</cmp-field>
... and so on...
</jbosscmp-jdbc>
ejb-jar.xml
<ejb-jar >
<ejb-name>agent</ejb-name>
com.pinksheets.entitlements.ejb.AgentHome
com.pinksheets.entitlements.ejb.Agent
<ejb-class>com.pinksheets.entitlements.ejb.AgentBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.String</prim-key-class>
False
<cmp-version>2.x</cmp-version>
<abstract-schema-name>agent</abstract-schema-name>
<cmp-field > <field-name>userId</field-name></cmp-field>
<cmp-field > <field-name>password</field-name></cmp-field>
<query-method>
<method-name>findAllAccounts</method-name>
<method-params>
</method-params>
</query-method>
<ejb-ql>[CDATA[SELECT * FROM agent]]</ejb-ql>
... and so on...
What is this abstract-schema-name here? Should I also write findByPrimaryKey here in the query and what about insert/update statements?? Examples are not clear about this.
jboss.xml
<enterprise-beans>
<ejb-name>agent</ejb-name>
<jndi-name>xxx/Agent</jndi-name>
<configuration-name>Standard CMP EntityBean</configuration-name>
</enterprise-beans>