...
These are the URL formats for the database platforms that PhixFlow currently supports.
Platform | Connection String |
---|---|
Oracle |
|
|
Oracle (> 12c with PDB containers) |
1 |
|
Microsoft SQL Server |
|
MariaDB | jdbc: |
mariadb://hostname/phixflow |
NotesWhere:
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
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
1For Oracle 12c and above, if you are using PDB (pluggable database) containers, you should use a '/' instead of ':' before [SID], so that [SID] is treated as a SERVICE name rather than an SID. |
...
There is also |
...
an option to add the line |
...
. This allows you to treat SID's as service names by default. This is provided by Oracle as a workaround for users who have hard-coded connection strings that are difficult to change by hand, and so should not be necessary for |
...
PhixFlow configuration. For more information, |
...
see the following |
...
Oracle documentation links: Introduction to the Multitenant Architecture (including an explanation of PDB's) |
...
Note |
---|
PhixFlow does not support Oracle's MySQL. If you choose to use it anyway, the database URL would be |