hi,
Could you help me for Data insertion into Oracle daabase.
I have Table item in scott/tiger database.
With below coe i could retrive data.
But when i save NEW data ,I could not save to my oracle database table.
Experts help !!
-------------------------------
Oracle Database table
---------------------
DROP TABLE ITEM CASCADE CONSTRAINTS ;
CREATE TABLE ITEM (
ID NUMBER (11) NOT NULL,
NAME VARCHAR2 (32) NOT NULL,
DESCRIPTION VARCHAR2 (32) NOT NULL,
CONSTRAINT PKID
PRIMARY KEY ( ID )
USING INDEX
TABLESPACE USERS PCTFREE 10
STORAGE ( INITIAL 128K NEXT 128K PCTINCREASE 0 ))
TABLESPACE USERS NOLOGGING
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 131072
NEXT 131072
MINEXTENTS 1
MAXEXTENTS 4096
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
------------
Item.hbm.xml
----------------
<hibernate-mapping>
<class name="com.edhand.example1.Item" table="item" >
<id name="id" column="id" type="java.lang.Long" unsaved-value="0">
<generator class="native"/>
</id>
<property name="name" column="name" type="java.lang.String" />
<property name="description" column="description"
type="java.lang.String" />
</class>
</hibernate-mapping>
--------------------------------
ERROR
java.lang.RuntimeException: net.sf.hibernate.JDBCException: Could not save
object at com.edhand.example1.ItemService.addItem(Unknown Source) at
com.edhand.example1.AddItemAction.execute(Unknown Source) at
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
