ES Version: 2008.1.623.0 (LoaderMT)

Database: Oracle 10g (10.2.0.3)

MyGeneration: 1.2.0.7 

I cannot get EntitySpaces to insert a primary key value based on a sequence. I get: ORA-01400: cannot insert NULL into ("MySCHEMA"."MyTABLE"."MyID")

I have set the AUTOKEY metadata in MyGeneration but this doesn't help. I also tried to generate Oracle Procedures from MyGeneration to see if the insert procedure used the sequence, but it doesnt.

When I use MyGeneration and 2007.0.730.0 the procedures have the correct insert procedure (using a sequence).

Does ES 2008 look at the AUTOKEY attribute from MyGeneration?

Regards,

Andrew

I'm pretty sure I know what the problem is. We have our own user meta data file now, it's called esUserSettings.xml. You need to run the "UserData" template that comes with ES2008 and it will automatically convert your old one over, no need to even save it as it will do it for you automatically. Try it and let us know.

---

EntitySpaces | Twitter | BLOG | Please honor our Software License

Huzzah - you were right.

I ran the userdata template and the autoincrement now works correctly.

It might be worth adding a footnote to: http://www.entityspaces.net/blog/Permalink.aspx?title=OracleSequencesAndConcurrencyHandling&date=2006-03-20 saying that for ES 2008 the user should run the UserData template.

Thanks Mike.