We needed the same SQL Plus plugin that Jon, because our SQL Script
contains some Oracle specific instructions (can't remember which ones)
that the JDBC driver doesn't support contrary to SQLPlus tool.
Moreover our DBA works on this files and doesn't want to know about
JDBC special things.
So we developped a Maven SQLPlus plugin inhouse (I am not sure I can
share it, but it's easy to develop). It is heavily based on Maven Exec
plugin, but configuration is very similar to the standard SQL plugin
(except JDBC URL is replaced by TNSNAME). Here is what does:
- Gather all SQL scripts in a single file append some extra
instructions at the begining (on sqlerror, set autocommit...)
- Execute SQLPlus
- Parse SQLPlus output to detect Errors (ORA-12345 error codes)
I works rather well, we are so happy with that solution that we
developped a SQLLoader plugin on the same model.
Gérald
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
