Hi all,
I noticed a very strange behavior when DBPROC returns cursor which includes DATE and TIME columns.
---- Enviroment ------ MaxDB 7.5.0.8 on Linux JDBC DRIVER 7.5.01 <-------------------------------- Latest! ---------------------------
CREATE DBPROC DT RETURNS CURSOR AS
DECLARE :$CURSOR CURSOR FOR
SELECT DATE, TIME FROM SYSDBA.DUAL
;With JDBC the date and time received with
PreparedStatement st = conn.prepareStatement("CALL DT");
rs = st.executeQuery();
will be incorect.There is another POST about this bug, i dont know if its MAXDB Database related and already fixed or perhaps is an issue of the JDBC driver that it isnt fixed yet?
In any case i would like to know if it will be fixed in the next release or if i install the lastest DB release ........... or i have to patch it and live with it a looooong time :)
Thanx, Josu.
Primero se llevaron a los negros, pero a mi no me import� porque yo no lo era. Enseguida se llevaron a los judios, pero a mi no me import�, porque yo no lo era. Despu�s detuvieron a los curas, pero como yo no soy religioso tampoco me import�. Luego apresaron a los comunistas, pero como yo no era comunista tampoco me import�. Ahora me llevan a mi, pero ya es tarde.
(Bertolt Brecht)
_________________________________________________________________
Acepta el reto MSN Premium: Correos m�s divertidos con fotos y textos incre�bles en MSN Premium. Desc�rgalo y pru�balo 2 meses gratis. http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_correosmasdivertidos
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
