Hi friends, I'm trying to deploy CMP on iplanet app server(6.0 test drive). IT's the eg given in j2ee-guide of iPlanet server.It's product eg.I'm getting the following error.First time I'm able create the object.But whenever I want create another object it's giving me following error.If we have deleted inserted record also it's not able to insert through create method of the bean.If I restart the server then I'm able to insert/create once only. Please help me regarding the same. java.sql.SQLException: GXORCL2PreparedStatement: AEExecute(): ORA-00001: unique constraint (IPLANET.SYS_C002366) violated at com.netscape.server.jdbc.PreparedStatement.verifyError(Unknown Source ) at com.netscape.server.jdbc.PreparedStatement.afterVerify(Unknown Source ) at com.netscape.server.jdbc.PreparedStatement.executeUpdate(Unknown Sour ce) at com.netscape.server.ejb.SQLPersistenceManager.create(Unknown Source) at com.netscape.server.ejb.EntityDelegateManagerImpl.doPersistentCreate( Unknown Source) at com.netscape.server.ejb.EntityDelegateManagerImpl.create(Unknown Sour ce) at com.kivasoft.eb.EBHomeBase.create(Unknown Source) at com.wl.scms.taxtype.ejb_home_com_wl_scms_taxtype_TaxMasterBean.create (ejb_home_com_wl_scms_taxtype_TaxMasterBean.java:77) at com.wl.scms.taxtype.ejb_kcp_skel_TaxMasterHome.create__com_wl_scms_ta xtype_TaxMaster__indir_wstring__double__java_s__241066677(ejb_kcp_skel_TaxMaster Home.java:209) at com.kivasoft.ebfp.FPRequest.invokenative(Native Method) at com.kivasoft.ebfp.FPRequest.invoke(Unknown Source) at com.wl.scms.taxtype.ejb_kcp_stub_TaxMasterHome.create(ejb_kcp_stub_Ta xMasterHome.java:274) at com.wl.scms.taxtype.ejb_stub_TaxMasterHome.create(ejb_stub_TaxMasterH ome.java:77) at com.wl.scms.taxtype.TaxMasterClientServlet.add(TaxMasterClientServlet .java:250) at com.wl.scms.taxtype.TaxMasterClientServlet.doPost(TaxMasterClientServ let.java:130) at javax.servlet.http.HttpServlet.service(HttpServlet.java:772) at javax.servlet.http.HttpServlet.service(HttpServlet.java:865) at com.netscape.server.servlet.servletrunner.ServletInfo.service(Unknown Source) at com.netscape.server.servlet.servletrunner.ServletRunner.execute(Unkno wn Source) at com.kivasoft.applogic.AppLogic.execute(Unknown Source) at com.kivasoft.applogic.AppLogic.execute(Unknown Source) at com.kivasoft.thread.ThreadBasic.run(Native Method) at java.lang.Thread.run(Thread.java:479) //============================================================== failed in add:: javax.ejb.DuplicateKeyException After calling add..false Could not insert into database in doPost() session created In doPost() Home found in dopost Page is http://web-6/add_tax_master.jsp Button pressed is ADD taxType is CST7 tempPercent is 7 Double percent is 7.0 System Date is 12 System month is 11 System Year is 1997 1997-11-12 Entry date is 1997-11-12 EntryDate sql is 1997-11-12 ModifiedDate sql is 1997-11-12 before calling add..in doPost() trying to create Home found in add [12/Nov/1997 11:37:14:2] error: DATA-116: Prepared statement is closed - INSERT INTO TAX_MASTER1 VALUES(?,?,?,?) java.sql.SQLException: Prepared statement is closed - INSERT INTO TAX_MASTER1 VA LUES(?,?,?,?) at com.netscape.server.jdbc.PreparedStatement.verifyError(Unknown Source ) at com.netscape.server.jdbc.PreparedStatement.afterVerify(Unknown Source ) at com.netscape.server.jdbc.PreparedStatement.setDouble(Unknown Source) at com.netscape.server.ejb.SQLPersistenceManager.setParameter(Unknown So urce) at com.netscape.server.ejb.SQLPersistenceManager.create(Unknown Source) at com.netscape.server.ejb.EntityDelegateManagerImpl.doPersistentCreate( Unknown Source) at com.netscape.server.ejb.EntityDelegateManagerImpl.create(Unknown Sour ce) at com.kivasoft.eb.EBHomeBase.create(Unknown Source) at com.wl.scms.taxtype.ejb_home_com_wl_scms_taxtype_TaxMasterBean.create (ejb_home_com_wl_scms_taxtype_TaxMasterBean.java:77) at com.wl.scms.taxtype.ejb_kcp_skel_TaxMasterHome.create__com_wl_scms_ta xtype_TaxMaster__indir_wstring__double__java_s__241066677(ejb_kcp_skel_TaxMaster Home.java:209) at com.kivasoft.ebfp.FPRequest.invokenative(Native Method) at com.kivasoft.ebfp.FPRequest.invoke(Unknown Source) at com.wl.scms.taxtype.ejb_kcp_stub_TaxMasterHome.create(ejb_kcp_stub_Ta xMasterHome.java:274) at com.wl.scms.taxtype.ejb_stub_TaxMasterHome.create(ejb_stub_TaxMasterH ome.java:77) at com.wl.scms.taxtype.TaxMasterClientServlet.add(TaxMasterClientServlet .java:250) at com.wl.scms.taxtype.TaxMasterClientServlet.doPost(TaxMasterClientServ let.java:130) at javax.servlet.http.HttpServlet.service(HttpServlet.java:772) at javax.servlet.http.HttpServlet.service(HttpServlet.java:865) at com.netscape.server.servlet.servletrunner.ServletInfo.service(Unknown Source) at com.netscape.server.servlet.servletrunner.ServletRunner.execute(Unkno
0
