> # Using the Java Transaction API

> Table 5-2 lists which databases are supported for the Java Transaction API (JTA) by the JDBC Client.

> Table 5-2. Support for the Java Transaction API (JTA) by the JDBC Client
> Database | JTA Supported?
> --- | ---
> Oracle | Yes
> Informix | Yes
> DB2 UDB on Linux, UNIX, and Windows | Yes
> JDBC Socket | No
> Microsoft SQL Server | Yes
> ODBC Socket | No
> Sybase | Yes

> Once a JDBC data source has been registered with JNDI, it can be used by your JDBC application as shown in the following example, typically through application server software:

>     Context ctx = new InitialContext();
>     XADataSource ds = (XADataSource)
>     ctx.lookup("jdbc/EmployeeDB");
>     XAConnection xacon = ds.getXAConnection("scott", "tiger");

> In this example, the JNDI environment is first initialized. Next, the initial naming context is used to find the logical name of the JDBC data source. The Context.lookup() method returns a reference to a Java object, which is narrowed to a javax.sql.XADataSource object. Finally, the XADataSource.getXAConnection() method is called to establish a connection with the SequeLink service.

> See "Creating and Managing JDBC Data Sources" for instructions on creating JDBC data sources.