Subject Re: [firebird-support] Looking for any driver with Firebird 3.0 boolean type support
Author
Post date 2013-10-30T19:28:29Z
 
Sent: Wednesday, October 30, 2013 6:24 PM
Subject: Re: [firebird-support] Looking for any driver with Firebird 3.0 boolean type support
 
 

> Hi,
> i do trace and this is from trace log for failed

statement
> this two fields are boolean
"UMOWA_ZLECFAKT_AUTOMAT","UMOWA_ZLECFAKT_KUMUL"
> INSERT INTO
"AUDIT_UMOWA"
>
("AUDIT_DT","AUDIT_OPERACJA","AUDIT_USER","UMOWA_ID","DYR_ID","UMOWA_ID_SEQ","INSP_ID","PRAC_ID","KONT_ID","TYP_UMOWY_ID","RODZ_UMOWY_ID","STATUS_UMOWY_ID","UMOWA_DATA_ZAWARCIA","UMOWA_DATA_WYPOWIEDZENIA","UMOWA_DATA_OD","UMOWA_DATA_DO","PRZYCZ_ID","UMOWA_DZIALANIA","UMOWA_ID_STARA","UMOWA_POSTANOWIENIA","UMOWA_TYTUL_IMPREZY","UMOWA_ZLECFAKT_AUTOMAT","UMOWA_ZLECFAKT_KUMUL","UMOWA_ZLECFAKT_PLATNA_ID","UMOWA_ZLECFAKT_OKRES_ID","TERMIN_PLATNOSCI","KONTO_PLATNIKA")
>
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
> 0
ms
> 2013-10-30T09:46:08.1990 (1724:01B63730) ERROR AT
JStatement::execute
> C:\FIREBIRDDB\TESTOWA.TEST (ATT_8, SYSDBA:NONE,
NONE, TCPv4:192.168.16.1)
>
P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL
Error
> 335544436 : SQL error code = -303
> 335544334 : conversion
error from string "0"
> 2013-10-30T09:46:08.2190 (1724:01B649F0) ERROR AT
JResultSet::freeEngineData
> C:\FIREBIRDDB\TESTOWA.TEST (ATT_10,
SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
>
P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL
Error
> 335544436 : SQL error code = -501
> 335544577 : Attempt to
reclose a closed cursor
> 2013-10-30T09:46:08.2190 (1724:01B649F0) ERROR
AT JResultSet::freeEngineData
> C:\FIREBIRDDB\TESTOWA.TEST (ATT_10,
SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
>
P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL
Error
> 335544436 : SQL error code = -501
> 335544577 : Attempt to
reclose a closed cursor
> 2013-10-30T09:46:08.2290 (1724:01B649F0)
TRACE_FINI
> SESSION_1 Firebird Audit
> 2013-10-30T09:46:10.6320
(1724:01B63730) ERROR AT JResultSet::freeEngineData
>
C:\FIREBIRDDB\TESTOWA.TEST (ATT_8, SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
> P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
>
335544569 : Dynamic SQL Error
> 335544436 : SQL error code = -501
>
335544577 : Attempt to reclose a closed cursor
> 2013-10-30T09:46:10.6320
(1724:01B63730) TRACE_FINI
> SESSION_1 Firebird Audit
>
2013-10-30T09:46:10.6320 (1724:01B681F8) TRACE_FINI
> SESSION_1 Firebird
Audit
> now i am not sure if this is ODBC problem or
FB?

>>I'm not sure either, because I don't have the ODBC driver in
use, but
>>with the Trace API you should also get the parameter values
when
>>executing a prepared statement, which should give you a clue on
what
>>parameter is failing.

>>--
>>With
regards,
>>Thomas Steinmaurer
>>http://www.upscene.com/

Hi,
 
i have parameters enabled in trace
for all other inserts into tables without boolean fields in trace i see parameters values
but for statement run from ODBC with boolean fields this is only information i got – without parameter values
 
 
regards,
Karol Bieniaszewski