Versions Compared

Key

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

A database URL is used to specify a database instance to connect to, and is used in the phixflow-datasource.xml file. It includes the type of database, the host it is running on, and (generally) a database instance on the host.

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):

jdbc:oracle:thin:@hostname:1521/phixflow

Sql Server:

jdbc:sqlserver://hostname\myservice;databaseName=phixflow

MySQL:

jdbc:mysql://hostname/phixflow

Notes:

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

There is also the option to add the configuration line 'USE_SID_AS_SERVICE_listener=on' to the tnsnames.ora file in order 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, please see:
USE_SID_AS_SERVICE_listener


Introduction to the Multitenant Architecture (including an explanation of PDB's)