Chapter 3 | Section 3.5 |
Setting Properties of the JDBC/ODBC eWay | eWay Environment Properties |
JDBC Connector Settings
Details for the JDBC Connector Settings used by the external database are detailed in Table 7.
Table 7 Outbound JDBC eWay—JDBC Connector Settings
Name | Description | Required Value |
|
|
|
Description | The description of the database. | A valid string. The configured default |
|
| is JDBC Connection Pool Datasource. |
|
|
|
ClassName | Specifies the Java class in the JDBC | A valid class name. |
| driver that is used to implement the | For example: |
| ConnectionPoolDataSource, | com.ibm.as400.access.AS400JDBCCon |
| XADataSource interface. Change as | nectionPoolDataSource |
| needed for your driver. | See JDBC/ODBC Drivers on |
|
| page 117 for some of the popular |
|
| drivers you can use with this eWay. |
|
|
|
ClassNamefor | For Sun Java Composite Application | A valid class name. |
OtherInterfaces | Platform Suite components such as |
|
| eTL that do not use |
|
| ConnectionPoolDataSource, use this |
|
| entry to enter the name of the driver |
|
| class. This entry is not used by the |
|
| JDBC eWay. |
|
|
|
|
ServerName | This setting specifies the host name | Any valid string. |
| of the external database server. |
|
|
|
|
PortNumber | Specifies the I/O port number on | A valid port number. |
| which the server is listening for |
|
| connection requests. |
|
|
|
|
DatabaseName | Specifies the name of the database | Any valid string. |
| instance. |
|
|
|
|
User | Specifies the user name the eWay | Any valid string. |
| uses to connect to the database. |
|
|
|
|
Password | Specifies the password used to | Any valid string. |
| access the database. |
|
|
|
|
DriverProperties | The Connection Pool DataSource | Set the driver properties according to |
| implementation may need to execute | driver vendor's instruction. For |
| additional methods to assure a | example: |
| successful run. The additional | setDefTdpName#DBSQL##setWorkspa |
| methods will need to be identified in | ce#Navigator## |
| the Driver Properties. You must |
|
| ensure that the driver is installed on |
|
| both the Logical Host machine and |
|
| the Enterprise Designer machine. |
|
|
|
|
Delimiter | This is the delimiter character to be | The default is #. |
| used in the DriverProperties prompt. |
|
|
|
|
JDBC/ODBC eWay Adapter User’s Guide | 33 | Sun Microsystems, Inc. |