Re: [gnome-db] Threads.

On Fri, 2009-07-24 at 21:44 +1000, Bas Driessen wrote:

> 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."

No, that is not it. The configure flags as follows:

--with-readline \
        --with-ssl=/usr \
        --without-debug \
        --enable-shared \
        --with-embedded-server \
        --localstatedir=/var/lib/mysql \
        --with-unix-socket-path=/var/lib/mysql/mysql.sock \
        --with-mysqld-user="mysql" \
        --with-extra-charsets=all \
        --with-big-tables \
        --with-innodb \
        --with-ndbcluster \
        --enable-local-infile \
        --enable-largefile \
        --enable-thread-safe-client \
        --disable-dependency-tracking \
        --with-named-thread-libs="-lpthread"

The --enable-thread-safe-client flag is set. Therefore my original
question. 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?

Thanks,
Bas.

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list