SAP DB:ODBC Przewodnik Instalacji Strona 112
- Strona / 225
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
mxODBC - Python ODBC Database Interface
6.4.2 Errors due to missing Transaction Support
If you get an exception during connect telling you that the driver is not capable or
does not support transactions, e.g.
mxODBC.NotSupportedError: ('S1C00',
84, '[Microsoft][ODBC Excel Driver]Driver not capable ', 4226)
, try
to connect with
clear_auto_commit set to 0. mxODBC will then keep auto-
commit switched on and the connection will operate in auto-commit mode.
6.5 Connection objects as context managers
6.5.1 Introduction to Context Managers
Python 2.5 introduced the new concept of context manager to Python. Context
managers are Python objects implementing the context manager API based on the
methods .__enter__() and .__exit__().
The context managers can be used together with the Python with-statement to
wrap sections of a program into a block (the context) that is entered and exited in
a controlled way:
with context_manager as context:
context.do_something()
When entering the block, the context_manager's .__enter__() method is
called and the returned object assigned to
context. When exiting the block, the
context.__exit__() is called, either with the exception that caused the block to
be left or without exception in case the block was left normally.
6.5.2 Using connection objects as context object
Connection objects implement this API and use it to automatically commit or roll
back the current transaction.
from mx.ODBC.Manager import DriverConnect
connection = DriverConnect(…)
with connection:
cursor = connection.cursor()
cursor.execute('INSERT INTO table VALUES (?, ?)', (1, 2))
… other tasks …
cursor.close()
This code will automatically commit the INSERT to the database backend in cae
the with-block is left without exception. If the other tasks trigger an unhandled
transaction, the connection is rolled back when leaving the block.
For code which doesn't have to do more complex error handling, using the with-
statement block can greatly simplify the resulting code. It also gives the
transaction section a visible resemblance in the code.
90
- ODBC Database Interface 1
- Contents 3
- 1.2 Features 24
- 1.3 Requirements 26
- Mac OS X 27
- 2. Installation 28
- Operating System Platform 29
- Python Build Version 29
- 2.2.1 Prerequisites 30
- 2.2.2 Before You Start 30
- License Files 31
- Step 1 31
- 2.2.4 Uninstall 32
- 2.3.2 Before You Start 33
- Step 2 34
- Step 3 35
- Step 4 35
- 2.4.1 Before You Start 36
- 2.3.4 Uninstall 36
- 2.4.3 Uninstall 38
- Manual Uninstall 39
- 3.1 ODBC Application Stack 40
- [Microsoft][ODBC Driver 42
- Windows Registry Keys 43
- 3.2.6 DSN-less Connections 45
- [ODBC Data Sources] 49
- [ODBC Drivers] 50
- ODBCINI 50
- ODBCINSTINI 50
- 3.3.7 DSN-less Connections 52
- DNS-less Connection String 53
- 4.1 MS SQL Server 54
- Driver Limitations 58
- [MONET] 60
- 4.1.2 General Notes 61
- Access Violations 63
- Kerberos on Linux 64
- 4.2 MS Access Database 65
- 4.3 Oracle 65
- Driver Notes 66
- 4.4 IBM DB2 68
- 4.4.2 General Notes 69
- Linker Paths 70
- 4.5 Sybase ASE 71
- 4.6 PostgreSQL 73
- 4.7 MySQL 75
- .rownumber to the 76
- .rownumber 76
- 4.8 SAP MaxDB / SAPDB 77
- 4.9 Teradata 78
- ORDER BY clause to 80
- 4.10 Netezza 81
- Netezza and Unicode 82
- 4.11 Other Databases 83
- 5. mxODBC Overview 85
- 5.1.2 Extensions 86
- 5.3 Supported ODBC Versions 87
- 5.5 Transaction Support 88
- 5.5.2 Manual Commit 89
- 5.6 Stored Procedures 90
- Methods 91
- parametertypes Parameter 93
- 5.7 Introspection 98
- 5.8 ODBC Cursor Types 100
- 5.8.2 Default Cursor Type 101
- MS SQL Server 102
- Oracle 102
- Factory Functions 103
- Predefined Row Factories 105
- 5.10 mxODBC Subpackages 107
- 6.2 Connection Type Object 109
- 6.1 Subpackage Support 109
- 6.6 Unicode/ANSI Connections 113
- # string 114
- 7. mxODBC Cursor Objects 124
- 7.2 Subpackage Support 125
- 7.4 Cursor Type Object 125
- 7.6 Cursor Object Methods 126
- 7.6.1 Catalog Methods 135
- Common Interface 136
- Result Set Layouts 136
- Search Pattern Parameters 136
- Unicode 137
- Available Catalog Methods 137
- SQLBindCol() 138
- SQLGetData() and 138
- 7. mxODBC Cursor Objects 139
- .gettypeinfo(sqltype) 142
- 7.7 Cursor Object Attributes 156
- Per-Statement Binding Mode 164
- 8.3 SQL Type Input Binding 165
- UNICODE_STRINGFORMAT 166
- None singleton is 168
- 8.5 Output Conversions 171
- EIGHTBIT_STRINGFORMAT 172
- 8.7 Auto-Conversions 175
- 8.9 Additional Comments 177
- Handling 180
- 10.2 SQL Error Mappings 182
- 10.4 Error Handlers 183
- 10.4.2 Examples 184
- 10.5 Warning Classes 185
- 10.6 Database Warnings 185
- 11. mxODBC Functions 188
- 11.2 mx.ODBC Functions 189
- Classes 193
- Functions 193
- Driver Manager 195
- 14.4 mx.ODBC.iODBC 197
- Manager 197
- 14.5.1 Notes 199
- 64-bit Platforms 200
- 14.7 ODBC Driver Subpackages 202
- Running mxODBC with mod_wsgi 204
- Freezing mxODBC using py2exe 205
- 16. Examples 207
- 18. mxODBC Package Structure 210
- 19.1.1 211
- Windows ODBC Manager 211
- 19.1.2 iODBC Driver Manager 212
- 20. History & Changes 214
- 21. Copyright & License 215
- Version 1.3.0 216
- 1. Introduction 216
- 2. Terms and Definitions 216
- 3. License Grant 217
- 4. Authorizations 217
- 5. Modifications 218
- 8. NO WARRANTY 218
- 9. LIMITATION OF LIABILITY 218
- 10. Termination 219
- 11. Indemnification 219
- 12. Third Party Rights 219
- 13. High Risk Activities 219
- 14. General 220
- 15. Agreement 220
- 1 CPU License (Example) 221
- 1. License Grant 221
- 2. Covered Software 221
- 3. Authorizations 221
- 4. Proof 222
- 7.2 Redistribution 224
- 8. Proof 224
- 21. Copyright & License 225
Powiązane produkty i podręczniki dla Oprogramowanie SAP DB:ODBC
Oprogramowanie SAP DB:ODBC Instrukcja Naprawy
(124 strony)
(124 strony)
Oprogramowanie SAP DB:ODBC Dokumentacja
(196 strony)
(196 strony)
Simplicity S210 Handbücher
Bedienungsanleitungen und Benutzerhandbücher für Nähmaschinen Simplicity S210.
Wir stellen 1 PDF-Handbücher Simplicity S210 zum kostenlosen herunterladen nach Dokumenttypen zur Verfügung Bedienerhandbuch
Komentarze do niniejszej Instrukcji