regex101: JDBC Oracle syntax for EZCONNECT

^start of line

jdbc:oracle:thin:the literal text jdbc:oracle:thin: (case sensitive)

Group 1((?P<username>[a-zA-Z0-9]{1,})([\/](?P<password>[a-zA-Z0-9]{1,})){0,1}){0,1}

{0,1}repeats the group contents below at most once:

Group username(?P<username>[a-zA-Z0-9]{1,})

Character Class[a-zA-Z0-9]{1,}

{1,}matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Group 3([\/](?P<password>[a-zA-Z0-9]{1,})){0,1}

{0,1}repeats the group contents below at most once:

Character Class[\/]

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Group password(?P<password>[a-zA-Z0-9]{1,})

Character Class[a-zA-Z0-9]{1,}

{1,}matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

@the literal @ (64₁₀ / 100₈ / 40₁₆)

Group ezdb_name(?P<ezdb_name>((\/\/){0,1}(?P<hostname>[a-zA-Z0-9\.\-]{1,})(\:(?P<port>\d+)){0,1})(\/(?P<service_name>[a-zA-Z\.\-0-9]{1,}(\:(?P<server_type>[a-zA-Z]{1,})){0,1}){0,1}(\/(?P<instance_name>[a-zA-Z0-9]{1,})){0,1}){0,1})

Group 6((\/\/){0,1}(?P<hostname>[a-zA-Z0-9\.\-]{1,})(\:(?P<port>\d+)){0,1})

Group 7(\/\/){0,1}

{0,1}repeats the group contents below at most once:

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Group hostname(?P<hostname>[a-zA-Z0-9\.\-]{1,})

Character Class[a-zA-Z0-9\.\-]{1,}

{1,}matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

Group 9(\:(?P<port>\d+)){0,1}

{0,1}repeats the group contents below at most once:

\:the literal : (58₁₀ / 72₈ / 3A₁₆)

Group port(?P<port>\d+)

\d+a Unicode decimal digit, repeated at least once

Group 11(\/(?P<service_name>[a-zA-Z\.\-0-9]{1,}(\:(?P<server_type>[a-zA-Z]{1,})){0,1}){0,1}(\/(?P<instance_name>[a-zA-Z0-9]{1,})){0,1}){0,1}

{0,1}repeats the group contents below at most once:

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Group service_name(?P<service_name>[a-zA-Z\.\-0-9]{1,}(\:(?P<server_type>[a-zA-Z]{1,})){0,1}){0,1}

{0,1}repeats the group contents below at most once:

Character Class[a-zA-Z\.\-0-9]{1,}

{1,}matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Group 13(\:(?P<server_type>[a-zA-Z]{1,})){0,1}

{0,1}repeats the group contents below at most once:

\:the literal : (58₁₀ / 72₈ / 3A₁₆)

Group server_type(?P<server_type>[a-zA-Z]{1,})

Character Class[a-zA-Z]{1,}

{1,}matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

Group 15(\/(?P<instance_name>[a-zA-Z0-9]{1,})){0,1}

{0,1}repeats the group contents below at most once:

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Group instance_name(?P<instance_name>[a-zA-Z0-9]{1,})

Character Class[a-zA-Z0-9]{1,}

{1,}matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

^jdbc:oracle:thin:((?P<username>[a-zA-Z0-9]{1,})([\/](?P<password>[a-zA-Z0-9]{1,})){0,1}){0,1}@(?P<ezdb_name>((\/\/){0,1}(?P<hostname>[a-zA-Z0-9\.\-]{1,})(\:(?P<port>\d+)){0,1})(\/(?P<service_name>[a-zA-Z\.\-0-9]{1,}(\:(?P<server_type>[a-zA-Z]{1,})){0,1}){0,1}(\/(?P<instance_name>[a-zA-Z0-9]{1,})){0,1}){0,1})$

New

jdbc:oracle:thin:@//hostname.example.ru:1521/database.example.ru
jdbc:oracle:thin:@sales-server
jdbc:oracle:thin:@sales-server:3456
jdbc:oracle:thin:@sales-server/sales
jdbc:oracle:thin:@sales-server:80/sales
jdbc:oracle:thin:@sales-server/sales:dedicated/inst1
jdbc:oracle:thin:@sales-server//inst1
jdbc:oracle:thin:@sales-server:1521/sales.us.acme.com
jdbc:oracle:thin:@//sales-server/sales.us.acme.com
jdbc:oracle:thin:@//sales-server.us.acme.com/sales.us.oracle.com
jdbc:oracle:thin:wat@//sales-server.us.acme.com/sales.us.oracle.com
jdbc:oracle:thin:wat/wat@//sales-server.us.acme.com/sales.us.oracle.com
jdbc:oracle:thin:wat/wat@//sales-server.us.acme.com/sales.us.oracle.com:dedicated/instance
jdbc:oracle:thin:wat/wat@//sales-server.us.acme.com//instance
jdbc:oracle:thin:@hostname:1521:DATABASE

Regular Expressions 101

Regular Expression

Substitution