Problem with ResultSet

[flaquitqm]

Hello everybody:
I have a problem with a result set too. ResultSet doesn't get all data store in my table, the cursor start in the third row, so I miss rows 1 and 2. How can I put the cursor in the first row in a TYPE_FORWARD_ONLY result set? Here is my code:

TDepartamento dpto = new TDepartamento();
ArrayList<TDepartamento> listaDptos = new ArrayList<TDepartamento>();
try {
sql = "Select * from Departamento order by idDpto";
statement = TConexion.getConexion().prepareStatement(sql);

ResultSet rs = statement.executeQuery();
while (rs.next()){
dpto.setCodigo(rs.getInt("CodigoDpto"));
dpto.setDpto(rs.getString("Dpto"));
listaDptos.add(dpto);
}


return listaDptos;
}

sorry for my english and thank you

[travishein]

I don't see how this would cause the result to start off on not the first row.

Only idea is if you are not closing the statement, maybe your custom data accessor is reusing the same open connection, and if it has a reference to the statement in some kind of not threadsafe manner,then maybe the same result set is being read by more than one client at once ?

[Tolls]

Even so, unless that's some sort of non=standard result set there is no way that code there will skip lines (and I wish you'd put a link to this post in the other one you hijacked).

[RamyaSivakanth]

As per the code you put,its not a scrollable ResultSet.There is no chance as you mentioned record got missed.By default cursor will point before first row and go on travese till the end.

My doubt is whether any where checking sake have u put "rs.next()"? Once if u use rs.next(),then there is a chance that traversal as happened already...just post your complete code.

[flaquitqm]

Thanks to all of you for help me. Here is the complete code:

public ArrayList<TDepartamento> GetDepartamentos() throws SQLException{

ArrayList<TDepartamento> listaDptos = new ArrayList<TDepartamento>();
try {
sql = "Select * from Departamento";

PreparedStatement statement = TConexion.getConexion().prepareStatement(sql);

ResultSet rs = statement.executeQuery();

while (rs.next()){
int t = rs.getRow();
TDepartamento dpto = new TDepartamento();

dpto.setCodigo(rs.getInt("CodigoDpto"));
dpto.setId(rs.getInt("IdDpto"));
dpto.setDpto(rs.getString("Dpto"));

listaDptos.add(dpto);
}

return listaDptos;


} catch (Exception e) {
// TODO: handle exception
return listaDptos;
}
}

I have the same problem with other resultset in other procedure.
when I execute the sql code directly in my database I get row, son the sql statement is ok, but my resultset doesn't have that row and I get an exception.

[travishein]

.. ok, what is the exception.

[Tolls]

Are you really eating all Exceptions there?
That's not good.

[flaquitqm]

The exception tells me that resultset is close. Now everything is working, I didn't get that exception, but I don't know why it was happening.

[Tolls]

I didn't understand any of that, sorry.

What does your code look like now, and what problems/errors/exceptions are you getting, and where?