sequence 2 « Map « JPA Q&A





1. Define sequence generator in base class of JPA entities?    stackoverflow.com

is it possible to inherit the sequence generator of a base class in an jpa2.0 entity? The aim of this is to have the id property of all entities in a ...

2. Hibernate using sequence generator and sequence in Oracle    stackoverflow.com

I have the following sequence: [as seen now in Toad]:

CREATE SEQUENCE LOG_ID_SEQ
  START WITH 787585
  MAXVALUE 1000000000000000000000000000
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER
/
I have the ...

3. EmbeddedId, sequence and ConstraintViolationException    stackoverflow.com

I've got entity, which has @EmbeddedId. In the id class there are a few fields, and one of them is Long id with Generation type sequence. Problem apperas when I'm trying ...

4. Grails sequence generation for Oracle 11g    stackoverflow.com

I realize this is more of a hibernate question than Grails. In a load balanced (2 nodes) environment I see that the ids of my objects are jumping around quite a ...

6. Middlegen -Hibernate - use sequences for primary key    coderanch.com

Hi All, Should be a simple question for all you middlegen-hibernate veterans out there.. I am using the middlegen-hibernate plug in to read an existing schema and generate the appropriate hbm.xml files. I can specifiy which tables I want the mapping files for ( by using the

element) but in cases where I want the primary key of the table ...

7. Hibernate: using oracle sequence    coderanch.com

Hi, I tried to save very simple value to oracle by using sequence as my id generator. I stepped thru the object value and confirmed that my id field is obtained correctly from the sequence but when hibernate save the object to database somehow the id field turns out to be some funny value and when reading it back i got ...

8. How to represent a sequence in oracle in HQL    coderanch.com

Hi, I have a table with composite key. In that one field in the composite key must be sequence generated. Is there any way of representing a sequence table in oracle in HQL?? I have a sequence in my oracle database called Concurrent. Now, i would like to know how can i get the value from the Concurrent sequence and map ...

9. Funny number --- oracle sequence + Hibernate    coderanch.com

Hi, Gurus I encountered this very funny problem when using Hibernate to insert a records to Oracel(v8.1.7) using sequence. The code scriptlet is: -------------------Main.java--------------------------------- NetworkService newns = new NetworkService(); newns.setExternalReferenceNo("testrefenece"); newns.setServiceNo("99999999"); newns.setServiceStartDate(new Timestamp(new Date().getTime())); newns.setServiceEndDate(null); newns.setServiceType(1); newns.setStatus(1); newns.setStatusStartDatetime(new Timestamp(new Date().getTime())); newns.setTransactionID(1111111); newns.setLastUpdatedDatetime(new Timestamp(new Date().getTime())); session.save(newns); ------------------------------------------------------- The primary key is serviceID and you can see that the primary key ServiceID is ...





10. Using Oracle Sequence in Hibernate    coderanch.com

I am trying to use the Oracle sequence to generate the primary key for my User object. This is my User.hbm.xml MD_USER_SEQ But this is the exception I am getting. net.sf.hibernate.MappingException: could not instantiate id generator at ...

11. hibernate primary key mapping - sequence    coderanch.com

in the following xml the sequence is defined (for Oracle DB): UNIQUE_ID_SEQUENCE but what if the alternative database is MySQL which doesn't have sequences. Then what the hibernate will do in this case? Should i write another MySQL mapping to exclude sequence param from mapping? regards, Eugene

12. calling sequences in hibernate    coderanch.com

Well you have configured the ID to use the sequence already using generator set to sequence, then giving it the name of the sequence. You can always write SQL to call a query like "select seq.currval from dual" and run it. or use nextval instead of currval. Why do you need it, should you just let Hibernate when it calls insert ...

13. Autoincrement / Sequence in OJB - something like generator "native" in Hibernate    coderanch.com

Hi, Does anybody know if it's possible to define a primary key as autoincrement OR sequence field and let OJB decide whether it uses one of the both ... depending on the underlying database!? I found that it's possible to use either a autoincrement or a sequence. In Hibernate you can define the generator as "native" ... so the same code ...

15. Hibernate sequence exposed as property    coderanch.com

In the application that I currently work on generators (of type sequence) are used to create the IDs for all of our objects, so I somewhat understand how this works. What I need for a feature I'm adding is a integer value that is incremented during a particular point of execution in the program. I was thinking that a sequence would ...

16. why my oracle sequence id increases by 2 when I use hibernate to insert    coderanch.com

I created table in oracle and a trigger that automatically insert the next sequence id into the table when we isnert a row. From SQL plus, the sequence id increases by 1 everytime when I isnert a row there. But when I used hibernate I found when I insert a object, the sequence id increments by 2. Why does it behave ...





17. hibernate: could not get next sequence value    coderanch.com

13:22:26,734 INFO [STDOUT] 13:22:26,734 WARN [JDBCExceptionReporter] SQL Error: 2289, SQLState: 42000 13:22:26,734 INFO [STDOUT] 13:22:26,734 ERROR [JDBCExceptionReporter] ORA-02289: sequence does not exist 13:22:26,734 INFO [STDOUT] 13:22:26,734 ERROR [CustomerDAO] save failed org.hibernate.exception.SQLGrammarException: could not get next sequence value at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:91) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)

18. Hibernate, id, oracle, sequence    coderanch.com

Hello there, My database is Oracle, and my id column value is an Oracle sequence, this sequence is executed by a trigger, so, before each row is inserted this trigger use this sequence to get the id value. So I am confused in which id strategy generation should I define in my entity class. 1 - native 2 - sequence (oracle ...

19. Getting sequence in hibernate    coderanch.com

You can access sequences for purposes other than ids by mapping the sequence as a named sql query. Something like: select SQUENCE_NAME.nextval as {seq.num} from dual However, if you are using sequences your solution is no longer generic (since it doesn't work on databases that don't support sequences). You will also run out of numbers ...

20. hibernate and oracle sequence id    coderanch.com

In my oracle database, I first created "MyTable" Table and then created "MyTable_SEQ" SEQUENCE (I put the syntax in one script starting with table creation followed by SEQ creation). Then I do insert into MyTable(ID, NAME) VALUES(MyTable_SEQ.NEXTVAL, 'John'); I saw the row in database by doing select in sqlplus. However, when I use hibernate to retrieve the data, I got nothing. ...

21. Hibernate-Oracle Sequence...    coderanch.com

I have the below JUnit test method. When I execute the command: ant test -Dtestcase=ApplicationDAO, How come only one record being created in the database table though I execute the command more than one time. Each time the applicationId is set to : 1. Does not it create a record for each execution? Please help. public void testSaveApplication() throws Exception{ //Configuration ...

22. Oracle sequences and JPA    coderanch.com

23. Hibernate: Mapping a sequence to a serial (autoincr) field (Postgresql)    coderanch.com

Heya Ranchers, I never really used Hibernate before, in fact I use it since yesterday. After I successfully found all the required libraries on internet, I made fictional classes and tables about a library. Basically this is my class diagram: My goal is to check how hibernate handles inheritance. However when I'm trying to insert an author into my database I ...

24. Hibernate: ORM Mapping "Could not get next sequence value" SQLCODE: -142    coderanch.com

Hi, New to hibernate development but I've done some searching and haven't found the answer so I'll throw it out to the gurus. I'm attempting to add a record to a table hosted in a DB2 database. The mapping I have is: SQ_CIVIC_ADDRESS when I ...

25. Hibernate id sequence generator error    coderanch.com

Hi All, We are using Postgres 8.X as DB, JBOSS 5 as app server. Most of our primary keys in tables are defined as serial type in DB and generated through Postgres sequence. id definition in code looks like this @Id @SequenceGenerator(name="wilshire_seq", sequenceName="wilshire_transactions_id_seq") @GeneratedValue(strategy =GenerationType.SEQUENCE,generator="wilshire_seq") @Column(name = COLUMN_ID, unique = true, updatable = false, nullable = false) private Integer id; I ...

26. hibernate_sequence does exists ERROR    coderanch.com

Hi All, My id definition in code looks like this @Id @GeneratedValue(strategy = GenerationType.SEQUENCE) @Column(name = COLUMN_ID, unique = true, updatable = false) private Integer id; I am using Postgres 8.X as DB, JBOSS 5 as app server. Most of my primary keys in tables are defined as serial type in DB and generated through Postgres sequence. I tried different GenerationType ...

27. Basic question regarding Hibernate, Oracle and Sequence Numbers    coderanch.com

I'm just starting to try using Hibernate. I'm following a basic tutorial to map a couple of fields to a database table. I have two columns in the table. When I attempt to update the table, I get this error: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist My table does not have a sequence, and I don't particularly want it to. Is ...

28. Problems using a database sequence in JPA    coderanch.com

Hi, I have a recurring problem while trying to use an existing sequence from our database. I annotated the field in the entity bean in the following way: First try: @Id @GeneratedValue( strategy=GenerationType.SEQUENCE, generator="seq_wiedervorlage" ) @Basic( optional = false ) @Column( name = "ID" ) private Integer id; Second try ( read in the upcoming Pro JPA 2.0 book ) @Id ...

29. Hibernate tables.reveng.xml oracle sequence    coderanch.com

I'm trying to add a primary key section to my tables.reveng.xml file so I generate Hibernate classes that automatically use an Oracle sequence for the primary column ID. I got it working by hacking the following into my QUESTION_TYPE class: @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_QUESTION_TYPE_ID") @javax.persistence.SequenceGenerator( name = "SEQ_QUESTION_TYPE_ID", sequenceName = "SEQ_QUESTION_TYPE_ID", allocationSize = 1 ) Obviously this isn't ...

30. JPA impl. w/Hibernate & Oracle PK Sequences/Triggers    coderanch.com

I would like to call upon the Java community for a rather specific problem I've been unable to resolve for a while now using the following setup: - Weblogic 10 - JRE 1.6.05 (well actually JRockit) - JEE 5.0 - Struts 1.2.x - JPA with Hibernate 3.2.5.ga as provider - Oracle 10g My problem is persisting a new entity (ie. no ...

33. "hibernate_sequence" does not exist    coderanch.com

@Entity @Table(name = "users") public class User { private Long id; private Set roles = new HashSet(); @Id @GeneratedValue() public Integer getId() { return id; } // more getters & setters @CollectionOfElements(targetElement = java.lang.String.class) @JoinTable(name = "user_roles", joinColumns = @JoinColumn(name = "user_id")) @Column(name = "role") public Set getRoles() { return roles; } ...

34. Hibernate ID Sequence Generator    coderanch.com

I have the ID Sequence in my hibernate mapping files as such. It works great. However, it uses the same id for all tables. So instead of 1,2,3,4,5 for a table, I could end up with 1,4,5 with 2 and 3 being assigned to objects in other tables. Now that's not a big issue(and my DBA ...

35. Hibernate newbie - Data sequence    coderanch.com

Hi, I have problem running this hibernate project for Data sequence. I am providing the details below I am using Eclipse. I have created a table in Apache Derby as follows connect 'jdbc:derby://localhost:1527/BookShopDB;create=true; user=book;password=book'; CREATE TABLE BOOK (ISBN VARCHAR(50) NOT NULL, BOOK_NAME VARCHAR(100) NOT NULL, PUBLISHER_CODE VARCHAR(4), PUBLISH_DATE DATE, PRICE integer, PRIMARY KEY (ISBN), FOREIGN KEY (PUBLISHER_CODE) REFERENCES PUBLISHER (CODE) ); ...

37. hibernate oracle sequence produces large gap    coderanch.com

Hi All, I am using hibernate 3 , oracle 10g. I have a table: subject. The definition is here CREATE TABLE SUBJECT ( SUBJECT_ID NUMBER (10), FNAME VARCHAR2(30) not null, LNAME VARCHAR2(30) not null, EMAILADR VARCHAR2 (40), BIRTHDT DATE not null, constraint pk_sub primary key(subject_id) USING INDEX TABLESPACE data_index ) ; when insert a new subject, sub_seq is used to create ...

38. using database SEQUENCE with derby 10.6.2.1 and JPA and glassfish v3.0.1    java.net

FINE: INSERT INTO EMPLOYEE (NAME, SALARY) VALUES (?, ?) bind => [driscoll, 12345] FINE: VALUES(1) WARNING: Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.1.v20100213-r6600): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: Column 'ID' cannot accept a NULL value. Error Code: -1 Call: INSERT INTO EMPLOYEE (NAME, SALARY) VALUES (?, ?) bind => [driscoll, 12345] Query: InsertObjectQuery(Employee id: 0 name: driscoll salary: 12345) ...

39. Help with JPA sequence with oracle 9i    java.net

If transactions are being rolled back, then corrupted objects, including "new" objects with IDs set can remain behind. But those ID's may not have been committed to the DB, so it's possible to have an ID that's not in the DB. If you try and save that object again (with the now bogus ID), it's possible some other correct transaction has ...

40. JPA sequences making up weird numbers when migrating to GlassFish 2.1    java.net

I have an application that was developed and tested on GlassFish V2 UR2, PostgreSQL 8.3 and OpenSolaris 2008 11. I installed GlassFish 2.1 on the same computer then deployed the same application into it. The weirdest thing is happening. My application inserts records into the database then when it tries to commit there is an error:

42. Use GenerationType.SEQUENCE from JPA for BigInteger    forum.hibernate.org

[sorry for my english] I use JPA/Hibernate (standart version in JBoss 5.1.0) on old database (Oracle 10g). In this database used ID type NUMBER(38) (and exists ID more 10^20). Id Entity I need use BigInteger. 1. Why used org.hibernate.id.SequenceHiLoGenerator for @GeneratedValue(strategy = GenerationType.SEQUENCE) ? SequenceGenerator work correct. 2. Why SequenceHiLoGenerator can not work with BigInteger? 3. is this going to be ...

43. Get values from a sequence manually    forum.hibernate.org

Hi there, I've a table which is use to store protocols. Every entry represents a user action. An entry has an ID and a "changeID". This changeID groups several protocol entries to one change. This is done because one user action can result in multiple protocol entries. Now I wonder how I can tell Hibernate to use this sequence in the ...

44. id value should be sequence or asssigned    forum.hibernate.org

45. could not get next sequence value    forum.hibernate.org

Hi, I am using postgres 1.8.4 and hibernate 3.2.2. I use sequence generator to create the sequence object, I get the following error when I tried to insert data in the table via my application org.hibernate.exception.GenericJDBCException: could not get next sequence value here is my entity class @Entity @Table(name = "TEST") @XmlAccessorType(XmlAccessType.FIELD) @XmlType(name = "TEST") public class Product implements Serializable { ...

47. assigning id's to an object with generator class "sequence"    forum.hibernate.org

Hibernate will assign one and ignore the one u assigned. (But I am wondering, instead of asking the question, why would u not write sample codes and experiment with it yourself?) U might want to consider "sequence-identity", which is "a specialized sequence generation strategy that utilizes a database sequence for the actual value generation, but combines this with JDBC3 getGeneratedKeys to ...

48. "hibernate_sequence" does not exist    forum.hibernate.org

@Entity @Table(name = "users") public class User { private Long id; private Set roles = new HashSet(); @Id @GeneratedValue() public Integer getId() { return id; } // more getters & setters @CollectionOfElements(targetElement = java.lang.String.class) @JoinTable(name = "user_roles", joinColumns = @JoinColumn(name = "user_id")) ...

49. could not get next sequence value    forum.hibernate.org

Hi I am a newbie Hibernate user and I am trying to follow the Hibernate tutorial "The first Hibernate Application". However, instead of Maven I am using ANT and instead of HSQLDB I am using Oracle. My code is identical to the tutorial (except for oracle-specific configurations in hibernate.cfg.xml). Help on this would be greatly appreciated. Thanks in advance! I am ...

50. Hibernate sequence question    forum.hibernate.org

I'm currently using the following annotations for my primairy key: @Id @SequenceGenerator(name = "S912_PRO_SEQ", sequenceName = "S912_PRO_SEQ", allocationSize = 1) @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "S912_PRO_SEQ") @Column(name = "PRO_ID", unique = true, nullable = false, precision = 9, scale = 0) Now I would like that hibernate only calls the sequence (generator) when the object has no ID set. (<=0) Is ...

51. Multiple sequence?    forum.hibernate.org

Hello, I have a table of which two attributes are set from sequence. Now how can I set both values from Hibernate ? Can I use generator element for property tag. One of them is primary key so I will mention the sequence in generator tag under ID tag. But what about other property which also uses sequence?How should I mention ...

52. How to use multiple sequence in single table    forum.hibernate.org

Hello, I am new to hibernate. I have table with multiple ids, and we are using muliple sequence for these ids. Ex. table1( id numeric, id1 numeric, name varchar(50)) Following are sequences for id and id1. sequence table1_id_seq for id sequence table1_id1_seq for id1. we have only one primary key that is id. how can i create mapping xml for table1? ...

53. Sequence support for Apache Derby 10.6.1 in Hibernate 3.5.2    forum.hibernate.org

Hi, Derby 10.6.1 officially supports sequences. (See JIRA-Task: https://issues.apache.org/jira/browse/DERBY-712, Docs: https://issues.apache.org/jira/browse/DERBY-4568). I tried to use this feature with hibernate, but got this error: Code: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:487) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:430) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) ...

54. sequence generators are getting ignored    forum.hibernate.org

I'm getting the following error while saving a object. However similar configuration is working for other model objects in my projects. Any help would be greatly appreciated. Code: @Entity @Table(name = "ENROLLMENT_GROUP_MEMBERSHIPS", schema = "LEAD_ROUTING") public class EnrollmentGroupMembership implements Serializable, Comparable,Auditable { @javax.persistence.SequenceGenerator(name = "enrollmentGroupMemID", sequenceName = "S_ENROLLMENT_GROUP_MEMBERSHIPS") @Id ...

55. JPA JoinTable annotation with sequence generator    forum.hibernate.org

Hi, I'm using JPA with an Oracle10g backend. I'm implementing a many-tomany relation ship using a join table: tbl_job_type <-> tbl_join_job_type_tags <-> tbl_tags I'm not sure how to include the information regarding sequence generator in my annotation. I.e. when I add a tag to a job_type my persist call fails because the record to be persisted on tbl_join_job_type_tags was not initialized ...

56. Create Sequence    forum.hibernate.org

57. cascade doesn't work when using generator=sequence-identity?    forum.hibernate.org

Context: 1) We're newbies. 2) We're mapping two entities, Order & ContactInfo. Order has a reference to ContactInfo. Many different Orders can reference the same ContactInfo, i.e. it's a many-to-one relationship. We use Oracle 10g and sequences for our primary keys. As such, we used the following generator configuration: ORDER_INFO_SEQ However, we found that when we save ...

59. Hibernate oracle sequence    forum.hibernate.org

Code: select S_ADDRESS.nextval from dual Hibernate: /* insert Address */ insert into NEXT_TEST."ADDRESS" ("VERSION", "STREET", "HOUSE_NUMBER", "POST_CODE", "POST", "LOCALITY", "FLAT_NUMBER", "COUNTY", "COMMUNE", "CREATE_DATE", "KLU_UNIQ", "ID_ADDRESS_TYPE", "ID_CONTACT", "ID_COUNTRY", "ID_PROVINCE", "ID_ADDRESS") values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) select S_ADDRESS.nextval from dual Hibernate: /* insert Address */ insert into NEXT_TEST."ADDRESS" ("VERSION", "STREET", "HOUSE_NUMBER", ...

60. Hibernate/Oracle sequence generator    forum.hibernate.org

Hi, I'm trying to configure a seqhilo generator for a Hibernate application on Oracle. Code: S_TEST ...

61. Using sequence generator    forum.hibernate.org

Hi, I am trying to create a sequence as a primary key. The issue is that instead of incrementing by 1, it gets incremented by 50, though I have not specified that number anywhere. I tried in both derby and oracle. But the same result. So, I feel the problem could be with my code. Please help. Code: @Entity @Table(name = ...

62. Generate Custom sequence Number in Hibernate    forum.hibernate.org

63. how to override an identity attribute/sequence?    forum.hibernate.org

Hi all, I am trying to override an identity attribute a.id in two subclasses b and c. The problem is that I want to use the same database sequence (id_seq) for both b.id and c.id attributes. I came up with something below, which does not work. public class a { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) protected long id; ... } public class ...

64. duplicated values for hibernate sequence    forum.hibernate.org

Hy, I have many hbms and I am using the hibernate sequence to generate a primary key for all the tables in a database. The columns that are pk in the tables are not really specified as primary keys. Are just specified as primary keys in the hbm files. So I have seen that in a pair of tables there are ...

65. Sequences problems    forum.hibernate.org

Author Message glogu Post subject: Sequences problems Posted: Mon Nov 29, 2010 3:10 am Newbie Joined: Fri Nov 26, 2010 10:10 am Posts: 1 Hallo! I use: Jboss 5.1 Hibernate 3.3.1 I've got a problem with sequences in Hibernate. During multi-thread persist operation some objects gets the same ids and I've got constrain key violation. Here's stack trace. Code: ...

66. Hibernate sequence and allocation size    forum.hibernate.org

67. Entity does not get persisted but sequence gets incremented    forum.hibernate.org

Newbie Joined: Thu Jan 20, 2011 2:31 pm Posts: 2 Hello! I have a very strange problem (i should mention that i am new in the hibernate world so i consider a lot of things strange yet), the thing is that i have an entity which when persisted via an entityManager.merge method does not get saved, however if i manually get ...

68. Problem reading next value on a DB2 UDB sequence    forum.hibernate.org

Hello, I have got Problems reading the next value on a sequence from a DB2 UDB for iSeries Database with Hibernate as JPA Provider: Code: Query nextvalQuery = em .createNativeQuery("SELECT NEXTVAL FOR schemaname.sequencename" ...

69. How to Override the hibernate_sequence?    forum.hibernate.org

Hi all, I'm using Hibernate annotation to generate sequence number in Oracle 10g database, but i get this error message while trying to insert to the SubClass. The error message like "SQL Error: 2289, SQLState: 42000 ORA-02289: the sequence does not exist". the sequence named "EBMS_MAX_CAPABILITY_SEQ" was found in DB. The SuperClass like: Code: @MappedSuperclass public abstract class IdEntity implements Serializable{ ...

70. hibernate oracle sequence produces large gap    forum.hibernate.org

Hi All, I am using hibernate 3 , oracle 10g. I have a table: subject. The definition is here Code: CREATE TABLE SUBJECT ( SUBJECT_ID NUMBER (10), FNAME VARCHAR2(30) not null, LNAME VARCHAR2(30) not null, ...

71. Singe Sequence table    forum.hibernate.org

73. Negative sequence numbers are generated by hibernate    forum.hibernate.org

Hi I have an object for which i am using the sequence generator.. as follows Code: pooled ...

74. Problem with Sequences    forum.hibernate.org

Hello, I have a PostgreSQL Table that have a default clause in the ID column that use a sequence to get the default value. That's ok, but I don't know how to configure it with Hibernate. The problem is that Hibernate can't accept a entity to be persisted without Id, but the Id will be generated after the insert. From all ...

75. Cannot get sequences working (Oracle 10g)    forum.hibernate.org

@SequenceGenerator(name = "generator", sequenceName = "ADDR_SEQ") @Id @GeneratedValue(strategy = SEQUENCE, generator = "generator") @Column(name = "ADDR_ID", nullable = false, precision = 18, scale = 0) public Long getAddrId() { return this.addrId; }

76. Oracle sequences and allocationSize    forum.hibernate.org

Hi, We'd like the application to retrieve a block of IDs from an Oracle sequence and reuse those rather than hit the DB each time to get the sequence value. We have the ID annotated as follows: @Id @Column(name="MY_ID", nullable=false, insertable=true, updatable=false) @SequenceGenerator(name="planIdSequence", sequenceName="MY_ID_SEQ", allocationSize=50) @GeneratedValue(strategy=GenerationType.AUTO, generator="planIdSequence") private Long id; And the sequence in Oracle created as: create sequence MY_ID_SEQ start ...

77. ORA-01002 Fetch out of sequence error with UserType    forum.hibernate.org

I have a table that has a child table that has one field mapped with an UserType. Works fine if the child relationship has less than 10 rows. When the child has 10 or more rows, i get a SQL Exception "ORA-01002 Fetch out of sequence" in Hibernate's Loader class. After briefly looking at the Loader.java code, It seems that Loader.java ...

78. GenerationType.AUTO vs GenerationType.SEQUENCE    forum.hibernate.org

79. Problem in saving Parent sequence column.......    forum.hibernate.org

Hi all, I am trying to insert the data in Parent and Child tables. My HBMs for Parent and child are as follows: DMSMasterDO-> Parent DMSDetailDO-> Child SEQ_DMSMASTER 100 ...

81. Subclassing & oracle sequences    forum.hibernate.org

Newbie Joined: Thu Jul 21, 2011 11:41 am Posts: 3 I have a pre-existing data structure in Oracle where one table is the "parent" which will join to one of a handful of "child" tables depending on what type that parent is. The sample provided in http://docs.jboss.org/hibernate/core/3. ... tance.html is a pretty close match, where PAYMENT would be a parent table, ...

82. Sequence Mapping    forum.hibernate.org

83. setting my own id after specifying generator class="sequence    forum.hibernate.org

i have a table which is mapped with following id X_ID_SEQUENCE IN some scenarios while inserting a record i need to set my own primary key. we used to do this in the hibernate 3.0.5 using this following method in the Session class. session.save(xObj, xObj.getXId()); but after upgrading to hibernate 3.2.x this method ...

84. Sequence behaviour of PostgreSQL    forum.hibernate.org

Hi, when I start developing with Spring, Hibernate and so on, i used HSQLDB as DB. There was one sequence for every table. Now I moved to PostgreSQL because of requirements, and there is only one sequence used for the whole DB. Does anyone know how I can have the same behaviour in PostgreSQL like in HSQLDB ?

85. Hibernate with Oracle sequence doesn't use it    forum.hibernate.org

86. How do Hibernate managed sequences work ( native ) - anyone?    forum.hibernate.org

We have a PostgreSQL database (8.x & 9.x) using Hibernate 3.3.2 - older proprietary style with .hbm.xml files and are using hibernate managed sequences. If the app/db is shut down, where does hibernate store the meta-data? how does it know what the nextval is on startup? For a sequence created in the DB, the DB manages/stores the sequence, but if we ...

87. Using sequence-identity for id generation    forum.hibernate.org

88. Sequence not found when upgrade hibernate 3 to hibernate 4    forum.hibernate.org

Hi, I have an issue related to sequence not found when I upgrade hibernate from 3.5 to 4.0.0.RC6: at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:703) [hibernate-core-4.0.0.CR6.jar:4.0.0.CR6] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:707) [hibernate-core-4.0.0.CR6.jar:4.0.0.CR6] at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:847) [hibernate-entitymana ger-4.0.0.CR6.jar:4.0.0.CR6] ... 159 more Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) ...

89. Problem with sequence generator.    forum.hibernate.org

Hi, One of the database(Postgres DB) columns has been modified as ALTER TABLE mobile_send ALTER COLUMN column1 SET DEFAULT nextval('mysequence_seq'::text); In this table along with this i've 5 more columns. Now when I'm inserting a row into this table except the column 1 then the sequence is automatically generated for column 1. Ex : insert into table (col2,col3,col4,col5,col6) values ('a','b','c','d','e') (Value ...

90. Hibernate Eclipse Sequence does not exist    forum.hibernate.org

Newbie Joined: Wed Dec 07, 2011 11:21 am Posts: 3 Hello, I am running Hibernate in Eclipse and installed Oracle Express Edition on my computer. When I try to run a test class using JUnit I get the following stack error trace in the Eclipse console: 16 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.3.0.SP1 16 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found ...

91. Function sequence error in db2    forum.hibernate.org

I don't know why IBM's code does this, but here's what I found with tealwren's help: I supposed if you have a many-to-one relationship in your collection (and AutoCommit = true), you'll see a function sequence error. I set autocommit to false (based upon your post) and lo-and-behold the function-sequence error is gone. The error occurs when it does the following. ...

92. How to get the next value in Oracle Sequence    forum.hibernate.org

93. seqhilo: Discrepancy between HB and sequence ids    forum.hibernate.org

public synchronized Serializable generate(SessionImplementor session, Object obj) throws SQLException, HibernateException { if ( lo>maxLo ) { long hival = ( (Number) super.generate(session, obj) ).longValue(); lo = 1; ...

94. How to use generator sequence with User Types    forum.hibernate.org

I"ve run into the same problem. All my UserType does is take a numberic id and convert it into a numeric string. I could be mistaken, but in theory, there is nothing in this scenario that precludes using the native generator. Am I right? Why can't this be doable if the UserType returns an iteger sql type from sqlTypes()? Dmitry

95. How to use sequence for unique columns, not primary keys    forum.hibernate.org

Hi, I would like to know how to create sequences for non-primary keys. Here is a sample: table A{ id primary key id1 unique_key not null } I can use hibernate mapping to create sequence for id(primary key) but dont know how to do the same for id1(non-primary but unique key) Thanks for the help, Raghu

96. [Newbie] Oracle sequences and generators    forum.hibernate.org

epbernard wrote: Use the first one (sequence) it is way easier for your developpers: That's what I plan on doing. However I have one table with two columns, one of them the PK, the other one containing a copy of the PK (in other words, two identical columns, one of which is marked as PK). I don't see how to create ...

97. many-to-many with a sequence generated index column    forum.hibernate.org

Thats doesn't quite solve our problem, here is some more detailed information, from the user: Match.hbm.xml InvoiceMatch.hbm.xml SEQ_INVOICE_MATCH_ID 1 match.getInvoices() ...

98. how should i implement a sequence counter?    forum.hibernate.org

i have a GalleryImage and I need to be able to scroll next and previous, how should I implement this in hibernate? this is what I was thinking, having a column that holds "counter" so the first GalleryImage I insert for a given Gallery starts at 1, the next one added starts at 2, and so on and so fourth, but ...

99. What is definition of HiLo sequence table?    forum.hibernate.org

public class TableGenerator implements PersistentIdentifierGenerator, Configurable { ...... public String[] sqlCreateStrings(Dialect dialect) throws HibernateException { return new String[] { "create table " + tableName + " ( " + columnName + " " + dialect.getTypeName(Types.INTEGER) ...

100. ORA:01002 fetch out of sequence in Weblogic8.1    forum.hibernate.org

I'm trying to deploy our application from Tomcat 4.1.17 to Weblogic8.1sp1. If I do NOT use Weblogic Connection Pools all things went OK. When I follow the indicate from the FAQ(using a startup class) I got a problem: When I try to insert a record into the database(We use Oracle8.1.7), the exception is "ORA:01002 fetch out of sequence" I searched in ...