Retrieving the execution plan for a SQL statement in Java

Answer

The following Java code, which works for running a SQL select statement, returns no output when the execution plan is requested:

package netezza;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Junk {
     public static Connection getConnection () {
          String databaseName="DEV_WHSE";
          Connection conn=null;
          String user="admin";
          String password="password";
          try {
               Class.forName("org.netezza.Driver");
               //.newInstance();
               conn =DriverManager.getConnection("jdbc:netezza://server1/" + databaseName, user, password);
               conn.setAutoCommit(false);
          }
   
          catch (Exception e) {
               e.printStackTrace();
               System.exit(1);
          }

          return conn;

     } //getConnection

     public static void main(String[] args) {
          ResultSet rs=null;
          Statement stmt = null;
          Connection conn=null;
          String sql = "explain verbose select * from orders";
         
          try {
               conn= getConnection();
               stmt = conn.createStatement();
               rs = stmt.executeQuery(sql);
               while (rs.next()) {
                    String resultString=rs.getString(1); System.out.println(resultString );
               } //while

               stmt.close();
               rs.close();
               conn.close();
          }

          catch (Exception e) {
               e.printStackTrace();
               System.exit(1);
          }
     } //main
} //Class

explain verbose select sic_code from sic_location s where sic_id< ";

SQLWarning w = stmt.getWarnings();
if (w != null) {
     do
     {
          System.out.println(w);
     }  while ((w = w.getNextWarning()) != null);
}