How to open and use cmd.exe from java

Question

i have to open cmd.exe from java and then open sqlplus.exe in the same window, but i can't. what i can do is open cmd but i'm unable to use it, for the sqlplus.exe it seems like its opening a different instance of cmd.exe and i can see the welcome msg from sqlplus in netbeans java terminal but unable to make querys.

And here's the code i'm using

public void construirJob(String nombre,Fecha fecha,String direccionSQL){
    try {
         command[0] = "cmd";
         command[1] = "/c";
         command[2] = "start cmd.exe && cd C:/oraclexe/app/oracle/product/11.2.0/server/bin && dir && sqlplus.exe"
           + " && @"+direccionSQL+" && connect /as sysdba; && select * from v$tablespace;";
        JobDetail job = JobBuilder.newJob(HelloJob.class)
                .withIdentity(nombre+"JOB", "group1").build();

        String schedule=fecha.segundos+" "+fecha.minutos+" "+fecha.hora+" "+"*"+" "+"*"+" "+fecha.dia;
        Trigger trigger = TriggerBuilder
                .newTrigger()
                .withIdentity(nombre+"trigger", "group1")
                .withSchedule(
                        //CronScheduleBuilder.cronSchedule("0/10 * * * * ?"))
                        CronScheduleBuilder.cronSchedule(schedule))
                .build();

        //schedule it
        Scheduler scheduler = new StdSchedulerFactory().getScheduler();
        scheduler.start();
        scheduler.scheduleJob(job, trigger);
    } catch (SchedulerException ex) {
        Logger.getLogger(CronTriggerExample.class.getName()).log(Level.SEVERE, null, ex);
    }
}

http://stackoverflow.com/questions/15734416/how-can-cmd-exe-be-launched-from-java — Markus Koivisto, Nov 11 '13 at 16:12

score 0 · Answer 1 · answered Nov 11 '13 at 16:14

0

I would take a look at apache commons exec library. http://commons.apache.org/proper/commons-exec/

There are also Turorials available on how to use this library: http://commons.apache.org/proper/commons-exec/tutorial.html

answered Nov 11 '13 at 16:14

angabriel

4,979
2
35
37

How to open and use cmd.exe from java

1 Answers1