Create a service definition for a JDBC connection to the database of your choice.
To set up a JDBC connection from within Event Stream Processor, edit ESP_HOME/bin/service.xml.
Database | DriverLibrary Value |
---|---|
Adaptive Server Enterprise | esp_db_jdbc_sybase_lib |
Microsoft SQL Server | esp_db_jdbc_mssql_lib |
IBM DB2 | esp_db_jdbc_db2_lib |
Oracle | esp_db_jdbc_oracle_lib |
Kx Systems KDB+ | esp_db_jdbc_kdb_lib |
SAP HANA | esp_db_jdbc_lib |
<Parameter Name="DataSource">com/sap/db/jdbcext/DataSourceSAP</Parameter>
Parameter | Description |
---|---|
Host | Database server host name. |
Port | Database server port number. |
Database | Database name. This parameter is not necessary for Oracle and
KDB. Important: For the Oracle JDBC
driver, replace the Database
parameter with the Instance
parameter. For example, <Parameter
Name="Instance">orcl</Parameter>.
|
or
Parameter | Description |
---|---|
ConnectString |
(Optional) This is a JDBC style connect string that contains the host, port and database information. This overrides the three separate Host, Port, and Database parameters. For guidelines on the format of this parameter, see the documentation provided with the database to which you wish to connect. If you want to enable password encryption between your driver and an external server, add the EncryptPassword property to the connect string and set it to true. For example: <Parameter Name="ConnectString>jdbc:sybase:Tds:localhost:5000/cep?ENCRYPT_PASSWORD=true</Parameter> |