1. Oracle TimesTen In-Memory Database Support User's Guide
  2. Configuring TimesTen Connections for an ODP.NET Application
  3. About TimesTen Connections for ODP.NET

About TimesTen Connections for ODP.NET

ODP.NET for TimesTen supports multiple simultaneous connections to TimesTen and Oracle databases. Existing applications written for the ODP.NET interface can access TimesTen with a minimal set of changes to their application code.

In a TimesTen environment, ODP.NET uses OCI to interact with the TimesTen database. Therefore, an ODP.NET application can connect to TimesTen using either the tnsnames or the easy connect naming method, as with Oracle Database. See Configuring Naming Methods in Oracle Database Net Services Administrator's Guide for information about the tnsnames and easy connect naming methods beyond what is provided below.

Be aware of the following:

  • TimesTen does not support distributed transactions through OCI. Therefore, an ODP.NET application cannot use distributed transactions in a TimesTen connection.

  • ODP.NET for TimesTen does not support global runtime load balancing (a feature for Oracle RAC databases) and therefore does not support the connection string attribute setting "Load Balancing=true".

  • Error messages associated with connections to TimesTen from an ODP.NET application are based on TimesTen OCI error message mapping. TimesTen OCI errors are propagated to the ODP.NET application as OracleException objects. (Also see OCI Error Reporting in Oracle TimesTen In-Memory Database C Developer's Guide.)