Problem with HSQLDB & SequenceGenerator

Posted by Srirangan on Stack Overflow See other posts from Stack Overflow or by Srirangan
Published on 2010-04-21T08:46:39Z Indexed on 2010/04/24 4:43 UTC
Read the original article Hit count: 315

Filed under:

hsqldb

|

sequence-generators

|

hibernate

|

java

Hi,

I have an entity which has an ID field:

@Id
@Column(name = "`U##ID_VOIE`")
@GeneratedValue(generator = "VOIE_SEQ")
private String id;

The class has the sequence generator defined as well:

@SequenceGenerator(name = "VOIE_SEQ", sequenceName = "VOIE_SEQ")

and the Oracle schema has the requisite sequence present. Everything works okay.

We also have tests, which uses an in-memory HSQLDB. Before running the tests, all the tables are created based on the Hibernate entity classes.

However the table for this particular class is not being created. And error pops up, because ID is a String and the SequenceGenerator in HSQLDB returns an INT / LONG / Numeric value.

The application is using a legacy Oracle database and ID_VOIE column must remain a String / Varchar.

Any solutions?

© Stack Overflow or respective owner

Related posts about hsqldb

HSQLDB connection error

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a java program for connect the HSQLDB , the first one works well, public final static String DRIVER = "org.hsqldb.jdbcDriver"; public final static String URL = "jdbc:hsqldb:file:F:/hsqlTest/data/db"; public final static String DBNAME = "SA"; but these are not public final static String… >>> More
HSQLDB Constraint Violation & SQL Query Log for an HSQLDB in-memory setup

as seen on Stack Overflow - Search for 'Stack Overflow'
We have a setup where we are using an embedded HSQLDB for backing Hibernate/JPA unit tests in java, and we are using the in-memory database mode since we simply want the database thrown away after the test run. My problem is that one of the tests is failing due to a constraint violation and HSQLDB… >>> More
Getting java.lang.OutOfMemoryError: Java heap space

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting an Exception in thread "HSQLDB Connection @3c50507" java.lang.OutOfMemoryError: Java heap space, when running a JSP. what is the thing that is out of memory? eclipse, HSQLDB or Tomcat?? i am using all that in a Mac OS X 10.7.4 When i start HSQLDB, then i get by console this exception: [Server@122ce908]:… >>> More
Atomic INSERT/SELECT in HSQLDB

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have the following hsqldb table, in which I map UUIDs to auto incremented IDs: SHORT_ID (BIG INT, PK, auto incremented) | UUID (VARCHAR, unique) Create command: CREATE TABLE table (SHORT_ID BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, UUID VARCHAR(36) UNIQUE) In order to add… >>> More
HSQLDB how to manually insert records

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, My question is how can I manually add records to hsqldb database. I mean using command line or some client. I know I can use hsqldb manager but I cannot execute any query with it. It says that there is no table of specified name. What might be the problem? >>> More

Related posts about sequence-generators

Configuring JPA Primary key sequence generators

as seen on Oracle Blogs - Search for 'Oracle Blogs'
This article describes the JPA feature of generating and assigning the unique sequence numbers to JPA entity .This article provides information on jpa sequence generator annotations and its usage. UseCase Description Adding a new Employee to the organization using Employee form… >>> More
sequence generators are getting ignored

as seen on Stack Overflow - Search for 'Stack Overflow'
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. @Entity @Table(name = "ENROLLMENT_GROUP_MEMBERSHIPS", schema = "LEAD_ROUTING") public class EnrollmentGroupMembership implements… >>> More
Sequence Generators in T-SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
We have an Oracle application that uses a standard pattern to populate surrogate keys. We have a series of extrinsic rows (that have specific values for the surrogate keys) and other rows that have intrinsic values. We use the following Oracle trigger snippet to determine what to do with the Surrogate… >>> More
Problem with HSQLDB & SequenceGenerator

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have an entity which has an ID field: @Id @Column(name = "`U##ID_VOIE`") @GeneratedValue(generator = "VOIE_SEQ") private String id; The class has the sequence generator defined as well: @SequenceGenerator(name = "VOIE_SEQ", sequenceName = "VOIE_SEQ") and the Oracle schema has the requisite… >>> More