[Date Prev][Date Next]
Re: back-sql mysql innodb
> Problem solved. I had to comment a line in sql_wrap.c:
> * TimesTen : Turn off autocommit. We must explicitly
> * commit any transactions.
> SQLSetConnectOption( *dbhp, SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF );
> This last line actually prevents slapd from updating resultsets (which
> are committed) in InnoDB.
I believe this is not correct; we need autocommit to be off since
operations that need a commit explicitly do it. I think the problem is in
the RDBMS you're using, since other RDBMSes always worked as intended.
> Perhaps autocommit should be enabled by default, but the user should be
> able to disable it through a configuration option in slapd.conf. Should
> I file a request or bug for this?
Feel free. Configuration options that improve interoperation are always
welcome, pending my comment above.