Example of a repository configured to have its connections auto closeable

RepositorioExample.java

@TransactionScoped
public class Repository {

  @Resource(mappedName = "java:jboss/datasources/MyDS")
  private DataSource        dataSource;

  private Connection        connection;

  @PostConstruct
  public void open() {
    try {
      this.connection = dataSource.getConnection();
    } catch (SQLException e) {
      e.printStackTrace();
      throw new WebApplicationException(e.getMessage());
    }
  }

  @PreDestroy
  public void close() {
    if (this.connection == null) return;
    try {
      if (!this.connection.isClosed()) {
        this.connection.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
      throw new WebApplicationException(e.getMessage());
    }
  }
  
  ...
}