JDBC Provider Editor field descriptions

Last Updated : Apr 20, 2023 |
Prolog information
Name
Description
Provider
The name of the JDBC provider
Class Name
The name of the class file in the driver jar that implements the javax.sql.DataSource interface. The actual class name might differ per the uploaded driver jar.
For example:
For Postgres, you can enter org.postgresql.xa.PGXADataSource
For MySQL, you can enter com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
For MS-SQL, you can enter com.microsoft.sqlserver.jdbc.SQLServerXADataSource
For Oracle, you can enter oracle.jdbc.xa.client.OracleXADataSource or oracle.jdbc.pool.OracleConnectionPoolDataSource
Select Jar File
The jar file that contains the JDBC drivers. Select Browse... to upload the jar file from your local computer.
Note:
Verify the jar file before uploading it. Verify the file using the command jar tf <filename of the jar file> or by opening the jar file using WinZip.
Description
The description for the JDBC provider.
Button
Description
Commit
Adds the JDBC provider or saves the changes to the JDBC configuration.
Cancel
Cancels the add or edit action.