org.hibernate.exception.SQLGrammarException: could not fetch initial value for increment generator
Hi all,
i am having some issues in saving with tables with foreign key relationship. i got an error failed generate key
i got one table
ras_order
order_id number(2) primary key
order_name varchar2(100)
another table by name
ras_order_detail
order_item_id number(2) primary key,
order_item_name varchar2(100),
order_id references ras_order(order_id)
here is my basic
java bean files
Order.java
public class Order {
private int order_id =0;
private
String order_name = null;
private Set orderItems;
public void setOrderItemsL(Set orderitems) {
this.orderItems = orderitems;
}
public Set getOrderItemsL() {
if (this.orderItems == null) {
this.orderItems = new HashSet();
}
return this.orderItems;
}
public int getOrder_id() {
return order_id;
}
public void setOrder_id(int order_id) {
this.order_id = order_id;
}
public String getOrder_name() {
return order_name;
}
public void setOrder_name(String order_name) {
this.order_name = order_name;
}
}
OrderItem.java
public class OrderItem {
private int order_item_id = 0;
private String order_item_name = null;
private Order order = null;
public Order getOrder() {
return order;
}
public void setOrder(Order order) {
this.order = order;
}
public int getOrder_item_id() {
return order_item_id;
}
public void setOrder_item_id(int order_item_id) {
this.order_item_id = order_item_id;
}
public String getOrder_item_name() {
return order_item_name;
}
public void setOrder_item_name(String order_item_name) {
this.order_item_name = order_item_name;
}
}
here is my java code
String str = "index";
Session session = HibernateUtil.currentSession();
Transaction tx= session.beginTransaction();
Order order = new Order();
order.setOrder_name("TEST ORDER");
OrderItem oid = new OrderItem();
oid.setOrder_item_name("some name");
oid.setOrder(order);
Set oidset = new java.util.HashSet();
oidset.add(oid);
order.setOrderItemsL(oidset);
session.save(order);
tx.commit();
HibernateUtil.closeSession();
return mapping.findForward(str);
thanks
Rashid
[ December 06, 2006: Message edited by: Bear Bibeault ]