EJB problem

[Chris Miles]

I have created a test EJB and deployed it to Sun AppServer 8.2 with the name "AccountBean" - It was confirmed as deployed.

I have set JBuilder 6 to use the JDK in the AppServer directory and created a test application which failed with the error following message:

java.lang.VerifyError: (class: cakeinaboxbeans/AccountBeanTestClient1, method: getClosedDate signature: ()Ljava/util/Date :wink:  Incompatible object argument for function call
 
Exception in thread "main"

Here are the EJB files.

package AccountEJB;
 
import java.util.Collection;
import java.rmi.RemoteException;
import javax.ejb.*;
 
public interface AccountHome extends EJBHome
{
    public Account create(int id, double credit , double discount, java.util.Date openedDate, java.util.Date closedDate) throws CreateException, RemoteException;
    public Collection findAll() throws FinderException, RemoteException;
        public Account findByPrimaryKey(int primaryKey) throws FinderException, RemoteException;
        }

package AccountEJB;
 
import javax.ejb.EJBObject;
import java.rmi.RemoteException;
 
public interface Account extends EJBObject
{
        public void setId(int id);
   public void setCredit(double credit);
public void setDiscount(double discount);
        public void setOpenedDate(java.util.Date openedDate);
        public void setClosedDate(java.util.Date closedDate);
 
        public int getId();
public double getCredit();
public double getDiscount();
public java.util.Date getOpenedDate();
public java.util.Date getClosedDate();
}

package AccountEJB;
 
import javax.ejb.*;
import java.rmi.RemoteException;
 
import java.sql.*;
import javax.sql.*;
import java.util.*;
import javax.naming.*;
 
public class AccountBean implements EntityBean
  {
  private int m_id;
  private double m_credit;
  private double m_discount;
  private java.util.Date m_openedDate;
  private java.util.Date m_closedDate;
 
  private Connection con;
  private EntityContext m_context;
 
  public AccountBean()
    {
    }
 
  ///////////////////////
  // container methods //
  ///////////////////////
 
  public int ejbCreate(int id, double credit , double discount, java.util.Date openedDate, java.util.Date closedDate) throws CreateException
    {
    try
      {
      insertRow(id, credit, discount, openedDate, closedDate);
      }
    catch (Exception ex)
      {
      throw new EJBException("ejbRemove: " + ex.getMessage());
      }
 
    this.m_id = id;
    this.m_credit = credit;
    this.m_discount = discount;
    this.m_openedDate = openedDate;
    this.m_openedDate = closedDate;
 
    return id;
    }
 
  public void ejbPostCreate (int id, float credit , float discount, java.util.Date openedDate, java.util.Date closedDate) throws CreateException
    {
    }
 
  public void ejbRemove()
    {
    try
      {
      deleteRow(m_id);
      }
    catch (Exception ex)
      {
      throw new EJBException("ejbRemove: " + ex.getMessage());
      }
    }
 
  public void setEntityContext(EntityContext context)
    {
    this.m_context = context;
    try
      {
      makeConnection();
      }
    catch (Exception ex)
      {
      throw new EJBException("Unable to connect to database. " + ex.getMessage());
      }
   }
 
  public void unsetEntityContext()
    {
    m_context = null;
    }
 
  public void ejbActivate()
    {
    this.m_id = ((Integer)m_context.getPrimaryKey()).intValue();
    }
 
  public void ejbPassivate()
    {
    this.m_id = 0;
    this.m_credit = 0;
    this.m_discount = 0;
    this.m_openedDate = null;
    this.m_openedDate = null;
    try
      {
      con.close();
      }
    catch (SQLException ex)
      {
      throw new EJBException("unsetEntityContext: " + ex.getMessage());
      }
    }
 
  public void ejbLoad()
    {
    // load instance variables from database
    try
      {
      loadRow();
      }
    catch (Exception ex)
      {
      throw new EJBException("ejbLoad: " + ex.getMessage());
      }
    }
 
  public void ejbStore()
    {
    // save instance variables to database
    try
      {
      storeRow();
      }
    catch (Exception ex)
      {
      throw new EJBException("ejbStore: " + ex.getMessage());
      }
    }
 
  public Collection ejbFindAll() throws FinderException
    {
    Collection result;
 
    try
      {
      result = selectAll();
      }
    catch (Exception ex)
      {
      throw new EJBException("ejbFindByPrimaryKey: " + ex.getMessage());
      }
 
    if(result.isEmpty()==false)
      {
      return result;
      }
    else
      {
      throw new ObjectNotFoundException("No rows found.");
      }
    }
 
   public int ejbFindByPrimaryKey(int primaryKey) throws FinderException
    {
    boolean result;
 
    try
      {
      result = selectByPrimaryKey(primaryKey);
      }
    catch (Exception ex)
      {
      throw new EJBException("ejbFindByPrimaryKey: " + ex.getMessage());
      }
 
    if(result==true)
      {
      return primaryKey;
      }
    else
      {
      throw new ObjectNotFoundException("Row for id " + primaryKey + " not found.");
      }
    }
 
  //////////////////////
  // business methods //
  //////////////////////
 

  // set methods
  public void setId(int id)
    {
    m_id = id;
    }
 
  public void setCredit(double credit)
    {
    m_credit = credit;
    }
 
  public void setDiscount(double discount)
    {
    m_discount = discount;
    }
 
  public void setOpenedDate(java.util.Date openedDate)
    {
    m_openedDate = openedDate;
    }
 
  public void setClosedDate(java.util.Date closedDate)
    {
    m_closedDate = closedDate;
    }
 

  //get methods
 
  public int getId()
    {
    return m_id;
    }
 
  public double getCredit()
    {
    return m_credit;
    }
 
  public double getDiscount()
    {
    return m_discount;
    }
 
  public java.util.Date getOpenedDate()
    {
    return m_openedDate;
    }
 
  public java.util.Date getClosedDate()
    {
    return m_closedDate;
    }
 
  ///////////////////////
  // Database Routines //
  ///////////////////////
 
  private void makeConnection() throws NamingException, SQLException
    {
    try
      {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      }
    catch(ClassNotFoundException e)
      {
      System.err.println("JdbcOdbc Bridge Driver not found!");
      }
    con = DriverManager.getConnection("jdbc :-o	 dbc:cakeinabox");
    }
 
  private boolean selectByPrimaryKey(int primaryKey) throws SQLException
    {
    String selectStatement = "select id from Account where id = ? ";
    PreparedStatement prepStmt = con.prepareStatement(selectStatement);
    prepStmt.setInt(1, primaryKey);
 
    ResultSet rs = prepStmt.executeQuery();
    boolean result = rs.next();
    prepStmt.close();
    return result;
    }
 
   private Collection selectAll() throws SQLException
    {
    String selectStatement = "select id from account";
    PreparedStatement prepStmt = con.prepareStatement(selectStatement);
 
    ResultSet rs = prepStmt.executeQuery();
    ArrayList a = new ArrayList();
 
    while (rs.next())
      {
      a.add(new Integer(rs.getInt(1)));
      }
 
    prepStmt.close();
    return a;
    }
 
  private void insertRow (int id, double credit, double discount, java.util.Date openedDate, java.util.Date closedDate) throws SQLException
    {
    String insertStatement = "insert into Account values ( ? , ? , ? , ? , ?)";
    PreparedStatement prepStmt =
    con.prepareStatement(insertStatement);
 
    prepStmt.setInt(1, id);
    prepStmt.setDouble(2, credit);
    prepStmt.setDouble(3, discount);
    prepStmt.setDate(4, new java.sql.Date(openedDate.getTime()));
    prepStmt.setDate(5, new java.sql.Date(closedDate.getTime()));
 
    prepStmt.executeUpdate();
    prepStmt.close();
    }
 
  private void deleteRow(int id) throws SQLException
    {
    String deleteStatement = "delete from Account where id = ? ";
    PreparedStatement prepStmt = con.prepareStatement(deleteStatement);
    prepStmt.setInt(1, id);
    prepStmt.executeUpdate();
    prepStmt.close();
    }
 
  private void loadRow() throws SQLException
    {
    String selectStatement = "select * from Account where id = ? ";
    PreparedStatement prepStmt = con.prepareStatement(selectStatement);
 
    prepStmt.setInt(1, this.m_id);
 
    ResultSet rs = prepStmt.executeQuery();
 
    if (rs.next())
      {
      this.m_id = rs.getInt(1);
      this.m_credit = rs.getDouble(2);
      this.m_discount = rs.getDouble(3);
      this.m_openedDate = new java.util.Date(rs.getDate(4).getTime());
      this.m_closedDate = new java.util.Date(rs.getDate(5).getTime());
      prepStmt.close();
      }
    else
      {
      prepStmt.close();
      throw new NoSuchEntityException("Row for id " + m_id + " not found in database.");
      }
    }
 
  private void storeRow() throws SQLException
    {
    String updateStatement =
      "update Account set " +
      "credit =  ? ," +
      "discount = ? ," +
      "openedDate = ? " +
      "closedDate = ? " +
      "where id = ?";
    PreparedStatement prepStmt = con.prepareStatement(updateStatement);
 
    prepStmt.setInt(1, m_id);
    prepStmt.setDouble(2, m_credit);
    prepStmt.setDouble(3, m_discount);
    prepStmt.setDate(4, new java.sql.Date(m_openedDate.getTime()));
    prepStmt.setDate(5, new java.sql.Date(m_closedDate.getTime()));
 
    int rowCount = prepStmt.executeUpdate();
    prepStmt.close();
 
    if (rowCount == 0)
      {
      throw new EJBException("Storing row for id " + m_id + " failed.");
      }
    }
  }

And finally tghe client code.

package ejbTester;
 
import java.util.*;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.rmi.PortableRemoteObject;
import AccountEJB.*;
 
public class TestClient
  {
  public TestClient()
    {
    }
  public static void main(String[] args)
    {
    try
      {
      Context initial = new InitialContext();
      Object objref = initial.lookup("AccountBean");
      AccountHome home = (AccountHome)PortableRemoteObject.narrow(objref, AccountHome.class);
      }
    catch(Exception ex)
      {
      System.out.println(ex.getMessage());
      ex.printStackTrace();
      }
 
    }
}

any help greatly apreciated...

TIA Chris

[Chris Miles]

just to expand... I have changed something (not sure what)

and I am now getting the following error.

23-Jun-2006 23:31:21 com.sun.corba.ee.spi.logging.LogWrapperBase doLog
 
INFO: "IOP00710299: (INTERNAL) Successfully created IIOP listener on the specified host/port: all interfaces/1112"
 
javax.naming.NameNotFoundException: AccountBean not found
 
at com.sun.enterprise.naming.TransientContext.doLookup(TransientContext.java:185)
 
at com.sun.enterprise.naming.TransientContext.lookup(TransientContext.java:157)
 
at com.sun.enterprise.naming.SerialContextProviderImpl.lookup(SerialContextProviderImpl.java:101)
 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)AccountBean not found
 

 
at java.lang.reflect.Method.invoke(Method.java:585)
 
at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:123)
 
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:648)
 
at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:192)
 
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1709)
 
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1569)
 
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:951)
 
at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
 
at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:721)
 
at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:469)
 
at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1258)
 
at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:409)

Important thing I see is "AccountBean not found"

[Chris Miles]

still no joy with this.... It all seems to deploy fine... why cant I use the bean in my client.. I have trawled the docs for hours with no joy