...
| Platform | Connection String |
|---|---|
Oracle (< 12c): | jdbc:oracle:thin:@hostname:1521:phixflow |
| Oracle (> 12c with PDB containers): | jdbc:oracle:thin:@hostname:1521/phixflow |
Sql Server: | jdbc:sqlserver://hostname\myservice;databaseName=phixflow |
MySQL: | jdbc:mysql://hostname/phixflow |
...
hostname | The name of the host which supports the database. If the database is on the same host as the Tomcat web server, user localhost |
phixflow | The name of the database. |
Oracle specific considerations
Please note that for Oracle, the only difference between the connection strings is to use a '/' instead of':' before [SID], so that [SID] is treated as a SERVICE name rather than an SID. This is due to Oracle 12c introducing pluggable databases (PDB's).
...
. |
...
Introduction to the Multitenant Architecture (including an explanation of PDB's)
...