Official Content

It allows typing the specific JDBC URL in the Custom JDBC URL property.

Values

False It does not enable the Custom JDBC URL property. This is the default value.
True It enables the Custom JDBC URL property.

Description

By choosing Use Custom JDBC URL = “True” you'll be able to type the specific JDBC URL in the Custom JDBC URL property. However, if you choose Use Custom JDBC URL = “False,” GeneXus will put together the JDBC URL, and do that the following properties will be enabled:

  • Database Name, so that the name of the database may be entered.
  • Server Name, so that the server's name or IP address may be entered.
  • Server TCP/IP Port, so that the port for connection with the DBMS is entered. We recommend using the default port for connection with each DBMS.

With these three properties, GeneXus will automatically put together the JDBC URL. In order to do that, it takes into account not only the value of these three properties but also the value selected in the JDBC Driver and DBMS Version properties.

For instance, for SQL Server, if the value of the JDBC Driver property is "jTDS Driver (Type 4)," GeneXus will put together the following URL:

jdbc:jtds:sqlserver://database_host:1433/database_name

If the value of the JDBC Driver were "Microsoft JDBC Driver (Type 4)," it would put together this other URL:

jdbc:sqlserver://database_host:1433;databaseName=database_name

Other sample JDBC URL strings

// mySQL
jdbc:mysql://hostname/databaseName
// Oracle
jdbc:oracle:thin:@hostname:portNumber:databaseName
// DB2
jdbc:db2:hostname:portNumber/databaseName

Notes

  • The URL generated depends on each DBMS version.
  • Modifying the Use Custom JDBC URL property depends on the value of the JDBC Driver property, which must be other than "Custom Driver."

How to apply changes

Build any object

Scope

Drivers: JDBC
DBMSs: SQL Server, Oracle, iSeries Native, DB2 Universal Database, Informix, PostgreSQL, MySQL

See Also

JDBC Driver Property
Database name property
Server Name Property
Server TCP/IP Port Property



Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant