JDBC Connection URL Formats
Loftware Enterprise™ SP supports data service connections to many common types of databases. The format for the connection string for several types of databases is shown. For more information about the format for the connection string, refer to your database software documentation.
Important! Java Database Connectivity (JDBC) API drivers for Oracle 19c, PostgreSQL 14.4 to 15 for Linux, and PostgreSQL 14.4 to 15 for Windows Server, are installed with Loftware Enterprise SP. To enable Loftware Enterprise SP to connect to another type of database, you must install a third-party JDBC API driver on the computer where Loftware Enterprise SP is installed. For more information, see Add a JDBC Driver.
The following are supported database types and the JDBC Connection URL format for each.
PostgreSQL:
jdbc:postgresql://<Host_or_IPaddress>:<port>/<DatabaseName>
jdbc:postgresql://MyServer.MyDomain.com:5432/loftstore
Amazon RDS for PostgreSQL:
jdbc:postgresql://<FQDNendpoint>:<port>/<DatabaseName>
jdbc:postgresql://example.abc123xyz789.us-east-2.rds.amazonaws.com:5432/loftstore
Oracle with SID:
jdbc:oracle:thin:@<Host_or_IPaddress>:<port>:<SID>
jdbc:oracle:thin:@MyServer.MyDomain.com:1521:orcl
Oracle with Service Name:
jdbc:oracle:thin:@<Host_or_IPaddress>:<port>/<ServiceName>
jdbc:oracle:thin:@MyHostName:1521/orcl.example.com
Amazon RDS for Oracle:
jdbc:oracle:thin:@<FQDNendpoint>:<port>:<SID>
jdbc:oracle:thin:@example.abc123xyz789.us-east-2.rds.amazonaws.com:1521:orcl
The following database types are also supported, but you must obtain a JDBC driver for them.
- SQL Server: jdbc:sqlserver://<ServerName_or_IPAddress>:<port>;databaseName=<sid>
- MySQL: jdbc:mysql://<ServerName_or_IPAddress>:3306/<DatabaseName>
- Loftware-supplied embedded database: !LOCAL!
Note: The
more