On Fri, 2009-07-24 at 21:39 +1000, Bas Driessen wrote: > Hello, > > Question regarding libgda and threads. > > I open a data source connection (ie: gda_connection_open_from_dsn) in > thread 1 and then I try to perform any action on the connection (ie: > gda_connection_statement_execute_select) in thread 2. If I do this in > Postgresql all works fine. If I try to do this in MySQL then the > system appears to hang in thread 2. I assume because thread 1 is > holding a lock on the connection. > > How can I remove the lock that is set by function > gda_connection_open_from_dsn so I can access the connection > information from thread 2? > > Perhaps slightly out of libgda scope, but is there a difference > between Postgresql and MySQL when it comes to threads and locking? It > appears that Postgresql does not have that concept or perhaps by > default configured not to use threads?
I think I found the answer in the manual: "If MySQL client was not compiled with the --enable-thread-safe-client flag, then the database provider will only allow connections to be opened from the thread which initializes Libgda. Otherwise there is no limitation." Thanks.
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
