Skip to Main Content
Forums

APEX

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!

Maintaining data & data schema between Development vs Production?

DannyS-OracleJun 15 2017 — edited Jun 16 2017

Hi everyone, I am a beginner Apex developer and need some advice on how to sync between my development and production instances. I tried searching on this forum, and this has been asked before here , but there was no feedback.

So my situation is, we are planning to have two different instance of our application:

  1. Development, where we do all experiment and add new features; and
  2. Production, where we put all stable features, production data, and make it accessible for our users.

We are thinking to put these two instances on different workspaces, so we can safely export and import all pages easily and separate development vs production data.

The case where I am concerned is, how to keep the data schema between the development and production workspaces in sync? Let's say I implemented some features in dev environment, where I need to make changes to certain table (e.g. adding/removing columns or triggers in Table A). How to reflect this changes automatically in the production environment? I believe I can't just export the data, replace the data schema with the one from dev, and then re-import the data because some table columns might have changed. Do I have to implement all those changes manually in the production workspace?

Please let me know if you have been in similar situation, or if you know better solution for this. Any feedback will be appreciated! I am using Apex v5.1, Oracle DB v12.

Comments

karianna

This Q should be moved to the Java Security community, but it looks like you have a classpath issue where that class/method is not being loaded.

Pankaj Shakya

Thanks @"karianna", but while i type complete path in url, all jars are being accessed.

e.g http://10.25.85.74:8080/PIMS/applet/dsc-1.0.jar

Is there any problem with my JNLP file?

karianna

I'm not familiar with JNLP - perhaps it needs download="eager" on the bouncy castle lib and you should also check that the bouncy castle JARs actually contain the method you're invoking.

Pankaj Shakya

I have already tried it with eager...but no change and  checked all jars, they are containing all methods and classes which are being invoked. I have been working on this problem since last 3 days, all the solutions which i found weren't helpful. Also tried oracle demo of Java Web Start, i am doing the same as mentioned.

I have also got a ref site, downloaded jnlp and when tried to execute - The same problem was there.

https://www.qoppa.com/files/pdfnotes/demo/jPDFNotes_savetoweb.jnlp

Pankaj Shakya

I have already tried it with eager...but no change and  checked all jars, they are containing all methods and classes which are being invoked. I have been working on this problem since last 3 days, all the solutions which i found weren't helpful. Also tried oracle demo of Java Web Start, i am doing the same as mentioned.

I have also got a ref site, downloaded jnlp and when tried to execute - The same problem was there.

https://www.qoppa.com/files/pdfnotes/demo/jPDFNotes_savetoweb.jnlp

user13654132

Do you still solve dthis problem? cause im having the same issues here. Webutil function works fine when using browser but problem when using webstart.

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

Post Details

Locked on Jul 13 2017
Added on Jun 15 2017
#apex-discussions, #data, #database, #schema, #workspace
3 comments
1,273 views