Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SequenceGenerator not working, TableGenerator is.

572079Apr 21 2008 — edited Apr 28 2008
I'm able to generate keys using a sequence-table. The annotations of the PK field are:

@Id
@GeneratedValue(generator="relation.relationnr", strategy=GenerationType.TABLE)
@TableGenerator( name="relation.relationnr", pkColumnValue="relationnr", table="sequence", pkColumnName="seq_name", valueColumnName="seq_count", initialValue=1, allocationSize=1)
@Column(name="relationnr")


But I'm not able to get the same behavior using sequences:

@Id
@SequenceGenerator( name="relation.relationnr", sequenceName="relationnr", allocationSize=1)
@GeneratedValue(generator="relation.relationnr", strategy=GenerationType.SEQUENCE)
@Column(name="relationnr")


With the second approach Toplink simply does not assing a value to the related field:

SQL errorcode: -391
SQL state: 23000
local message: Cannot insert a null into column (relation.relationnr).
java.sql.SQLException: Cannot insert a null into column (relation.relationnr).


The sequence exists:

select relationnr.nextval from _number where n = 1;

nextval

100246


Using another name for the sequence, or have the Toplink generate one, does not help.

Why isn't the sequence working?

Comments

245446
.NET CF is not yet supported by Oracle 9i Lite, it's scheduled for partial support in the patch 5.0.2.8, which is due out September 15th, and full support in the new version 9.0.2 (they are changing the version from 5.X.X too 9.X.X so that Lite and the rest of Oracle is at the same version number) which is scheduled for December 1st...of course as we all know those dates can change.

Shaun
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 26 2008
Added on Apr 21 2008
#application-servers, #toplink-jpa
20 comments
5,258 views