Hi,
I am a biginner with Hibernate.
Iam getting an Exception while working on Parent-Child relationship.
I have two tables in the database which are related with PrimaryKey and Foreign Key.
I have two .hbm files representing the table structure as follows
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.genco.lst.object.Shipment0" table="SHIPMENT0">
<!--
A 32 hex character is our surrogate key.
It's automatically generated by Hibernate
with the UUID pattern.
-->
<id name="id" type="long" unsaved-value="any" >
<column name="ID" sql-type="number" not-null="true"/>
<generator class="sequence">
<param name="sequence">SHIPMENT0_SEQ</param>
</generator>
</id>
<!-- A Shipment has to have a pro, but it shouldn' be too long. -->
<property name="proNumber" type="string">
<column name="PRO_NUM" sql-type="varchar2(30)" not-null="true"/>
</property>
<property name="pickupDate" type="date">
<column name="PICKUP_DATE" sql-type="date" not-null="true"/>
</property>
<property name="todaysDate" type="date">
<column name="TODAYS_DATE" sql-type="date" not-null="true"/>
</property>
<property name="crcNumber" type="string">
<column name="CRC_NUMBER" sql-type="varchar2(2)" not-null="true"/>
</property>
<property name="storeNumber" type="string">
<column name="STORE_NUMBER" sql-type="varchar2(5)" not-null="true"/>
</property>
<property name="scac" type="string">
<column name="SCAC" sql-type="varchar2(5)" not-null="true"/>
</property>
<property name="numPallets" type="integer">
<column name="NPALLETS" sql-type="number" not-null="true"/>
</property>
<property name="postedDate" type="date">
<column name="POSTED_DATE" sql-type="date" not-null="false"/>
</property>
<property name="batchStatus" type="integer">
<column name="BATCH_STATUS" sql-type="number" not-null="false"/>
</property>
<property name="createdOnDate" type="date">
<column name="CREATED_ON_DATE" sql-type="date" not-null="true"/>
</property>
<property name="createdOnTime" type="date">
<column name="CREATED_ON_TIME" sql-type="date" not-null="true"/>
</property>
<property name="createdBy" type="string">
<column name="CREATED_BY" sql-type="varchar2(50)" not-null="true"/>
</property>
<property name="updatedOnDate" type="date">
<column name="UPDATED_ON_DATE" sql-type="date" not-null="false"/>
</property>
<property name="updatedOnTime" type="date">
<column name="UPDATED_ON_TIME" sql-type="date" not-null="false"/>
</property>
<property name="updatedBy" type="string">
<column name="UPDATED_BY" sql-type="varchar2(50)" not-null="false"/>
</property>
<property name="version" type="integer">
<column name="VERSION" sql-type="number" not-null="false"/>
</property>
<property name="externalid" type="string">
<column name="EXTERNAL_ID" sql-type="varchar2(50)" not-null="false"/>
</property>
<property name="externalnpallets" type="integer">
<column name="EXTERNAL_NPALLETS" sql-type="number" not-null="false"/>
</property>
<property name="weight" type="integer">
<column name="WEIGHT" sql-type="number" not-null="false"/>
</property>
<property name="payrate" type="integer">
<column name="PAY_RATE" sql-type="number" not-null="false"/>
</property>
<property name="billrate" type="integer">
<column name="BILL_RATE" sql-type="number" not-null="false"/>
</property>
<set name="pallet0" cascade="all" inverse="true" >
<key column="SHIPMENT0_ID"/>
<one-to-many class="com.genco.lst.object.Pallet0"/>
</set>
</class>
</hibernate-mapping>
-------------------------------------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.genco.lst.object.Pallet0" table="PALLET0">
<!--
A 32 hex character is our surrogate key.
It's automatically generated by Hibernate
with the UUID pattern.
-->
<id name="id" type="long" unsaved-value="any" >
<column name="ID" sql-type="number" not-null="true"/>
<generator class="sequence">
<param name="sequence">PALLET0_SEQ</param>
</generator>
</id>
<!-- A Pallet has to have a pallet number, but it shouldn' be too long. -->
<property name="palletNumber" type="string">
<column name="PALLET_NO" sql-type="varchar2(38)" not-null="true"/>
</property>
<property name="storeNumber" type="string">
<column name="STORE_NUMBER" sql-type="varchar2(38)" not-null="true"/>
</property>
<property name="numCartons" type="integer">
<column name="NCARTONS" sql-type="number" not-null="false"/>
</property>
<property name="numBundles" type="integer">
<column name="NBUNDLES" sql-type="number" not-null="false"/>
</property>
<property name="numPieces" type="integer">
<column name="NPIECES" sql-type="number" not-null="false"/>
</property>
<property name="numBarrels" type="integer">
<column name="NBARRELS" sql-type="number" not-null="false"/>
</property>
<property name="createdOnDate" type="date">
<column name="CREATED_ON_DATE" sql-type="date" not-null="true"/>
</property>
<property name="createdOnTime" type="date">
<column name="CREATED_ON_TIME" sql-type="date" not-null="true"/>
</property>
<property name="createdBy" type="string">
<column name="CREATED_BY" sql-type="varchar2(50)" not-null="true"/>
</property>
<property name="updatedOnDate" type="date">
<column name="UPDATED_ON_DATE" sql-type="date" not-null="false"/>
</property>
<property name="updatedOnTime" type="date">
<column name="UPDATED_ON_TIME" sql-type="date" not-null="false"/>
</property>
<property name="updatedBy" type="string">
<column name="UPDATED_BY" sql-type="varchar2(50)" not-null="false"/>
</property>
<property name="version" type="integer">
<column name="VERSION" sql-type="number" not-null="false"/>
</property>
<property name="weight" type="integer">
<column name="WEIGHT" sql-type="number" not-null="false"/>
</property>
<property name="shipment0Id" type="long">
<column name="SHIPMENT0_ID" sql-type="number" not-null="true"/>
</property>
<many-to-one name="shipment0" class="com.genco.lst.object.Shipment0" column="ID" not-null="true"/>
</class>
</hibernate-mapping>
-------------------------------------------------------------------------------------
And I generated the two beans out of thease .hbm files respectively
package com.XXX.object;
import java.io.Serializable;
import java.util.Date;
import java.util.HashSet;
import java.util.Set;
import org.apache.commons.lang.builder.ToStringBuilder;
/** @author Hibernate CodeGenerator */
public class Shipment0 implements Serializable {
/** identifier field */
private Long id;
/** nullable persistent field */
private String proNumber;
/** nullable persistent field */
private Date pickupDate;
/** nullable persistent field */
private Date todaysDate;
/** nullable persistent field */
private String crcNumber;
/** nullable persistent field */
private String storeNumber;
/** nullable persistent field */
private String scac;
/** nullable persistent field */
private int numPallets;
/** nullable persistent field */
private Date postedDate;
/** nullable persistent field */
private int batchStatus;
/** nullable persistent field */
private Date createdOnDate;
/** nullable persistent field */
private Date createdOnTime;
/** nullable persistent field */
private String createdBy;
/** nullable persistent field */
private Date updatedOnDate;
/** nullable persistent field */
private Date updatedOnTime;
/** nullable persistent field */
private String updatedBy;
/** nullable persistent field */
private int version;
/** nullable persistent field */
private String externalid;
/** nullable persistent field */
private int externalnpallets;
/** nullable persistent field */
private int weight;
/** nullable persistent field */
private int payrate;
/** nullable persistent field */
private int billrate;
/** persistent field */
private Set pallet0 = new HashSet();
/** full constructor */
public Shipment0(String proNumber, Date pickupDate, Date todaysDate, String crcNumber, String storeNumber, String scac, int numPallets, Date postedDate, int batchStatus, Date createdOnDate, Date createdOnTime, String createdBy, Date updatedOnDate, Date updatedOnTime, String updatedBy, int version, String externalid, int externalnpallets, int weight, int payrate, int billrate, Set pallet0) {
this.proNumber = proNumber;
this.pickupDate = pickupDate;
this.todaysDate = todaysDate;
this.crcNumber = crcNumber;
this.storeNumber = storeNumber;
this.scac = scac;
this.numPallets = numPallets;
this.postedDate = postedDate;
this.batchStatus = batchStatus;
this.createdOnDate = createdOnDate;
this.createdOnTime = createdOnTime;
this.createdBy = createdBy;
this.updatedOnDate = updatedOnDate;
this.updatedOnTime = updatedOnTime;
this.updatedBy = updatedBy;
this.version = version;
this.externalid = externalid;
this.externalnpallets = externalnpallets;
this.weight = weight;
this.payrate = payrate;
this.billrate = billrate;
this.pallet0 = pallet0;
}
/** default constructor */
public Shipment0() {
}
/** minimal constructor */
public Shipment0(Set pallet0) {
this.pallet0 = pallet0;
}
public Long getId() {
return this.id;
}
public void setId(Long id) {
this.id = id;
}
public String getProNumber() {
return this.proNumber;
}
public void setProNumber(String proNumber) {
this.proNumber = proNumber;
}
public Date getPickupDate() {
return this.pickupDate;
}
public void setPickupDate(Date pickupDate) {
this.pickupDate = pickupDate;
}
public Date getTodaysDate() {
return this.todaysDate;
}
public void setTodaysDate(Date todaysDate) {
this.todaysDate = todaysDate;
}
public String getCrcNumber() {
return this.crcNumber;
}
public void setCrcNumber(String crcNumber) {
this.crcNumber = crcNumber;
}
public String getStoreNumber() {
return this.storeNumber;
}
public void setStoreNumber(String storeNumber) {
this.storeNumber = storeNumber;
}
public String getScac() {
return this.scac;
}
public void setScac(String scac) {
this.scac = scac;
}
public int getNumPallets() {
return this.numPallets;
}
public void setNumPallets(int numPallets) {
this.numPallets = numPallets;
}
public Date getPostedDate() {
return this.postedDate;
}
public void setPostedDate(Date postedDate) {
this.postedDate = postedDate;
}
public int getBatchStatus() {
return this.batchStatus;
}
public void setBatchStatus(int batchStatus) {
this.batchStatus = batchStatus;
}
public Date getCreatedOnDate() {
return this.createdOnDate;
}
public void setCreatedOnDate(Date createdOnDate) {
this.createdOnDate = createdOnDate;
}
public Date getCreatedOnTime() {
return this.createdOnTime;
}
public void setCreatedOnTime(Date createdOnTime) {
this.createdOnTime = createdOnTime;
}
public String getCreatedBy() {
return this.createdBy;
}
public void setCreatedBy(String createdBy) {
this.createdBy = createdBy;
}
public Date getUpdatedOnDate() {
return this.updatedOnDate;
}
public void setUpdatedOnDate(Date updatedOnDate) {
this.updatedOnDate = updatedOnDate;
}
public Date getUpdatedOnTime() {
return this.updatedOnTime;
}
public void setUpdatedOnTime(Date updatedOnTime) {
this.updatedOnTime = updatedOnTime;
}
public String getUpdatedBy() {
return this.updatedBy;
}
public void setUpdatedBy(String updatedBy) {
this.updatedBy = updatedBy;
}
public int getVersion() {
return this.version;
}
public void setVersion(int version) {
this.version = version;
}
public String getExternalid() {
return this.externalid;
}
public void setExternalid(String externalid) {
this.externalid = externalid;
}
public int getExternalnpallets() {
return this.externalnpallets;
}
public void setExternalnpallets(int externalnpallets) {
this.externalnpallets = externalnpallets;
}
public int getWeight() {
return this.weight;
}
public void setWeight(int weight) {
this.weight = weight;
}
public int getPayrate() {
return this.payrate;
}
public void setPayrate(int payrate) {
this.payrate = payrate;
}
public int getBillrate() {
return this.billrate;
}
public void setBillrate(int billrate) {
this.billrate = billrate;
}
public Set getPallet0() {
return this.pallet0;
}
public void setPallet0(Set pallet0) {
this.pallet0 = pallet0;
}
public void addPallet(Pallet0 p){
p.setShipment0(this);
pallet0.add(p);
}
public String toString() {
return new ToStringBuilder(this)
.append("id", getId())
.toString();
}
}
the second object is
package com.xxx.object;
import java.io.Serializable;
import java.util.Date;
//import org.apache.commons.lang.builder.EqualsBuilder;
//import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;
/** @author Hibernate CodeGenerator */
public class Pallet0 implements Serializable {
/** identifier field */
private Long id;
/** nullable persistent field */
private String palletNumber;
/** nullable persistent field */
private String storeNumber;
/** nullable persistent field */
private int numCartons;
/** nullable persistent field */
private int numBundles;
/** nullable persistent field */
private int numPieces;
/** nullable persistent field */
private int numBarrels;
/** nullable persistent field */
private Date createdOnDate;
/** nullable persistent field */
private Date createdOnTime;
/** nullable persistent field */
private String createdBy;
/** nullable persistent field */
private Date updatedOnDate;
/** nullable persistent field */
private Date updatedOnTime;
/** nullable persistent field */
private String updatedBy;
/** nullable persistent field */
private int version;
/** nullable persistent field */
private int weight;
/** nullable persistent field */
private long shipment0Id;
/** nullable persistent field */
private com.genco.lst.object.Shipment0 shipment0;
/** full constructor */
public Pallet0(String palletNumber, String storeNumber, int numCartons, int numBundles, int numPieces, int numBarrels, Date createdOnDate, Date createdOnTime, String createdBy, Date updatedOnDate, Date updatedOnTime, String updatedBy, int version, int weight, long shipment0Id, com.genco.lst.object.Shipment0 shipment0) {
this.palletNumber = palletNumber;
this.storeNumber = storeNumber;
this.numCartons = numCartons;
this.numBundles = numBundles;
this.numPieces = numPieces;
this.numBarrels = numBarrels;
this.createdOnDate = createdOnDate;
this.createdOnTime = createdOnTime;
this.createdBy = createdBy;
this.updatedOnDate = updatedOnDate;
this.updatedOnTime = updatedOnTime;
this.updatedBy = updatedBy;
this.version = version;
this.weight = weight;
this.shipment0Id = shipment0Id;
this.shipment0 = shipment0;
}
/** default constructor */
public Pallet0() {
}
public Long getId() {
return this.id;
}
public void setId(Long id) {
this.id = id;
}
public String getPalletNumber() {
return this.palletNumber;
}
public void setPalletNumber(String palletNumber) {
this.palletNumber = palletNumber;
}
public String getStoreNumber() {
return this.storeNumber;
}
public void setStoreNumber(String storeNumber) {
this.storeNumber = storeNumber;
}
public int getNumCartons() {
return this.numCartons;
}
public void setNumCartons(int numCartons) {
this.numCartons = numCartons;
}
public int getNumBundles() {
return this.numBundles;
}
public void setNumBundles(int numBundles) {
this.numBundles = numBundles;
}
public int getNumPieces() {
return this.numPieces;
}
public void setNumPieces(int numPieces) {
this.numPieces = numPieces;
}
public int getNumBarrels() {
return this.numBarrels;
}
public void setNumBarrels(int numBarrels) {
this.numBarrels = numBarrels;
}
public Date getCreatedOnDate() {
return this.createdOnDate;
}
public void setCreatedOnDate(Date createdOnDate) {
this.createdOnDate = createdOnDate;
}
public Date getCreatedOnTime() {
return this.createdOnTime;
}
public void setCreatedOnTime(Date createdOnTime) {
this.createdOnTime = createdOnTime;
}
public String getCreatedBy() {
return this.createdBy;
}
public void setCreatedBy(String createdBy) {
this.createdBy = createdBy;
}
public Date getUpdatedOnDate() {
return this.updatedOnDate;
}
public void setUpdatedOnDate(Date updatedOnDate) {
this.updatedOnDate = updatedOnDate;
}
public Date getUpdatedOnTime() {
return this.updatedOnTime;
}
public void setUpdatedOnTime(Date updatedOnTime) {
this.updatedOnTime = updatedOnTime;
}
public String getUpdatedBy() {
return this.updatedBy;
}
public void setUpdatedBy(String updatedBy) {
this.updatedBy = updatedBy;
}
public int getVersion() {
return this.version;
}
public void setVersion(int version) {
this.version = version;
}
public int getWeight() {
return this.weight;
}
public void setWeight(int weight) {
this.weight = weight;
}
public long getShipment0Id() {
return this.shipment0Id;
}
public void setShipment0Id(long shipment0Id) {
this.shipment0Id = shipment0Id;
}
public com.genco.lst.object.Shipment0 getShipment0() {
return this.shipment0;
}
public void setShipment0(com.genco.lst.object.Shipment0 shipment0) {
this.shipment0 = shipment0;
}
public String toString() {
return new ToStringBuilder(this)
.append("id", getId())
.toString();
}
}
The client code iam using to test this as follows:
protected void doPost(
HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
ControllerSFHome home = null;
ControllerSF controller = null;
PrintWriter out = response.getWriter();
try {
home = this.getControllerSFHome();
controller = home.create();
Shipment0 shp = new Shipment0();
shp.setProNumber("23232323");
shp.setPickupDate( new java.util.Date());
shp.setTodaysDate( new java.util.Date());
shp.setCrcNumber("60");
shp.setStoreNumber("1000");
shp.setScac("RDWY");
shp.setNumPallets(2);
Set palletList = new HashSet();
Pallet0 pallet = new Pallet0();
pallet.setPalletNumber("4444");
pallet.setStoreNumber("1000");
pallet.setShipment0(shp);
palletList.add(pallet);
shp.setPallet0(palletList);
Shipment0 ship = (Shipment0)controller.create(shp); // Session beans Create method see below
} catch (Exception ex) {
ex.printStackTrace();
out.println("Exception : " + ex.getMessage());
}
out.println("Done!");
}
I am using a Session Bean to call actual Hibernate API as follows
public Object create(Object o) throws HibernateException {
SessionFactory sessionFactory;
Session session;
Transaction transaction;
System.out.println("Just before getting SessionFactory");
sessionFactory = new Configuration().configure().buildSessionFactory();
session = sessionFactory.openSession();
System.out.println("Got the session");
Transaction tx = null;
try {
tx = session.beginTransaction();
System.out.println("About to create record.");
session.save(o);
session.flush();
tx.commit();
}catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
finally {
session.close();
}
return o;
}
When call the servlet I am getting the following Exception:
Got the session
About to create record.
Hibernate: select SHIPMENT0_SEQ.nextval from dual
Hibernate: select PALLET0_SEQ.nextval from dual
Hibernate: insert into SHIPMENT0 (PRO_NUM, PICKUP_DATE, TODAYS_DATE, CRC_NUMBER, STORE_NUMBER, SCAC, NPALLETS, POSTED_DATE, BATCH_STATUS, CREATED_ON_DATE, CREATED_ON_TIME, CREATED_BY, UPDATED_ON_DATE, UPDATED_ON_TIME, UPDATED_BY, VERSION, EXTERNAL_ID, EXTERNAL_NPALLETS, WEIGHT, PAY_RATE, BILL_RATE, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PALLET0 (PALLET_NO, STORE_NUMBER, NCARTONS, NBUNDLES, NPIECES, NBARRELS, CREATED_ON_DATE, CREATED_ON_TIME, CREATED_BY, UPDATED_ON_DATE, UPDATED_ON_TIME, UPDATED_BY, VERSION, WEIGHT, SHIPMENT0_ID, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2672 [HttpRequestHandler-26093085] WARN util.JDBCExceptionReporter - SQL Error: 1006, SQLState: 72000
2672 [HttpRequestHandler-26093085] ERROR util.JDBCExceptionReporter - ORA-01006: bind variable does not exist
2672 [HttpRequestHandler-26093085] WARN util.JDBCExceptionReporter - SQL Error: 1006, SQLState: 72000
2672 [HttpRequestHandler-26093085] ERROR util.JDBCExceptionReporter - ORA-01006: bind variable does not exist
2688 [HttpRequestHandler-26093085] ERROR util.JDBCExceptionReporter - Could not synchronize database state with session
java.sql.BatchUpdateException: ORA-01006: bind variable does not exist
at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:449)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3742)
at com.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at com.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at com.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:50)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:81)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2066)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2035)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:1979)
at com.genco.lst.ejb.ControllerSFBean.create(ControllerSFBean.java:50)
at ControllerSF_StatelessSessionBeanWrapper2.create(ControllerSF_StatelessSessionBeanWrapper2.java:76)
at com.genco.lst.servlet.ControllerServlet.doPost(ControllerServlet.java:77)
at com.genco.lst.servlet.ControllerServlet.doGet(ControllerServlet.java:43)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:293)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:602)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:308)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:779)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:264)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:107)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
java.sql.BatchUpdateException: ORA-01006: bind variable does not exist
at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:449)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3742)
at com.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at com.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at com.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:50)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:81)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2066)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2035)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:1979)
at com.genco.lst.ejb.ControllerSFBean.create(ControllerSFBean.java:50)
at ControllerSF_StatelessSessionBeanWrapper2.create(ControllerSF_StatelessSessionBeanWrapper2.java:76)
at com.genco.lst.servlet.ControllerServlet.doPost(ControllerServlet.java:77)
at com.genco.lst.servlet.ControllerServlet.doGet(ControllerServlet.java:43)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:293)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:602)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:308)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:779)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:264)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:107)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
Please help me on how to solve this exception
" Could not synchronize database state with session: ORA-01006: bind variable does not exist "
Any help would be appreciated.
Thanks
Mahesh
|