Can i build and compile a JAVA pgm in another JAVA program?

[bob connolly]

Hello!

I'm wondering if i can build a JAVA program 2 within JAVA a program 1, compile the program 2 in the program 1 and then run program 2 from the program 1?

I need to do this because the PipedInput/OutputStream processes need to know which, in this case Oracle table, is being used, to verify both ends of the pipe, right up front!

I've tried every combination of things, and the only one that works is when everything the program needs is known by the system right up front!

And because i have over 300 potential files to process, for me to create a unique program for every file, would result in having to create over 300x4 unique programs!

Right now i am extracting the file requested, passing the parms to a .ksh shell, the .ksh shell assembles the pieces of the program, including table name seleted, compiles the program and then runs the program!

So now i'd like to see if i can put this process into a java program as some of our users are not using UNIX!

Thanks very much for any ideas!

bc

[K Riaz]

Use the Reflection API

[Ernest Friedman-Hill]

Reflection won't really help you compile and run a Java program; it only can be used to inspect and access existing compiled Java classes. It will be necessary to use reflection (in the form of the Class.forName() and Class.newInstance() methods) to load the code after you've compiled it.

You can invoke Sun's Java compiler like this, or you can use the Runtime.exec() method to run it via the command-line interface.

Although they've always discouraged it in the past, I think there may even be an official Sun document somewhere about invoking the newest version of the compiler from code -- I just can't remember where I saw it.

[bob connolly]

Thanks again Ernest!!!

I think this 'java statement' approach will do the trick and save lots of headaches! thanks also Kashif!

Ernest, i have your book 'Jess in Action' right over my desk and follow your emails, can't wait to use Jess one of these days!

Have a great week!

bc

[Ilja Preuss]

Originally posted by bob connolly:
I need to do this because the PipedInput/OutputStream processes need to know which, in this case Oracle table, is being used, to verify both ends of the pipe, right up front!

I don't fully understand what you are getting at here, but I strongly suspect that there will be a *much* simpler approach to solve this problem. Care to elaborate?

[bob connolly]

Sure Ilja!

Basically, i was trying to get the following PipedInput/OutputStream program to work, by passing an oracle table name into the program, but for some reason, the pipes don't want to connnect when the table_name is passed into the program, but if the name is "hard coded" in the program it works fine!

So what i've done so far, is build the program via UNIX scripts, ie, when a user selects a file from an online screen, the script concatenates the program pieces together ie, header_code + oracle_table_name + trailer_code, compiles it and runs it!

But now i need to package up the process so that it runs via JAVA only components as 1 of our users isn't using UNIX, so i've been able to put most of processes into 2 JAVA programs, except for this one, which extracts XML from an oracle table and validates it using a SAX validator and instead of writing the XML to an external file, it buffers the XML directly into the validation routine, eliminating a huge external XML file!

This feature was "supposed" to be available in 10g!

Here is the program if you might have any ideas about why the Piped files don't want to connect unless the table_name is hard coded, see <<<<<<<<<<<
in the code

 
import java.io.*;
import java.util.regex.*;
import java.sql.*;
import java.net.*;
import oracle.jdbc.driver.*;
import java.io.File;
import java.io.IOException;
import java.lang.*;
import java.util.*;
import java.text.*;
import java.sql.*;
import java.net.*;
import java.io.*;
import oracle.xml.sql.query.*;
import oracle.xml.parser.v2.*;
import oracle.xml.parser.v2.XMLSAXSerializer;
import oracle.jdbc.driver.*;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.FactoryConfigurationError;
import javax.xml.parsers.ParserConfigurationException;
import org.xml.sax.SAXException;
import org.xml.sax.SAXParseException;
import org.xml.sax.ErrorHandler;
import java.io.File;
import java.io.IOException;
import org.w3c.dom.Document;
import org.w3c.dom.DOMException;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.w3c.dom.Element;
import org.w3c.dom.ranges.DocumentRange;
import org.w3c.dom.traversal.*;
import org.xml.sax.helpers.DefaultHandler;
import javax.xml.parsers.SAXParser;
import java.util.*;
import java.lang.Runtime;
import javax.imageio.stream.MemoryCacheImageInputStream;
 
class   HlpValOraBufXml4 extends Thread 
{
PrintStream ps;
 
//HlpValOraBufXml_bldprt1 above
public static final String IN_TABLE=new String("fn_ll_lossmit"); <<<<<<<<<<<<<<<,
//HlpValOraBufXml_bldprt2 below
 
public boolean DEBUG       = false;
public int     NUM_COLS    = 0;
public String  TABLE_NAME  = IN_TABLE.toUpperCase();
public static  String[]      _columnNames  = new String [100];
public String  ROWSET      = new String("hlp_data");
public String  ROW         = new String(TABLE_NAME);
 
public String  hostname    = "";
public String  port        = "";
public String  sid         = "";
public String  username    = "";
public String  password    = "";
public String  dbo         = "";
public String  table_name  = "";
public String  xsd         = ""; 
public String  xml         = "";
public String  ddl         = "";
public String  debug       = "";
 
    HlpValOraBufXml4 (PrintStream ps, OraParms con) 
    {
        this.ps      =ps;
        this.hostname   =con.hostname;
        this.port       =con.port;
        this.sid        =con.sid;
        this.username   =con.username;
        this.password   =con.password;
        this.dbo        =con.dbo;
        this.TABLE_NAME =con.table.toUpperCase();
        this.table_name =con.table.toLowerCase();
        this.xsd        =con.xsd;
        this.xml        =con.xml;
        this.ddl        =con.ddl;
        this.debug      =con.debug;
        if (debug!=null) DEBUG=true; 
    }
    public void run() 
    {
        if (ps != null) 
        {
           int j=0;
 
           if (DEBUG) System.out.println("ddl used: "+this.ddl);
           
           BufferedReader textReader = null;
           try {
                  textReader    = new BufferedReader(new FileReader(this.ddl));
                  String line   = null; String SEPARATOR = "\\|";
                  while ( (line = textReader.readLine()) != null )
                  {
                      String[] sa = line.split(SEPARATOR);
                      if (sa[2].equals(table_name)) { _columnNames[j]=sa[3].toUpperCase(); j++; }
                  }
                  textReader.close();
           }
           catch (IOException e) {System.out.println("ddl err:"+e); }
           NUM_COLS=j;
 
           if (DEBUG) System.out.println("NUM_COLS: "+NUM_COLS);
           
           try
           {
              String  q = new String("Select ");
              String cb = new String(" ");
              String pd = new String(" ");
 
              if  (!this.dbo.equals(" ")) pd=new String(".");  
 
              for (int i=0;i<NUM_COLS;i++)
              {
                     if (i!=NUM_COLS-1) {cb=",";} else {cb=" ";}
                     q  = q.concat(_columnNames[i]+cb); 
              }
              String q2 = new String("FROM "+this.dbo+pd);
                     q  = q.concat(q2);
                     q  = q.concat(TABLE_NAME);
 
              if (DEBUG) System.out.println("Qry:"+q+" "+this.hostname+" "+this.port+" "+this.sid+" "+this.username+" "+this.password);
 
              DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
              Connection conn = DriverManager.getConnection
              ("jdbc :-o	 racle:thin:@" + this.hostname + ":" + this.port + ":" + this.sid, this.username, this.password);
              Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
              ResultSet rset = stmt.executeQuery (q);
              OutputStream out=ps; 
              XMLSAXSerializer sample = new XMLSAXSerializer(out);
              OracleXMLQuery qry = new OracleXMLQuery(conn, q);
              String nx = new String();nx=null;
              qry.setRowsetTag(ROWSET);
              qry.setRowTag(ROW);
              qry.setRowIdAttrName(nx);
              qry.getXMLSAX(sample);
           }  catch(SQLException sqlException) {System.out.println("HlpValOraBufXml4 - reading ORACLE table: " + sqlException);}
        }
    }
    protected void finalize() 
    {
            if (ps != null) 
            {
                ps.close();
                ps = null;
            }
    }
}
 
class   HlpValOraBufXml3 extends Thread  
{
    public static InputStream getXML(OraParms con) {
        PipedOutputStream pos = null;
        PipedInputStream  pis = null;
        try 
        {
            pos = new PipedOutputStream();
            pis = new PipedInputStream(pos);
            PrintStream ps = new PrintStream(pos);
 
            new HlpValOraBufXml4 (ps,con).start();
        }
        catch (Exception e) 
        { 
            System.out.println("HlpValOraBufXml3: " + e); 
        }
        return pis;
    }
}
class HlpValOraBufXml2 extends Thread
{
 public HlpValOraBufXml2(OraParms con) throws Exception
 {
     MyDefaultHandler dh = new MyDefaultHandler();
 
     HlpValOraBufXml3 pip = new HlpValOraBufXml3();
 
     if (con.debug==null || con.debug.equals("d"))
     {     
        try
        {
           HlpValSax1 v1 = new HlpValSax1();
           SAXParser sp = v1.getParser(con.xsd);
           sp.parse( pip.getXML(con),dh );
        }
        catch (Exception e) { System.out.println("HlpValOraBufXml2: "+e); }
     }
     else
     if (con.debug.equals("pr"))
     {
        try
        {
          BufferedInputStream bis = new BufferedInputStream( pip.getXML(con) );
 
          int i=0;int j=0;int t=0;int linec=0; char [] ca = new char[300]; String line;
 
          while (i>-1)
          {
            j++;
            i=bis.read();  char c=(char)i;  ca[j]=c;
            if  (c == '\n')
            {
                 linec++;
                 line = new String(ca);
                 System.out.println(line);
                 j=0;
            }
          }
        } catch (FileNotFoundException e) {}
          catch (IOException e)           {}
     } 
  }
}
//wrk
 
public class HlpValOraBufXml1
{
public static void main(String args[])
{
    boolean  DEBUG  =    false;
    String   debug  =    new String();
    if (args.length==9)  {System.out.println("Error: argument count in error");}
    if (args.length==10) {debug = null;}
    if (args.length==11) {debug = new String(args[10]); DEBUG=true;}
 
    OraParms cp = new OraParms();
    cp.hostname = args[0];
    cp.port     = args[1];
    cp.sid      = args[2];
    cp.username = args[3];
    cp.password = args[4];
    if ( args[5].equals("NULL") || args[5].equals("null") ) {cp.dbo=" ";} else {cp.dbo = args[5];}
    cp.table    = args[6];
    cp.ddl      = args[7];
    cp.xml      = args[8];
    cp.xsd      = args[9];
    cp.debug    = debug;
    if (DEBUG) {
       System.out.println ("args:  "+args[0]+args[1]+args[2]+args[3]+args[4]+args[5]+args[6]+args[7]+args[8]+args[9]+debug);
       System.out.println ("hvoed: "+cp.hostname+cp.port+cp.sid+cp.username+cp.password+cp.dbo+cp.table+cp.xsd+cp.xml+cp.ddl+cp.debug);
    }
    try 
    { 
       HlpValOraBufXml2 hvobx  = new HlpValOraBufXml2(cp);
    }
    catch (Exception e) {}
}
 
}
 

[Stan James]

Is this whole effort to change the table name? Can you just get table names from parameters or a file?

[Ilja Preuss]

Originally posted by bob connolly:
Basically, i was trying to get the following PipedInput/OutputStream program to work, by passing an oracle table name into the program, but for some reason, the pipes don't want to connnect when the table_name is passed into the program, but if the name is "hard coded" in the program it works fine!

Can you show us how you tried to pass the table_name into the program? I'm convinced that we should be able to get it work.

[bob connolly]

Well, actually, i am passing the table name into the program in:

this.TABLE_NAME =con.table.toUpperCase();
this.table_name =con.table.toLowerCase();

but if i didn't have that table name hard coded initially in this line of code:

public static final String IN_TABLE=new String("fn_ll_lossmit"); <<<<<<<

, the pipes don't seem to want to make the connections, must have tested this at least 10 times!

But i will re-test it again this morning just to be triply sure!

Thanks!
bc

[bob connolly]

Hi Ilja!

Thanks for the prompt to go back and look at this from the top! as it seems to be working fine by passing the table_name in, great news! and i'm now trying to figure out what got me on this track to begin with!

So appreciate everyone's assistance on this and i quess the moral of this distraction is, the only way to be an optimist in this business is to be a pessimist, when the analyst, programmer and tester are one in the same?

But on the bright side, i now know how to build, compile and run a JAVA program from within another JAVA program, very nice! and i wrote a Groovy script to do a similar thing!

Have a great week all!