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. 

PlatformConnection String

Oracle

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

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.