Reading all rows by using multiple columns in java jackcess

Question

In Java using Jackcess, I have 2 questions on the below code.

In the below code, I have used only the column Active to fetch rows. How can I add multiple columns in same table? Or can I make a join?
The below code fetches only 1 row. Where can I find the logic of reading the entire result set?

The docs of jackcess is not complete on these aspects. Also in making search, all examples were related to jackcess 1 and not for latest version.

Row row = CursorBuilder.findRow(tblTC, Collections.singletonMap("Active", true));

if(row != null) {
    System.out.println(row);
}

For more complex queries (including JOINs, etc.) you might want to consider using `UCanAccess`. For more information look [here](http://stackoverflow.com/q/21955256/2144390). — Gord Thompson, Apr 05 '14 at 11:40
Wow. That was super easy. Can you please add this as an answer so that I can accept it. — Purus, Apr 05 '14 at 11:57

score 2 · Accepted Answer · edited May 23 '17 at 10:26

2

For more complex queries (including JOINs, etc.) you might want to consider using UCanAccess. For more information see a related question here.

edited May 23 '17 at 10:26

Community

answered Apr 05 '14 at 12:01

Gord Thompson

1 Answers1