How to get the output from .jar execution in python codes?

Question

I'm programming the python module that executes SQL to DBMS and retrieves data. I'm trying to use jdbc jar files instead of native DB drivers. I'm wondering how to executes jar file in python and get output from jar execution. And I'd like to know how to pass SQL string to jar argument. Here is the simplified code. Any help is greatly appreciated.

[ java code ]

public class GetDBResults {
    public static void main(String[] args) {

        // return sql results
        for(int i=0; i<=100; i++){
            // Is this the proper way to generate the output?
            System.out.println(i+"/t"+i*100+1);
    }
  }
}

[ python code ]

subprocess.call( [ 'java','-jar','./GET_DB_DATA.jar' )

# how to get results from jar execution?
# how to pass SQL string to jar execution?

ovgolovin · Accepted Answer · 2014-02-02 12:53:21Z

18

You can read the output through pipe:

>>> from subprocess import Popen, PIPE, STDOUT
>>> p = Popen(['java', '-jar', './GET_DB_DATA.jar'], stdout=PIPE, stderr=STDOUT)
>>> for line in p.stdout:
    print line

As regards passing string to stdin, you can achieve it this way:

>>> p = Popen(['cat'], stdin=PIPE, stdout=PIPE, stderr=STDOUT)
>>> stdout, stderr = p.communicate(input='passed_string')
>>> print stdout
passed_string

edited Feb 2, 2014 at 12:53

answered Feb 2, 2014 at 12:44

ovgolovin

13.5k7 gold badges53 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bruce Jung Over a year ago

Thank your perfect answer. It works like a charm. I think there are many people who are trying to executing jar files in Python. This will help their trials and errors to reduce.

Crista23 Over a year ago

@ovgolovin How can one make two consecutive calls without reloading the jar once it has been loaded? Thanks!

ovgolovin Over a year ago

@Crista23 I would do it through pipe communication. But then it will require to implement reading from pipe on java side.

ifryed · Accepted Answer · 2014-02-02 12:09:58Z

3

If you are using Linux you can use the os.system command:

os.system("your_java_file > out_put_file")

This command will execute the file and print the output to the out_out_file Then you can read the output file.

answered Feb 2, 2014 at 12:09

ifryed

6059 silver badges21 bronze badges

3 Comments

Bruce Jung Over a year ago

Thank you for your fast answer.

Bruce Jung Over a year ago

Wow. Your simple code works as well in mac mountain lion as well.

ifryed Over a year ago

It just uses the shell commands, and mac OS is based on Unix as well as Linux, so thats why the same commands work.

Azwr · Accepted Answer · 2014-02-02 12:08:50Z

2

You could do :

with open('output_of_jar.txt','w') as fp :
    subprocess.Popen('java -jar ./GET_DB_DATA.jar',stdout=fp).wait()
with open('output_of_jar.txt') as f :
    output = f.read()
print output

Edit :

stdout=fp means that the output of the command will be written to the file output_of_jar.txt

Then you just have to read the contents of the file with :

with open('output_of_jar.txt') as f :
    output = f.read()
print output

answered Feb 2, 2014 at 12:08

Azwr

7848 silver badges13 bronze badges

2 Comments

Bruce Jung Over a year ago

Thank you. You answered within only one minute. I'll try your solution.

Bruce Jung Over a year ago

I added the option "shell=True" then your solution worked nicely.

Collectives™ on Stack Overflow

How to get the output from .jar execution in python codes?

3 Answers 3

3 Comments

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related