From: Kjell R. <kje...@da...> - 2010-09-01 08:26:45
Attachments:
kjell_rilbe.vcf
|
Hi, What does the ODBC data source configuration option "safe thread" mean? It's a checkbox down to the left. I can't see that it's documented in the online help. Thanks, Kjell -- ------------------------------ Kjell Rilbe DataDIA AB E-post: kje...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
From: Kjell R. <kje...@da...> - 2010-09-02 11:20:23
Attachments:
kjell_rilbe.vcf
|
Hi, What does the ODBC data source configuration option "safe thread" mean? It's a checkbox down to the left. I can't see that it's documented in the online help. Thanks, Kjell -- ------------------------------ Kjell Rilbe DataDIA AB E-post: kje...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
From: Jorge A. B. <li...@da...> - 2010-09-16 16:17:17
|
It´s for multi-thread apps, like Clarion ones, because fbclient is not thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) Regards El 02/09/2010 8:20, Kjell Rilbe escribió: > Hi, > > What does the ODBC data source configuration option "safe thread" mean? > It's a checkbox down to the left. > > I can't see that it's documented in the online help. > > Thanks, > Kjell > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > > > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
From: Kjell R. <kje...@da...> - 2010-09-16 16:22:26
|
Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. In what way does the option affect the behavior of the ODBC driver? What, exactly, can be done in the "on" mode that can't be done in the "off" mode? And vice versa? What are the pros and cons of each mode? I know very weel what threading is about and how you write threaded apps. I just don't know how this option affects the ODBC driver. I need to know that, to be able to use it correctly in case I want to use threads in my apps. Thanks, Kjell Jorge Andrés Brugger skriver: > It´s for multi-thread apps, like Clarion ones, because fbclient is not > thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) > > Regards > > El 02/09/2010 8:20, Kjell Rilbe escribió: >> Hi, >> >> What does the ODBC data source configuration option "safe thread" mean? >> It's a checkbox down to the left. >> >> I can't see that it's documented in the online help. >> >> Thanks, >> Kjell >> >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> >> >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > . > -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
From: Jorge A. B. <li...@da...> - 2010-09-16 16:45:38
|
It's very simple: ODBC driver does what fbclient doesn't. You develop multi-thread apps (meaning "one connect by thread", not "one connection, multiple threads using same connection)? Check the box "safe thread". You dont? Dont check that box. Regards. El 16/09/2010 13:22, Kjell Rilbe escribió: > Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. > > In what way does the option affect the behavior of the ODBC driver? > What, exactly, can be done in the "on" mode that can't be done in the > "off" mode? And vice versa? What are the pros and cons of each mode? > > I know very weel what threading is about and how you write threaded > apps. I just don't know how this option affects the ODBC driver. I need > to know that, to be able to use it correctly in case I want to use > threads in my apps. > > Thanks, > Kjell > > Jorge Andrés Brugger skriver: >> It´s for multi-thread apps, like Clarion ones, because fbclient is not >> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >> >> Regards >> >> El 02/09/2010 8:20, Kjell Rilbe escribió: >>> Hi, >>> >>> What does the ODBC data source configuration option "safe thread" mean? >>> It's a checkbox down to the left. >>> >>> I can't see that it's documented in the online help. >>> >>> Thanks, >>> Kjell >>> >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> >>> >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> . >> |
From: Kjell R. <kje...@da...> - 2010-09-17 03:41:28
|
OK, so what it means is that with "Safe thread" off, I can't even use one connection per thread? I was under the impression that fbclient *is* thread safe provided you use seperate connection(s) for each thread. Is this incorrect? Thanks, Kjell Jorge Andrés Brugger skriver: > It's very simple: ODBC driver does what fbclient doesn't. You develop > multi-thread apps (meaning "one connect by thread", not "one connection, > multiple threads using same connection)? Check the box "safe thread". > You dont? Dont check that box. > > Regards. > > El 16/09/2010 13:22, Kjell Rilbe escribió: >> Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. >> >> In what way does the option affect the behavior of the ODBC driver? >> What, exactly, can be done in the "on" mode that can't be done in the >> "off" mode? And vice versa? What are the pros and cons of each mode? >> >> I know very weel what threading is about and how you write threaded >> apps. I just don't know how this option affects the ODBC driver. I need >> to know that, to be able to use it correctly in case I want to use >> threads in my apps. >> >> Thanks, >> Kjell >> >> Jorge Andrés Brugger skriver: >>> It´s for multi-thread apps, like Clarion ones, because fbclient is not >>> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >>> >>> Regards >>> >>> El 02/09/2010 8:20, Kjell Rilbe escribió: >>>> Hi, >>>> >>>> What does the ODBC data source configuration option "safe thread" mean? >>>> It's a checkbox down to the left. >>>> >>>> I can't see that it's documented in the online help. >>>> >>>> Thanks, >>>> Kjell >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Start uncovering the many advantages of virtual appliances >>>> and start using them to simplify application deployment and >>>> accelerate your shift to cloud computing. >>>> http://p.sf.net/sfu/novell-sfdev2dev >>>> >>>> >>>> _______________________________________________ >>>> Firebird-odbc-devel mailing list >>>> Fir...@li... >>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> . >>> > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > . > -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
From: Jorge A. B. <li...@da...> - 2010-09-17 16:20:55
|
http://tech.dir.groups.yahoo.com/group/firebird-support/message/100655 El 17/09/2010 0:41, Kjell Rilbe escribió: > OK, so what it means is that with "Safe thread" off, I can't even use > one connection per thread? I was under the impression that fbclient *is* > thread safe provided you use seperate connection(s) for each thread. Is > this incorrect? > > Thanks, > Kjell > > Jorge Andrés Brugger skriver: >> It's very simple: ODBC driver does what fbclient doesn't. You develop >> multi-thread apps (meaning "one connect by thread", not "one connection, >> multiple threads using same connection)? Check the box "safe thread". >> You dont? Dont check that box. >> >> Regards. >> >> El 16/09/2010 13:22, Kjell Rilbe escribió: >>> Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. >>> >>> In what way does the option affect the behavior of the ODBC driver? >>> What, exactly, can be done in the "on" mode that can't be done in the >>> "off" mode? And vice versa? What are the pros and cons of each mode? >>> >>> I know very weel what threading is about and how you write threaded >>> apps. I just don't know how this option affects the ODBC driver. I need >>> to know that, to be able to use it correctly in case I want to use >>> threads in my apps. >>> >>> Thanks, >>> Kjell >>> >>> Jorge Andrés Brugger skriver: >>>> It´s for multi-thread apps, like Clarion ones, because fbclient is not >>>> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >>>> >>>> Regards >>>> >>>> El 02/09/2010 8:20, Kjell Rilbe escribió: >>>>> Hi, >>>>> >>>>> What does the ODBC data source configuration option "safe thread" mean? >>>>> It's a checkbox down to the left. >>>>> >>>>> I can't see that it's documented in the online help. >>>>> >>>>> Thanks, >>>>> Kjell >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Start uncovering the many advantages of virtual appliances >>>>> and start using them to simplify application deployment and >>>>> accelerate your shift to cloud computing. >>>>> http://p.sf.net/sfu/novell-sfdev2dev >>>>> >>>>> >>>>> _______________________________________________ >>>>> Firebird-odbc-devel mailing list >>>>> Fir...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>> ------------------------------------------------------------------------------ >>>> Start uncovering the many advantages of virtual appliances >>>> and start using them to simplify application deployment and >>>> accelerate your shift to cloud computing. >>>> http://p.sf.net/sfu/novell-sfdev2dev >>>> _______________________________________________ >>>> Firebird-odbc-devel mailing list >>>> Fir...@li... >>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>> . >>>> >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> . >> |
From: Kjell R. <kje...@da...> - 2010-09-20 04:31:50
|
Yes, but that only confirms that the client library is thread safe in such a way that it works if you use separate connection(s) for each thread. So, then what does the "safe thread" option in the odbc driver add? Kjell Jorge Andrés Brugger skriver: > http://tech.dir.groups.yahoo.com/group/firebird-support/message/100655 > > El 17/09/2010 0:41, Kjell Rilbe escribió: >> OK, so what it means is that with "Safe thread" off, I can't even use >> one connection per thread? I was under the impression that fbclient *is* >> thread safe provided you use seperate connection(s) for each thread. Is >> this incorrect? >> >> Thanks, >> Kjell >> >> Jorge Andrés Brugger skriver: >>> It's very simple: ODBC driver does what fbclient doesn't. You develop >>> multi-thread apps (meaning "one connect by thread", not "one connection, >>> multiple threads using same connection)? Check the box "safe thread". >>> You dont? Dont check that box. >>> >>> Regards. >>> >>> El 16/09/2010 13:22, Kjell Rilbe escribió: >>>> Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. >>>> >>>> In what way does the option affect the behavior of the ODBC driver? >>>> What, exactly, can be done in the "on" mode that can't be done in the >>>> "off" mode? And vice versa? What are the pros and cons of each mode? >>>> >>>> I know very weel what threading is about and how you write threaded >>>> apps. I just don't know how this option affects the ODBC driver. I need >>>> to know that, to be able to use it correctly in case I want to use >>>> threads in my apps. >>>> >>>> Thanks, >>>> Kjell >>>> >>>> Jorge Andrés Brugger skriver: >>>>> It´s for multi-thread apps, like Clarion ones, because fbclient is not >>>>> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >>>>> >>>>> Regards >>>>> >>>>> El 02/09/2010 8:20, Kjell Rilbe escribió: >>>>>> Hi, >>>>>> >>>>>> What does the ODBC data source configuration option "safe thread" mean? >>>>>> It's a checkbox down to the left. >>>>>> >>>>>> I can't see that it's documented in the online help. >>>>>> >>>>>> Thanks, >>>>>> Kjell >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> Start uncovering the many advantages of virtual appliances >>>>>> and start using them to simplify application deployment and >>>>>> accelerate your shift to cloud computing. >>>>>> http://p.sf.net/sfu/novell-sfdev2dev >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Firebird-odbc-devel mailing list >>>>>> Fir...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>>> ------------------------------------------------------------------------------ >>>>> Start uncovering the many advantages of virtual appliances >>>>> and start using them to simplify application deployment and >>>>> accelerate your shift to cloud computing. >>>>> http://p.sf.net/sfu/novell-sfdev2dev >>>>> _______________________________________________ >>>>> Firebird-odbc-devel mailing list >>>>> Fir...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>>> . >>>>> >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> . >>> > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > . > -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
From: Dimitry S. <sd...@ib...> - 2010-09-20 07:42:08
|
20.09.2010 6:31, Kjell Rilbe wrote: > So, then what does the "safe thread" option in the odbc driver add? Every API call is serialized using mutex. So, if you call routines from different threads they won't work in parallel. -- SY, SD. |
From: Kjell R. <kje...@da...> - 2010-09-20 08:03:27
|
Dimitry Sibiryakov skriver: > 20.09.2010 6:31, Kjell Rilbe wrote: >> So, then what does the "safe thread" option in the odbc driver add? > > Every API call is serialized using mutex. So, if you call routines from different > threads they won't work in parallel. Crystal clear! Thank you! Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |