Oracle Data Source

Oracle Data Source
lac31
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 Creator
 supports.
In this article:
 
 
2
 
 
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 Creator
 on Tomcat, copy the license file and the 
ojdbc<version>.jar
 JAR file (the JDBC driver) into the 
%Tomcat_Home%/lib
 directory.
If you have installed the self-contained, single-user version of 
CA Live API Creator
 that is based on Jetty, copy the JDBC driver into the 
%JETTY_HOME%/caliveapicreator/lib/ext
 directory.
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.
  1. In the connection wizard, select 
    Oracle
     as the target database.
  2. Complete the Schema, Database, host, port, and password fields, including the following fields, and then click 
    Continue
    :
     
    Type
     
    The Oracle connection type.
     
    Default:
     SID
     
    Options:
     SID, Service Name, TNS
     
    SID/Service/Alias
     
    The alphanumeric database identifier.
     
    Schema
     
    This database value accepts double quotes. Use double quotes to accept the value of mixed-case (non-standard) schema name.
     
    Example:
     "MySchema".
     
    Username
     
    This 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 Creator
 must 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 Creator
 supports 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 Creator
 supports read and write of the following Oracle data types:
Data type
Modeled as...
char
string
varchar2
string
nchar
string
nvarchar2
string
number
number
timestamp
SimpleTimestamp
timestamp with timezone
SimpleTimeOffset
timestampwithlocal timezone
SimpleTimeOffset
interval year to month
IntervalYearMonth
interval day to second
IntervalDaySecond
raw
bytes
long raw
bytes
rowid
bytes
bfile
bytes
urowid
bytes
long
string
float
number
date
SimpleTimestamp
binary double
number
binary float
number
blob
bytes
clob
string
nclob
string
ref cursor
 
Varrays, Nested tables
 
Other Supported Oracle Data Types
 
CA Live API Creator
 supports the following other data types:
Data type
Modeled as...
Notes
ref cursor
 
This data type is a pointer or handle to a ResultSet on the database.
xml
string
This data type stores XML data.