Oracle Data Source
Oracle Data Source
This article includes information about how to install the Oracle JDBC driver, how to connect to an Oracle database, and a list of the Oracle data types that
CA Live API Creatorsupports.
In this article:
Install the Oracle JDBC Driver
After you have installed the JDBC driver, the Oracle data source is available as an option in the connection wizard when creating an API.
For more information about the supported versions of the JDBC drivers, see Supported Platforms.
If you have installed
CA Live API Creatoron Tomcat, copy the license file and the
ojdbc<version>.jarJAR file (the JDBC driver) into the
If you have installed the self-contained, single-user version of
CA Live API Creatorthat is based on Jetty, copy the JDBC driver into the
Connect to an Oracle Database
Prerequisites:You know your JDBC connection information.
Connect to your Oracle database by creating your API.
For more information about how to create an API using API Creator, see Create your API Project.
- In the connection wizard, selectOracleas the target database.
- Complete the Schema, Database, host, port, and password fields, including the following fields, and then clickContinue:TypeThe Oracle connection type.Default:SIDOptions:SID, Service Name, TNSSID/Service/AliasThe alphanumeric database identifier.SchemaThis database value accepts double quotes. Use double quotes to accept the value of mixed-case (non-standard) schema name.Example:"MySchema".UsernameThis database value accepts double quotes. Use double quotes to accept the value of mixed-case (non-standard) username.
You are connected to the database.
Oracle Supported Data Types
When you are setting up a connection to an external data source,
CA Live API Creatormust map the data types in the data source to data types in
CA Live API Creator. The following tables lists the different data type mappings applicable when working with an Oracle database.
CA Live API Creatorsupports a subset of the full range of Oracle data types.
For more information about the Oracle data types, see the Oracle documentation.
CA Live API Creatorsupports read and write of the following Oracle data types:
timestamp with timezone
interval year to month
interval day to second
Varrays, Nested tables
Other Supported Oracle Data Types
CA Live API Creatorsupports the following other data types:
This data type is a pointer or handle to a ResultSet on the database.
This data type stores XML data.