@DatabaseField(index = true) private String name; List<User> users = new ArrayList<>(); ... LazyForeignCollection<Comment> comments = dao.getEmptyForeignCollection("comments"); QueryBuilder<Post, Integer> postQueryBuilder = dao.queryBuilder(); postQueryBuilder.where().eq("id", postId); postQueryBuilder.join(commentsQuery); Post post = dao.queryForFirst(postQueryBuilder.prepare()); post.setComments(comments.deepRefetch()); HikariConfig config = new HikariConfig(); config.setJdbcUrl("jdbc:mysql://localhost/testdb"); config.setUsername("username"); config.setPassword("password"); HikariDataSource dataSource = new HikariDataSource(config); DatabaseConnectionProxyFactory.setDataSource(dataSource);