1. save(Obj) doesn't return the ID (ORACLE trigger) forum.hibernate.orgHi guys, I'm using Hibernate with Oracle10g. My class is mapped to a table. This table id is incremented by an oracle Trigger+sequence. As soon as i do a save(Obj), the object is correctly saved, a new id is created, but hibernate does not return it... Here is my bean : Code: @Entity @Table(name = "FAVORITE", schema = "scem", uniqueConstraints = ... |
2. Problem saving the object in oracle 10g through hibernate forum.hibernate.orgHello friends, I am using the Oracle 10g express edition as backend database. I am trying to run a basic program which takes a Pojo class and persist to Oracle database using Session.save(object). I am getting the below mentioned error. Please help. (note: I am using the username and password within the connection url as I am not using thin client). ... |
3. ORA-02291 Exception and save forum.hibernate.orgemmanuel wrote: You must give more info, What is your DB schema (constaints), the exact Hibernate SQL etc Ok. I understand. My DB schema after schema-export: Code: CREATE TABLE SCOTT.GLOBAL ( GLOBAL_ID NUMBER(19,0) NOT NULL, CONTACT_ID NUMBER(19,0), PRIMARY KEY(GLOBAL_ID) ) GO ALTER ... |
4. when session.save,ORA-00942: table or view does not exist forum.hibernate.orgHi,all hibernate+oracle9i when I query the table: Query query = session.createQuery("from Person p"); it works well,but if I do: Person p=new Person(); p.setName("john"); p.setSex("m"); session.save(p); ERROR TableGenerator:104 - could not read a hi value java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at ... |