Identifying which database service to connect to. The data source name parameter dsn of cx_nnect() andĬx_Oracle.SessionPool() is the Oracle Database connection string Prompt closing of connections is important when using connection pools soĬonnections are available for reuse by other pool users.
Use the variable connection outside of the block will simply fail. This code ensures that, once the block is completed, the connection is closedĪnd resources have been reclaimed by the database. execute ( "insert into SomeTable values (:1, :2)", ( 1, "Some string" )) connection. connect ( user = user, password = password, dsn = "/orclpdb1", encoding = "UTF-8" ) as connection : cursor = connection. These include limiting the amount of time that opening a connection can take, orĮxample: Standalone Connection to Oracle Database Settings can be configured in Optional Oracle Net Configuration Files or in Optional Oracle Client Configuration Files. Many connection behaviors can be controlled by cx_Oracle options. Initialization time, and then SessionPool.acquire() can be called to Pools are created with cx_Oracle.SessionPool() at application
Useful for applications that want a few connections available for infrequent Recommended for applications that must be reliable. Support Oracle’s high availability features and are Connections are created byĬonnection pooling is important for performance whenĪpplications frequently connect and disconnect from the database. These are useful when the application maintains a single user There are two ways to connect to Oracle Database using cx_Oracle: Connections between cx_Oracle and Oracle Database are used for executing
0 kommentar(er)
