We shall use an Oracle database table to add and find a table row from Trinidad user interfaces. Install Oracle Enterprise Pack for Eclipse 12c, and install the Oracle Database 11g XE. We shall be creating a catalog entry in an Oracle database table with user input from a Trinidad components-based user interface. For that create a database table—JournalCatalog—
and add some table rows with the following SQL script:
CREATE TABLE JournalCatalog(CatalogId VARCHAR(255) PRIMARY KEY, Journal VARCHAR(255), Publisher Varchar(255), Edition VARCHAR(255), Title Varchar(255), Author Varchar(255)); INSERT INTO JournalCatalog VALUES('catalog1', 'Oracle Magazine', 'Oracle Publishing', 'September-October 2010', 'Using Oracle Essbase Release 11.1.2 Aggregate Storage Option Databases', 'Mark Rittman and Venkatakrishnan Janakiraman'); INSERT INTO JournalCatalog VALUES('catalog2', 'Oracle Magazine', 'Oracle Publishing', 'July-August 2010', 'Infrastructure Software and Virtualization...