sqlplus functionality to run sql scripts in java (create, compile...)

Hi,

I have a application where tables and pl/sql packages need to be created.
Until now, this is done in sql scripts that are called from sqlplus, everything works fine.

But I d like to use the same scripts from java. is there a component that does this for me? Its not hard to write a java class that runs the "create table"s etc from a file, but i also need to compile pl/sql and always want to check the status of the command / compilation.

in short, i am re-implementing the sqlplus functionality in a java class where i can check if the stuff was run successfully.

I found hensql add sourceforge, from which i might strip the functionality, but as i am using it in a comercial product i cant make my application GPL license.

TIA
christof Received on Wed Apr 02 2003 - 08:35:11 CST