Imagine a simple database with a 'documentos' table.
I have a main class: EjecutarSQL1.java, which calls to a BD class: BD.java, in order to make a query to the database.
The problem is when I try to make a query like select count(*) from documentos or like select distinct name from documentos
The output (the problem) is shown below. The source code at the end of the post.
There are four querys: - a simple select (that works right) - one with 'count(*)' (does not work, I get an Invalid cursor state error) - and other two with 'distinct' (first does not work and the other it does).
And why this code works?. In this case it's only a class: EjecutarSQL.java which querys to the database directly.
Thanks in advance! Juanjo
[added some line breaks so page doesn't scroll] [ March 17, 2006: Message edited by: Jeanne Boyarsky ]