Re: When the column typing error is matched, compulsion ROLLBACK is generated.
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Fri, 21 Jan 2011 17:21:17 +0900 ???? <[email protected]> wrote: > I use FreeTDS for the connection from PHP on Linux to MSSQL. > When SQL transaction that became an error of the column type mismatch was > executed, ROLLBACK was compulsorily issued by FreeTDS. > (Compulsion ROLLBACK is not generated at other SQL errors.) > I completed the correction of the source, and had SQL of the column type > mismatch not requested now. Could you please post a patch demonstrating your "correction"? I don't know what you mean by "ROLLBACK was compulsorily issued by FreeTDS". Are you referring to autocommit? AFAIK, the FreeTDS ODBC driver never spontaneously issues a ROLLBACK request to the server. Transactions are under application control via SQLTransact(). > Is it a specification of FreeTDS that ROLLBACK is compulsorily issued when > the error of SQL of the column type mismatch is issued? I do not understand what you mean by "column type mismatch". --jkl