EJB 2.0 Deployment problem

[sunil kelkar]

This is with reference to the book - Oreilly's Enterprise JavaBeans 4th Edition, ISBN 0-596-00530-X

I am trying to run the Entity Bean of Chapter 4 in JBoss 4.0+ and mySQL. I have followed all the instructions given in the book.

However instead of titandb-ds.xml I have mysql-ds.xml file. I have also created and copied the file jbosscmp-jdbc.xml to the folder src\resources\META-INF This file has <datasource>java:/DefaultDS</datasource>

What changes do I need to do to the file Client_1.java, especially to the statement Object ref = jndiContext.lookup("CabinHomeRemote");

Are there any other changes, to make my client program work?

[Dave Salter]

What exactly are the problems you are getting?

[sunil kelkar]

When I run my client, it says DefaultDS not bound.
My application's files are as follows:
jndi.properties file is:

java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory
java.naming.factory.url.pkgs=org.jboss.naming :-o	 rg.jnp.interfaces
java.naming.provider.url=localhost

jboss.xml file is:

<?xml version="1.0"?>
<jboss>
     <enterprise-beans>
       <entity>
 <ejb-name>CabinEJB</ejb-name>
 <jndi-name>CabinHomeRemote</jndi-name>
       </entity>
     </enterprise-beans>
</jboss>

jbosscmp-jdbc.xml part of the file is:

<jbosscmp-jdbc>
   <defaults>
      <datasource>java:/DefaultDS</datasource>
      <datasource-mapping>mySQL</datasource-mapping>
      <create-table>true</create-table>
      <remove-table>true</remove-table>
   </defaults>
   <enterprise-beans>
      <entity>
         <ejb-name>CabinEJB</ejb-name>
         <table-name>Customer</table-name>

ejb-jar.xml part of the file is:

<ejb-jar>
 <enterprise-beans>
   <entity>
      <ejb-name>CabinEJB</ejb-name>
      <home>com.titan.cabin.CabinHomeRemote</home>
      <remote>com.titan.cabin.CabinRemote</remote>
      <ejb-class>com.titan.cabin.CabinBean</ejb-class>
      <persistence-type>Container</persistence-type>

My Client.java part of the file is:

         Context jndiContext = getInitialContext();
         //Object ref = jndiContext.lookup("CabinHomeRemote");
         Object ref = jndiContext.lookup("java:/DefaultDS");
         CabinHomeRemote home = (CabinHomeRemote)
            PortableRemoteObject.narrow(ref,CabinHomeRemote.class);

Where am I going wrong?

Originally posted by Dave Salter:
What exactly are the problems you are getting?

[Dave Salter]

What does your mysql-ds.xml look like. Have you deployed this to your deploy directory?

[Paul Sturrock]

Is your client running in the container? If not, how does your getInitialContext() method get a Context?

[sunil kelkar]

mysql-ds.xml file is there in the deploy folder of JBoss and here are it's contents:

<datasources>
  <local-tx-datasource>
    <jndi-name>DefaultDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/jboss</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password></password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
    <!-- sql to call on an existing pooled connection when it is obtained from pool 
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

Originally posted by Dave Salter:
What does your mysql-ds.xml look like. Have you deployed this to your deploy directory?

[sunil kelkar]

The client is not running in JBoss.

Originally posted by Paul Sturrock:
Is your client running in the container? If not, how does your getInitialContext() method get a Context?

[Paul Sturrock]

So how do you get your Context? Can you see your DataSource in JNDI with the jmx-console? Are there any errors in your server.log when the DataSource was created.
[ September 19, 2005: Message edited by: Paul Sturrock ]

[Dave Salter]

 Context jndiContext = getInitialContext();
         //Object ref = jndiContext.lookup("CabinHomeRemote");
         Object ref = jndiContext.lookup("java:/DefaultDS");
         CabinHomeRemote home = (CabinHomeRemote)
            PortableRemoteObject.narrow(ref,CabinHomeRemote.class); 

OK, I see. Why are you trying to lookup java:/DefaultDS on the client? This is not bound on the client, only on the server, so the error that you are getting is expected behaviour.

Have a look at this.

[sunil kelkar]

When I run, http://127.0.0.1:8080/jmx-console/ I can see:

jboss.j2ee

* jndiName=CabinHomeRemote,plugin=cache,service=EJB
* jndiName=CabinHomeRemote,plugin=pool,service=EJB
* jndiName=CabinHomeRemote,service=EJB

Also, I checked the server.log file, I did not find any problems related to DefaultDS. Also, here's an extract of server.log -

2005-09-19 16:26:47,527 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.CabinEJB] Initializing CMP plugin for CabinEJB
2005-09-19 16:26:47,577 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.CabinEJB] Loading standardjbosscmp-jdbc.xml : file:/F:/jboss-4.0.2/server/default/conf/standardjbosscmp-jdbc.xml
2005-09-19 16:26:47,998 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.CabinEJB] jar:file:/F:/jboss-4.0.2/server/default/tmp/deploy/tmp65109titan.jar!/META-INF/jbosscmp-jdbc.xml found. Overriding defaults
2005-09-19 16:26:49,440 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Insert Entity SQL: INSERT INTO Customer (ID, NAME, DECK_LEVEL, SHIP_ID, BED_COUNT) VALUES (?, ?, ?, ?, ?)
2005-09-19 16:26:49,440 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Entity Exists SQL: SELECT COUNT(*) FROM Customer WHERE ID=?
2005-09-19 16:26:49,440 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.CabinEJB] entity-command: [commandName=default,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
2005-09-19 16:26:49,450 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.CabinEJB] Remove SQL: DELETE FROM Customer WHERE ID=?
2005-09-19 16:26:49,500 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.CabinEJB] Executing SQL: CREATE TABLE Customer (ID INTEGER NOT NULL, NAME VARCHAR(250) BINARY, DECK_LEVEL INTEGER NOT NULL, SHIP_ID INTEGER NOT NULL, BED_COUNT INTEGER NOT NULL, CONSTRAINT pk_Customer PRIMARY KEY (ID))
2005-09-19 16:26:49,660 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.CabinEJB#findByPrimaryKey] SQL: SELECT t0_CabinEJB.ID FROM Customer t0_CabinEJB WHERE t0_CabinEJB.ID=?
2005-09-19 16:26:49,670 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.CabinEJB] Added findByPrimaryKey query command for home interface
2005-09-19 16:26:49,670 DEBUG [org.jboss.system.ServiceController] starting service jboss.j2ee:service=EJB,plugin=pool,jndiName=CabinHomeRemote
2005-09-19 16:26:49,670 DEBUG [org.jboss.ejb.plugins.EntityInstancePool] Starting jboss.j2ee:service=EJB,plugin=pool,jndiName=CabinHomeRemote
2005-09-19 16:26:49,670 DEBUG [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:service=EJB,plugin=pool,jndiName=CabinHomeRemote
2005-09-19 16:26:49,670 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.j2ee:service=EJB,plugin=pool,jndiName=CabinHomeRemote dependent components: []
2005-09-19 16:26:49,670 DEBUG [org.jboss.resource.connectionmanager.CachedConnectionInterceptor] start called in CachedConnectionInterceptor
2005-09-19 16:26:49,670 DEBUG [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=CabinHomeRemote,service=EJB
2005-09-19 16:26:49,670 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.j2ee:jndiName=CabinHomeRemote,service=EJB dependent components: []

Originally posted by Paul Sturrock:
So how do you get your Context? Can you see your DataSource in JNDI with the jmx-console? Are there any errors in your server.log when the DataSource was created.

[ September 19, 2005: Message edited by: Paul Sturrock ]

[sunil kelkar]

Does that mean, I cannot connect to this EJB from an external client? Very confusing.

Originally posted by Dave Salter:

 Context jndiContext = getInitialContext();
         //Object ref = jndiContext.lookup("CabinHomeRemote");
         Object ref = jndiContext.lookup("java:/DefaultDS");
         CabinHomeRemote home = (CabinHomeRemote)
            PortableRemoteObject.narrow(ref,CabinHomeRemote.class); 

<hr></blockquote>

OK, I see. Why are you trying to lookup java:/DefaultDS on the client? This is not bound on the client, only on the server, so the error that you are getting is expected behaviour.

Have a look at this.

[sunil kelkar]

One more thing, if I modify my client have something like this -

         Context jndiContext = getInitialContext();
         Object ref = jndiContext.lookup("CabinHomeRemote");

then I guess it is inserting a record in the default Hypersonic database table, Cabin and not in the mySQL database table, Cabin. More confusion!

[Paul Sturrock]

Does that mean, I cannot connect to this EJB from an external client?

No, but it does mean you can't connect to the DataSource (as you are trying) from a client.

then I guess it is inserting a record in the default Hypersonic database table

No. Unless your Cabin Entity Bean uses the default Hypersonic DataSource?

[sunil kelkar]

The basic problem still persists - I am unable to add arecord into the mySQL based Cabin table. What should I do?

Originally posted by Paul Sturrock:

No. Unless your Cabin Entity Bean uses the default Hypersonic DataSource?

[Paul Sturrock]

So can you now successfully lookup your entity bean? If this is the case, look at your entity bean mapping. Double-check the table-name you have mapped this bean to. It will never insert into a "cabin" table as it is currently defined.