Connection.JDBC Details

Element Details: Connection.JDBC

Available in: Logi Info

Source code name: Connection.JDBC

The Connection.JDBC element sets the parameters required to connect to a JDBC data source. Enter a JDBC connection string into the Connection String attribute.

Only available in the Java version.

Example for SQL Server:
JdbcDriverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver;JdbcURL=jdbc:sqlserver://myserver:1433;
databasename=Northwind;user=sa;password=pass;selectMethod=cursor

Examples for Oracle:
JdbcDriverClassName=oracle.jdbc.OracleDriver;JdbcURL=Jdbc:oracle:thin:@myServer:1521:myDatabase;
user=scott;password=tiger

JdbcDriverClassName=oracle.jdbc.driver.OracleDriver;JdbcURL=jdbc:oracle:thin:myusername/mypassword@//myserver:1521/myDatabase.

Example for PostgreSQL:
JdbcDriverClassName=org.postgresql.Driver;JdbcURL=jdbc:postgresql://myserver:5029/mydatabase?user=myusername&password=mypassword

Example for Vertica:
JdbcDriverClassName=com.vertica.jdbc.Driver;JdbcURL=jdbc:vertica://myserver:5433/myDatabase?user=myusername&password=mypassword

Element Group:General Purpose Data Connectors

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

CommandTimeOut

UserDefined

The CommandTimeOut attribute specifies the amount of time, in seconds, before the request to connect to the data source is presumed to have failed. For most data sources, the default value is 60 seconds. For MySql, the default is 30 seconds.

ConnectionString

UserDefined

The ConnectionString attribute specifies a connection argument that properly identifies the service, server, database, user, and password necessary to establish a connection to a data source. Each service type will generally require a different ConnectionString syntax. For example, to connect to the Employees SQL Server database on a server named Server1 with administrator rights, the ConnectionString attribute value might be:'DRIVER={SQL SERVER};SERVER=Server1;DATABASE=Employees; UID=Admin;PWD=AdminPwd;'

UserDefined

The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

SqlSyntax

Vertica

SqlServer

Redshift

PostgreSQL

Oracle

MySql

DB2

SqlSyntax specifies the type of database server. The value is used by ActiveSQL DataLayers which must know the database type to generate correct SQL statements. Studio's QueryBuilder also uses SqlSyntax for ODBC connections.

PARENT ELEMENTS

Click element to drill down for more information.

Connections

CHILD ELEMENTS

Click element to drill down for more information.

Metadata

Studio Connection