search

Confluex / Zuul

Keymaster and Gatekeeper - Application Configuration Management
http://confluex.com
Apache License 2.0
42 stars 32 forks source link

Oracle support to JPA entities #67

Closed JStrittmatter closed 8 years ago

JStrittmatter commented 10 years ago

changes to use sequence table for generated sequence columns to make JPA entities more database agnostic

psmith commented 8 years ago

Just info on why this wasn't accepted... but will be used to a certain extent to add oracle support in the very near future.

I'm pretty sure, this would break db's like mysql, ms sql, etc, as they wouldn't know how to deal with sequences. You really have to support auto number and sequences. In order to do this, we'd need to change the liquibase scripts to do something else (use sequences) if the db is oracle (I think 12g supports auto number, with a certain version of liquibase, but that won't do older oracle db's any good). I believe the liquibase portion is fairly quick.

Next, change jpa to something that will work for both. Which, I think I've done it in the past, it's just been a few years and I have NOT slept sense then. I will have to research that.

I think the most painful part will be setting up various version of oracle, and some other db's, for regression testing.