After a morning of research, I'm stumped on what should be an easy piece of code.

All I want is to get all records from our raw\_material table in the test database.

Here is what I am doing:

```
public static void fetchIthos(ArrayList<String> ithosList, UserDto user) {
        // TODO Auto-generated method stub

    //get our stuff first - raw materials and doc names and paths
    try {

        Connection conn = user.getConnection();
        Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery("SELECT * FROM raw_material where object_id > 0");

        do {
        String result = rs.getString("raw_material_number").toString();
        System.out.println("next item: " + result);
        //ithosList.add(rs.getString("raw_material_number"));
        } while(rs.next());
    }

     catch (Exception e) {
       ithosList.equals(null);
        System.out.println("DB error : " + e);
     }
}

```

Here are the results in mySQL:

[![Result](https://i.stack.imgur.com/BVHyh.png)](https://i.stack.imgur.com/BVHyh.png)

so I would expect the first 'result' to be `MAN-500-121200000`, but it is showing as `RAW-001485`

I cannot see anywhere in the code that I am 'skipping' the first record, but if I let it go, it will skip the next one to `MAN-500-056100000`

Am I using the wrong user connection? That is the only thing I can see that affects this.

I thought `user.getConnection()` would do it for just the regular test database.