Subject Re: Re: Re: [firebird-support] Looking for any driver with Firebird 3.0 boolean type support
Author liviuslivius
Post date 2013-10-30T09:02:58Z
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?
 
regards,
Karol Bieniaszewski
 
 
W dniu 2013-10-25 20:37:04 użytkownik Helen Borrie <helebor@...> napisał:
 

I had written:

>>>a lack of people prepared to test new stuff and report back to the developers.

At 11:16 p.m. 25/10/2013, liviuslivius wrote:

>Thanks for help i tested it and i can do select from empty table (i did not try to select with records) but i can not insert data
>
>"conversion error from string "0" ..

It sounds like a bug, either in the driver or in the DML implementation itself. It would be beneficial to report it, in both firebird-odbc-devel and firebird-devel, with your test case.

>and this is what i try to do - create automatic tests for FB3 but without driver i can not do this ;-)

Yes, I have noticed that you *are* one who is willing to test. My comment was directed at the world in general, not at you, Karol.

Have you tried your testing with isql? It uses an API interface that is embedded in the engine. If you get failures there, it certainly reduces the field of investigation. Report such discoveries to firebird-devel or firebird-test, though. Alpha and Beta testing is off-topic for this forum.

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________

~-|**|PrettyHtmlStart|**|-~