A way to deploy plsql to Oracle in Java project with Maven build tool

I join to project where plsql sources developed and stored in Oracle DB.

There are two copies of sources - on test and on production servers. So SPOT (single point of trust) rule was broken. Copies require synchronisation from time to time and this job is performed manually.

But most annoying thing come from configuration management - I can't reproduce previous working project copy because old plsql scripts was lost (new version have changes in API).

After studying subject I found awesome project: https://code.google.com/p/plsqlmaven

By following https://code.google.com/p/plsqlmaven/wiki/Basics I can dump all plsql scrips (and diff between production and testing) from DB'es:

  $ mvn plsql:extract -Dforce

but I stuck with plsql:deploy command (it print error about missing jars, I don't understand how to create it). I will contact to author soon and will fill some bug reports.

But I hope that community already solve such basic task for project vitality.

How can I deploy plsql scripts to Oracle DB in Java project (my project uses Maven build system)?

PS I look to SQL Developer tutorials on oracle.com - I can't find how to deploy entirely plsql files hierarchy by one button click. And I prefer command line solution...

PPS I report related errors to plsqlmaven project:

PPPS I ask question at http://rsdn.ru/forum/java/5011849.flat (Russian)

Answers


This is one of the situations I'd love to use flyway, as it lets you manage version and scripts.

It is also handy when testing, as it lets you seed the database into a given state.


Need Your Help

Best way to slow down a thread? Is using Sleep() OK?

c++ performance multithreading sleep cpu-usage

I've written a C++ library that does some seriously heavy CPU work (all of it math and calculations) and if left to its own devices, will easily consume 100% of all available CPU resources (it's also

Change Box2D Anchor Point?

ios cocos2d-iphone box2d points

In Cocos2D I am creating my CCSprites with anchor points of (0,1) which is similar to the way UIKit does it. Anyway, I am trying to change the anchor point in Box2D, is this possible?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.