Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

iplanet app server CMP deployment

 
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

Thanx,
MAhesh
 
There’s no place like 127.0.0.1. But I'll always remember this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic