To insert a new Oracle Database, follow these procedures:
1.Right-click the project's name in Explorer and select the Insert - Database option. In Domain mode, right-click the Server objects - Databases item, select the Insert Database In option, and then the project's name. The object is then created and its script edition window is opened.
2.To configure it, go to the Configuration tab on the Properties Window.
Configuration for Oracle Databases
The available options on this tab are described on the next table.
Available options for the Configuration tab
Option |
Description |
|---|---|
Database |
Selects the type of Database to use in this project. Possible values for this option are 0: stAccess, 1: stOracle, 2: stSqlServer, 3: stPostgreSQL, or 4: stMySQL. This option corresponds to the SourceType property of a Database object |
Connection |
Allows selecting a local connection, if available, or typing the name of a connection provided by a database administrator |
Allows using Oracle's ADO (ActiveX Data Objects) interfaces, so that an Elipse E3 Query object recognizes a TIMESTAMP data type, enabled in the Use TIMESTAMP type option. Then users can read records from Oracle databases with a precision of milliseconds. Please check the next note for more information. This option corresponds to the OracleUseADODrivers property of a Database object |
|
Use TIMESTAMP type |
Allows using Oracle's TIMESTAMP data type, with a precision of milliseconds and available since version 9.0. If this option is disabled, uses a DATE data type, with a precision of seconds. Please check the next note for more information. This option corresponds to the OracleEnableTimestamp property of a Database object |
User |
User of the database connected via Elipse E3. This option corresponds to the UserName property of a Database object |
Password |
Password of the user performing the logon |
Test Connection |
Tests the connection with an Oracle server |
•The options Use Oracle Provider for OLE DB and Use TIMESTAMP type are enabled by default in applications created with version 6.6. In applications created in previous versions, those configurations are respected, but it is not recommended to disable these options. The possibility of disabling these options must be removed from future versions of Elipse E3. •Removing the selection of the Use Oracle Provider for OLE DB option automatically removes the selection of the Use TIMESTAMP type option. •The Use Oracle Provider for OLE DB option can be enabled or disabled for new Database objects on the Properties tab of the Domain options. •Applications created in versions earlier than version 5.0, when executed in version 5.0 or later or when loading a Database object in Elipse E3 Studio, automatically select the Use Oracle Provider for OLE DB option if the Use TIMESTAMP type option is selected. •In Elipse E3 Studio, users are asked if they want to save that change. •When executing this application, that change persists only during the execution, returning to the previous status until users save that change. |
3.In the Database option, select the 1 - stOracle item.
4.If the Oracle server is local, the Connection option may remain blank, because Elipse E3 automatically retrieves this information. Otherwise, the connection is created using an Oracle client installed on the computer.
5.If necessary, configure the User and Password options according to Oracle settings. Such options may remain blank and, in this case, the application assumes Elipse E3 default configurations.
6.Click Test Connection to check whether these settings are correct and then click OK to save these settings.
When inserting a Database in an application, some options regarding the type of database are enabled, which is responsible for managing and storing information about objects that use this service.