-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Exception While working with parent-child relationship
PostPosted: Tue Jan 13, 2004 6:19 pm 
Newbie

Joined: Tue Jan 13, 2004 6:01 pm
Posts: 2
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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 13, 2004 7:10 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
You mapped the many-to-one fk using an already used column in Pallet0. This is not allowed.

_________________
Emmanuel


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jan 14, 2004 12:16 pm 
Newbie

Joined: Tue Jan 13, 2004 6:01 pm
Posts: 2
emmanuel wrote:
You mapped the many-to-one fk using an already used column in Pallet0. This is not allowed.


Hi emmanuel,

It is working now. Thank you very much.

Thanks
Mahesh


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.