|Subject||RE: [Firebird-Java] Different results between Interclient and Typ4 driver|
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.
From: Rodolfo M. Raya [mailto:rmraya@...]
Sent: Thursday, April 11, 2002 9:42 AM
Subject: [Firebird-Java] Different results between Interclient and Typ4 driver
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?
IBM Business Partner
Microsoft MSDN Business Connection Partner
To unsubscribe from this
group, send an email to:
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.