You may be having the same problem that I am having.  Make sure that you are not ignoring exceptions on stmt.close and rs.close.  I found a case where next() returns false instead of throwing an exception when it hits a row that it cannot handle – but an exception was thrown on the close.

-----Original Message-----
From: Rodolfo M. Raya [mailto:rmraya@...]
Sent: Thursday, April 11, 2002 9:42 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Different results between Interclient and Typ4 driver

Hi,

The following query endS with different result sets if you use interclient or the new typ4 driver.

SELECT A.CODIGO, A.DESCRIPCION, A.SUBRUBRO,
     SUM(S.CANTIDAD) AS STOCK, SUM(R.CANTIDAD) AS VENTAS
FROM ARTICULOS A
    JOIN STOCK S ON S.ARTICULO = A.CODIGO
    JOIN ROTACION R ON R.ARTICULO = A.CODIGO
WHERE A.PROVEEDOR = 'UNI'
GROUP BY A.CODIGO, A.DESCRIPCION, A.SUBRUBRO
ORDER BY A.DESCRIPCION

With interclient I get 2445 rows, but with the new driver only 6 rows are retrieved.

I wrote a simple program using the type 4 driver and was worried because the result seemed incredible. Then I switched the connection URL and driver name and automagically all the data appeared on screen. The rest of the program remained untouched, only the driver name and URL.

Can anybody tell me what's wrong?

Thanks,

Rodolfo

-- 

 MAXPROGRAMS

 IBM Business Partner

 Microsoft MSDN Business Connection Partner

 rmraya@...

 http://www.maxprograms.com