Oracle sequences

[orchid]

I am wondering how to get oracle sequence to increment the primary key for my tables from my object.

[pegitha]

Can I see your mapping file?

[orchid]

Here

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="domain">
	

	<class name="TfoType" table="TFO_TYPE" lazy="false">

		<id name="id" type="java.lang.Integer" column="ID">
			<generator class="assigned" />
		</id>

		<property name="description" type="java.lang.String" column="DESCRIPTION" not-null="true" length="50" />
		<property name="creationDate" type="java.sql.Timestamp" column="CREATION_DATE" not-null="true" length="7" />
		<property name="createdBy" type="java.lang.String" column="CREATED_BY" not-null="true" length="8" />
		<property name="lastUpdated" type="java.sql.Timestamp" column="LAST_UPDATED" length="7" />
		<property name="lastUpdatedBy" type="java.lang.String" column="LAST_UPDATED_BY" length="8" />
		<property name="recordStatus" type="java.lang.String" column="RECORD_STATUS" not-null="true" length="1" />
	</class>
</hibernate-mapping>

[pegitha]

Depending on how your database is set up , that could work. But if it is not working, then try this:

Code:

<id name="id" type="java.lang.Integer" column="ID">
 <generator class="sequence" />
   <param name="sequence">TFO_TYPE_SEQ</param>
 </generator>
</id>

It tells oracle that it is a sequence and exactly which one to use.

[goldhouse]

Above assumes you are using hibernate for saving the entities,
Else you can simply say select sequencename.nextval from dual which will return the next value of the sequence and assign to some id and execute as a JDBC insert query

[orchid]

Yes, I am using Hibernate.