Connection parameters examples

PostgreSQL

host	db-host
port	5432
database	test
user	postgres
password	test
SQL test	`select * from test`

MySQL

host	db-host:3306
database	test
user	root
password	test
SQL test	`select * from test`

User account and accessed database must have the remote access enabled.

How Do I Grant Access To An Existing Database?

Let us assume that you are always making connection from remote IP called 202.54.10.20 for database called webdb for user webadmin, To grant access to this IP address type the following command At mysql> prompt for existing database, enter:
mysql> update db set Host='202.54.10.20' where Db='webdb';
mysql> update user set Host='202.54.10.20' where user='webadmin';

Oracle

host	db-host
port	1521
driver	V14_10_2_0_1
user	tester
password	test
SID	XE
SQL test	`select * from test`

MS SQL

host	db-host
port	1433
user	sa
password	test
database	test
SQL test	`select * from test`

SQL Server Authentication must be enabled.

You need an SQL account to access the MS SQL remotely.

Sybase SQL Anywhere 11

host	db-host
port	2638
user	dba
password	sql
database	demo
SQL test	`select * from products`

If you see error "JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation." then you have to allow the Sybase jConnect JDBC driver to access system catalog information. Please execute SQL query "ALTER DATABASE Upgrade JCONNECT ON" and see documentation for more details.

Some Sybase installations does not have metadata support initialized. In this case, it is necessary to initialize the metadata by calling the stored procedure or set the use_metadata connection parameter to false. Read more here.

Browse all JDBC parameters

Teradata 13

host	db-host
user	dbc
password	test
SQL test	`select * dbc.tables`

Visit Teradata documentation for additional parameters https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABJIHBJ

Page tree