Does the adapter perform a commit after issuing the publishing table SELECT statement?

book

Article ID: KB0088720

calendar_today

Updated On:

Products	Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database	-
Not Applicable	-

Description

Resolution:
Environment
---------------
All

When ODBC tracing is enabled for the adapter it can be observed that the following statement is issued at connect time:

ppid=568:pid=57 23b:11  ENTER SQLSetConnectAttr
                SQLHDBC             0x017730a8
                SQLINTEGER                 102
                SQLPOINTER                 1
                SQLINTEGER                  -5

The SQLINTEGER 102 corresponds to SQL_ATTR_AUTOCOMMIT.

So the DataDirect driver the Adapter is using has AUTOCOMMIT set and therefore no explicit COMMITs are necessary.