Networkingflags: g

JDBC Connection URL

Match JDBC connection URLs in the standard `jdbc:driver://host[:port][/database]` form.

Try it in RegexPro →

Available in

JSSupported

JavaScript / ECMAScript

Browser-native RegExp. Default if you don't pick.

PYSupported

Python (re)

CPython stdlib `re`. Unicode-aware `\w` and `\d` by default.

GOSupported

Go (RE2)

Linear-time matching. No backreferences or lookarounds.

Pattern

regexengine-agnostic
jdbc:[a-z0-9]+:\/\/[^\/?\s]+(?:\/[\w\-]+)?(?:\?\S*)?   (flags: g)

Raw source: jdbc:[a-z0-9]+:\/\/[^\/?\s]+(?:\/[\w\-]+)?(?:\?\S*)?

How it works

jdbc: matches the literal scheme prefix. [a-z0-9]+ captures the driver name (mysql, postgresql, oracle, sqlserver, h2, etc.). :\/\/ matches the separator. [^\/?\s]+ captures the host[:port]. (?:\/[\w\-]+)? optionally matches a database name. (?:\?\S*)? optionally matches query parameters.

Examples

Input

url=jdbc:postgresql://db.internal:5432/main

Matches

  • jdbc:postgresql://db.internal:5432/main

Input

jdbc:mysql://localhost:3306/test?useSSL=false

Matches

  • jdbc:mysql://localhost:3306/test?useSSL=false

Input

no jdbc url here

No match

—

Common use cases

  • •Java / JVM application config validation
  • •Spring Boot properties auditing
  • •Migrating between database drivers
  • •Detecting committed credentials in JDBC URLs

Related patterns

Generic Connection String (URL Form)

Networking

Parse generic URL-form connection strings: `protocol://[user[:pass]@]host[:port][/database]`.

Redis Connection URL

Networking

Match Redis connection URLs in both `redis://` and `rediss://` (TLS) forms, capturing user, password, host, port, and DB index.

FTP URL

Networking

Match FTP and FTPS URLs, capturing optional credentials, host, port, and path.

MongoDB Connection URI

Networking

Match MongoDB connection URIs in both standard `mongodb://` and SRV `mongodb+srv://` formats.

←PreviousCookie Header Value
All patterns
NextCron Expression (Quartz/Spring, 6-Field)→