Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These are the URL formats for the database platforms that PhixFlow currently supports. Please see Oracle  

PlatformConnection 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).

...

.

...