Ideally, we should use the same connection and at the end of your program, you can add index.close() which will close the connection. So you dont need try-with resources.