It allows you to select the JDBC driver that you wish to use for the connection to the DBMS. The combo box only offers those drivers available according to the selected DBMS.
JDBC drivers are identified by:
- JDBC Driver: specifies the driver to be used, eg: com.microsoft.jdbc.sqlserver.SQLServerDriver
- JDBC URL: specifies the information from the database, eg: jdbc:microsoft:sqlserver://<server_name>:1433;databaseName=<database_name>;SelectMethod=cursor
If the "Custom Driver" value is chosen in the JDBC Driver property, the Custom JDBC Driver and Custom JDBC URL properties are enabled so that, in them, said information is entered with the syntax shown in the above examples. Bear in mind that both properties are case sensitive.
If, instead, the "Custom Driver" value is not chosen in the JDBC Driver property, it'll probably be because selecting one of the JDBC Drivers offered will prove more useful. In that case, the Custom JDBC Driver will disappear (because a JDBC Driver was chosen among those offered).
Build any object
Drivers: JDBC
DBMSs: SQL Server, Oracle, iSeries Native, DB2 Universal Database, Informix, PostgreSQL, MySQL
Database name property
Server Name Property
Server TCP/IP Port Property
Use Custom JDBC URL Property