Try-with-resources equivalent in Java 1.6

Question

I have the following code:

    public class Main {

        public static void main(String[] args) throws SQLException {

            try (
                    Connection conn = DBUtil.getConnection(DBType.HSQLDB);
                    Statement stmt = conn.createStatement(
                            ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
                    ResultSet rs = stmt.executeQuery("SELECT * FROM tours");
                    ) {

            DBUtil.getConnection();

            } catch (SQLException e) {
                DBUtil.processException(e);
            } 

        }

    }

I use this code to fetch data from a database. My problem is that I'm not allowed to use the Java 1.7 compiler and have to use 1.6. How can I translate the try-with-resources-code to use with a 1.6 compiler? What exactly happens in this special try block?

Put all the lines between parenthesis at the beginning of the `try` code, and put all closing code in a `finally` after all the `catch`s. — AntonH, May 12 '14 at 14:38
(i) put the statements in the try code (ii) close what needs to be closed in a finally block. — assylias, May 12 '14 at 14:38
is this that easy? ok, I thought the try-with-ressources was more complicated because I've seen some strange posts — schirrmacher, May 12 '14 at 14:41
Why can't you use the Java 7 compiler? You could set the target compatibility to Java 6... — Duncan Jones, May 12 '14 at 14:46
this is for a university project and we should use the 1.6 compiler — schirrmacher, May 12 '14 at 14:48

Ordous · Answer 1 · 2014-05-12T14:51:15.953

Oracle explains how try-with-resources works here

The TL;DR of it is:
There is no simple way of doing this in Java 1.6. The problem is the absence of the Suppressed field in Exception. You can either ignore that and hardcode what happens when both try AND close throw different exceptions, or create your own Exception sub-hierarchy that has the suppressed field.

In the second case, the link above gives the proper way of doing it:

   AutoClose autoClose = new AutoClose();
   MyException myException = null;
   try {
       autoClose.work();
   } catch (MyException e) {
       myException = e;
       throw e;
   } finally {
       if (myException != null) {
           try {
               autoClose.close();
           } catch (Throwable t) {
               myException.addSuppressed(t);
           }
       } else {
           autoClose.close();
       }
   }

is equivalent to

try (AutoClose autoClose = new AutoClose()) {
    autoClose.work();
}

In case you want to make it easier and not create a whole lot of new Exception classes, you will have to decide what to throw in the catch clause inside the finally (t or e).

PS. Dealing with multiple variable declaration in the try is also discussed in the link above. And the amount of code that you need to do it properly is staggering. Most people take shortcuts in Java 1.6 by not coping with exceptions in the finally block and using nullchecks.

Saša · Answer 2 · 2018-04-04T15:05:14.063

I would advise usage of apache's commons-dbutils library which have class DBUtils with close and closeQuietly methods. The code would look like this:

import org.apache.commons.dbutils.DBUtils;
...
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

try {
    conn = myOwnUtil.getConnection();
    stmt = conn.createStatement();
    rs = stmt.executeQuery( "SELECT * FROM table" ); // or any other custom query
} catch ( SQLException e ) {
    <<handle exception here>>;
} finally {
    DBUtils.closeQuietly( conn );
    DBUtils.closeQuietly( stmt );
    DBUtils.closeQuietly( rs );
    // or simply use DBUtils.close( conn, stmt, rs );
}

Note that closeQuietly will throw no exceptions, while close might cast SQLException, so adapt the code to your own use case.

If you want to close streams than you can use apache's commons-io with IOUtils class which also have close and closeQuietly.

score 0 · Answer 3 · answered May 12 '14 at 14:42

0

Do it like this:

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

try {
    conn = DBUtil.getConnection(DBType.HSQLDB);
    stmt = conn.createStatement(
    ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
    rs = stmt.executeQuery("SELECT * FROM tours");
} catch (SQLException e) {
    DBUtil.processException(e);
} finally {
    if(conn != null) {
        conn.close();
    }
    if(stmt != null) {
        stmt.close();
    }
    if(rs != null) {
        rs.close();
    }
}

answered May 12 '14 at 14:42

Sergi

579
3
14

2

-1 This is not equivalent to try-with-resources. Particularly around exception handling. – Duncan Jones May 12 '14 at 14:48
Years of flame wars and we're back to where we started. A simple google search on "Java 6 close resources" will give plenty of explanations of why this is incorrect, including SO questions. http://stackoverflow.com/questions/5782647/how-to-correctly-close-resources this for example, from 3 years ago (with the accepted answer of "Use JDK 7, it's just that much simpler") – Ordous May 12 '14 at 15:13
wouldn't close statements in finally block need another try/catch ? – Danish ALI Sep 08 '21 at 23:21

Try-with-resources equivalent in Java 1.6

3 Answers3

Linked

Related