Skip to Main Content

Oracle Database Discussions

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.

Does 11g support no auto_increment / auto_assigned columns?

800151Oct 2 2011 — edited Dec 13 2011
Hi,

I am using openJPA and run into following issue when using Oracle 11g:


"Oracle" does not support auto-assigne d column values. The column may not behave as desired.

In other words: The database does not support auto_increment values for rows?
Is there a workaround for that?

The openJPA community did create some warning for Oracle in their framework:
https://issues.apache.org/jira/browse/OPENJPA-1090

However ... the warning does of course not fix anything.

Is that a workaround for that? Is there a special way of creating Oracle Database so that auto_assigned / auto_incrementor is allowed in fields? I mean currently Oracle does not seem to be compatible to openJPA so we cannot use this database or recommend it using it to our users.

You can see our sample db configuration that we have been publishing for Oracle here:
http://code.google.com/p/openmeetings/wiki/Configuration_Oracle_11g

I would be very happy if we could officially release OpenMeetings with support for Oracle.

Thank you very much,
Sebastian Wagner

Lead Developer OpenMeetings - Open-Source Web-Conferencing
http://www.openmeetings.de

Comments

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

Post Details

Locked on Jan 10 2012
Added on Oct 2 2011
7 comments
985 views