Connection - URL attribute

Connection - URL attribute

URL

URL is a mandatory attribute of a connection and is also known as the connection string

It's a string that defines the most important connection properties such as:

  • the scheme: the technology used to connect
  • the host: the host where the system is located
  • the port: the port where the system is reachable on the host
  • the database: the database name

The URL is system dependent and therefore should be looked in the documentation page of each system.

This is the property that defines the connection to a system

The URL is also known as:

Example

Example of URL with with the tabli connection list command where you can see the howtos connection.

tabli connection list
Name            Url                                                                       
-------------   -----------------------------------------------------------------------   
cd              file:///C:/Users/gerardnico/                                              
entity          file:///D:/code/bytle-mono/db-gen-entities/src/main/resources/entity/     
howto           file:///D:/code/bytle-mono/db-website/src/doc/howto/                      
memory          mem                                                                       
mysql           jdbc:mysql://[host]:[port]/[database]                                     
oracle          jdbc:oracle:thin:@localhost:1521:xe                                       
postgres        jdbc:postgresql://localhost:5432/postgres                                 
sqlite          jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite.db          
sqlite_target   jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite_target.db   
sqlserver       jdbc:sqlserver://localhost;databaseName=AdventureWorks;                   
temp            file:///C:/Users/GERARD~1/AppData/Local/Temp/                             
tpcds           tpcds                                                                     
tpcds_query     file:///D:/code/bytle-mono/db-jdbc/src/main/sql/tpcds/
Powered by ComboStrap