BMP

[Roopa Kotha]

Hi everyone,

I am getting below error when i call create method. ejbcreate method updates
the database and throws an exception. I have pasted the ejbcreate code after
the error message

Any help is greatly appreciated

Thanks
Roopa


javax.ejb.CreateException: A bean primary key field may not be null after
ejbCre
ate has been called
        at
weblogic.ejb.internal.StatefulEJBObject.postCreate(StatefulEJBObject.
java:228)
        at region.regionBMPEJBEOImpl.create(regionBMPEJBEOImpl.java:60)
        at region.regionBMPEJBHomeImpl.create(regionBMPEJBHomeImpl.java:32)
        at
region.regionBMPEJBHomeImpl_WLSkel.invoke(regionBMPEJBHomeImpl_WLSkel
.java:98)
        at
weblogic.rmi.extensions.BasicServerObjectAdapter.invoke(BasicServerOb
jectAdapter.java, Compiled Code)
        at
weblogic.rmi.extensions.BasicRequestHandler.handleRequest(BasicReques
tHandler.java:69)
        at
weblogic.rmi.extensions.BasicRequestDispatcher.dispatch(BasicRequestD
ispatcher.java:80)
        at
weblogic.rmi.internal.ServerRequest.sendOneWay(ServerRequest.java:73)

        at
weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:77
)
        at
region.regionBMPEJBHomeImpl_WLStub.create(regionBMPEJBHomeImpl_WLStub
.java:262)
        at IPREMS.ProjectEJB.calltoregionbean(ProjectEJB.java:141)
        at IPREMS.ProjectEJB.ejbCreate(ProjectEJB.java:105)
        at IPREMS.ProjectEJBEOImpl.create(ProjectEJBEOImpl.java:56)
        at IPREMS.ProjectEJBHomeImpl.create(ProjectEJBHomeImpl.java:32)
        at
IPREMS.ProjectEJBHomeImpl_WLSkel.invoke(ProjectEJBHomeImpl_WLSkel.jav
a:76)
        at
weblogic.rmi.extensions.BasicServerObjectAdapter.invoke(BasicServerOb
jectAdapter.java, Compiled Code)
        at
weblogic.rmi.extensions.BasicRequestHandler.handleRequest(BasicReques
tHandler.java:69)
        at
weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest
.java:15)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java, Compiled
Code)

Can some one tell me what causes this. ejbcreate method looks as below

public regionBMPPK ejbCreate(int regnum, String regdesc)
                throws CreateException {
                // to do: code goes here.
                System.out.println(regnum +"      "+regdesc);
                this.regionID=regnum;
                this.regiondesc=regdesc;
                Connection con=null;
                PreparedStatement p = null;
                try{
                    con = getConnection();
                    System.out.println("con object is "+con);
                    p=con.prepareStatement("insert into regions
(region_id,region_descriptor) values(?,?)");
                    System.out.println("Am i here");
                    p.setInt(1,this.regionID);
                    p.setString(2,this.regiondesc);
                    int i = p.executeUpdate();
                    System.out.println(i);
                }
                catch(Exception e)
                {

                    try{
                    e.printStackTrace();
                    if (con !=null)
                    con.close();
                    if (p !=null)
                    p.close();
                    }
                    catch(Exception es)
                    {
                        es.printStackTrace();
                        System.out.println("error in ejbcreate while closing con");
                    }

                }
                return (null);
        }

Any help is appreciated

Roopa

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".