Data Providers

Description - JLINK is a technology that can be used to access information hosted by iWay, WebFOCUS and EDA data servers. Listed below are the general settings for the JLINK in the base configuration of this server. The settings apply only for JLINK used in a stand-alone manner; they do not apply when JLINK is used via a data provider JDBC connection pool. In the JDBC case you must code these parameters as needed on the connection JRL.
 
Runtime Class - com.iwaysoftware.eclipse.template.JlinkProviderType


 

Parameter Groups

  Parameter Type Description
  Type string The server type is used to help identify the target JLINK accessible service.

Select from one of the following options:
  • iWay Adapter Manager {iWay Adapter Manager}
  • iWay Data Server {iWay Data Server}
  • WebFOCUS Pro Server {WebFOCUS Pro Server}
  • WebFOCUS DBMS Server {WebFOCUS DBMS Server}
  • WebFOCUS Reporting Server {WebFOCUS Reporting Server}
  • EDA Full Function Server {EDA Full Function Server}
  • EDA Hub Server {EDA Hub Server}
* - denotes required
  Parameter Type Description
  Host string The host parameter identifies the host name or the ip address of the target JLINK accessible service.
  Port string The port parameter identifies the TCP/IP service name or the port number of the target JLINK accessible service.
  User string User name with respect to the JLINK accessible service.
  Password password Password with respect to the JLINK accessible service.
  Extra string If the jlink-FFS connection requires additional properties, enter them as key1=value1;key2=value2 etc. Key=value pairs are separated by semicolon.
* - denotes required
  Parameter Type Description
  Engine string Identifies the default database engine style used by JLINK.

Select from one of the following options:
  • EDA {0}
  • DB2 {1}
  • ORACLE {2}
  • TERADATA {3}
  • SQLDS {4}
  • SHAREBASE {5}
  • SQLMSS {6}
  • SUPRA {7}
  • INGRES {8}
  • SYBASE {9}
  • RDB {10}
  • INFORMIX {11}
  • UNIFY {12}
  • SQLEDA {13}
  • OS2EE {14}
  • SQL400 {15}
  • NONSTOP {16}
  • ALLBASE {17}
  • PROGRESS {18}
  • REDBRICK {19}
  • UNIVERSE {20}
  • DATACOM {21}
  • INFOACC {22}
  • SQLIDMS {23}
  • STORHOUSE {24}
  • ODBC {25}
  • MSQ {26}
  • NUCLEUS {27}
  • MSACCESS {28}
  Encoding string Identifies the code page to be used with the JLINK Data provider.

Select from one of the following options:
  • U.S. English (Default) {137}
  • Western European (ISO 8859-1) {437}
  • Central European (ISO 8859-2) {1250}
  • Greek (ISO 8859-7) {1253}
  • Hebrew (ISO 8859-8) {916}
  • Japanese (Shift-JIS) {942}
  • Japanese (EUC-JP) {10942}
  • Korean {949}
  • Russian (ISO 8859-9) {1251}
  • Simplified Chinese (GBK) {946}
  • Traditional Chinese (Big5) {10948}
  • Turkish (ISO 8859-9) {1254}
  • Unicode (UTF-8) {65001}
  Encryption boolean Determines whether JLINK traffic should be encrypted over the wire.
* - denotes required
  Parameter Type Description
  Trace File string File name and location of the file on the server to store JLINK trace information.
  Trace Levels string Sets the trace levels of the JLINK Data provider.

Select from one of the following options:
  • api {api}
  • io {io}
  • logic {logic}
  • debug {debug}
* - denotes required


Description - A JDBC provider for managing database connections.
 
Runtime Class - com.iwaysoftware.eclipse.template.JdbcProviderType


 

Parameter Groups

  Parameter Type Description
* Driver Class string The JDBC driver class is the name of the class that contains the code for this JDBC Driver.

Select from one of the following options:
  • JDBC-ODBC Bridge {sun.jdbc.odbc.JdbcOdbcDriver}
  • Cloudscape {COM.cloudscape.core.JDBCDriver}
  • Cloudscape RMI {RmiJdbc.RJDriver}
  • IBM DB2 {COM.ibm.db2.jdbc.app.DB2Driver}
  • IBM DB2/400 {com.ibm.as400.access.AS400JDBCDriver}
  • IBM DB2 Type 4 {com.ibm.db2.jcc.DB2Driver}
  • Firebird (JCA/JDBC Driver) {org.firebirdsql.jdbc.FBDriver}
  • Hypersonic SQL (v1.2 and earlier) {hSql.hDriver}
  • Hypersonic SQL (v1.3 and later) {org.hsqldb.jdbcDriver}
  • IBI JLINK {ibi.jlink.EdaDriver}
  • IDS Server {ids.sql.IDSDriver}
  • Informix Dynamic Server {com.informix.jdbc.IfxDriver}
  • InstantDB (v3.13 and earlier) {jdbc.idbDriver}
  • InstantDB (v3.14 and later) {org.enhydra.instantdb.jdbc.idbDriver}
  • Interbase (InterClient Driver) {interbase.interclient.Driver}
  • MaxDB {com.sap.dbtech.jdbc.DriverSapDB}
  • Microsoft SQL Server (BEA Weblogic Driver) {weblogic.jdbc.mssqlserver4.Driver}
  • Microsoft SQL Server (JTurbo Driver) {com.ashna.jturbo.driver.Driver}
  • Microsoft SQL Server (Sprinta Driver) {com.inet.tds.TdsDriver}
  • Microsoft SQL Server 2005, 2008, 2012 (Microsoft Driver) {com.microsoft.sqlserver.jdbc.SQLServerDriver}
  • Microsoft SQL Server 2000 (Microsoft Driver) {com.microsoft.jdbc.sqlserver.SQLServerDriver}
  • Microsoft SQL Server 6.5,7,2000 (JTDS Open Source) {net.sourceforge.jtds.jdbc.Driver}
  • MySQL (MM.MySQL Driver) {org.gjt.mm.mysql.Driver}
  • Oracle OCI 8i {oracle.jdbc.driver.OracleDriver}
  • Oracle OCI 9i {oracle.jdbc.driver.OracleDriver}
  • Oracle Thin {oracle.jdbc.driver.OracleDriver}
  • PointBase Embedded Server {com.pointbase.jdbc.jdbcUniversalDriver}
  • PostgreSQL (v6.5 and earlier) {postgresql.Driver}
  • PostgreSQL (v7.0 and later) {org.postgresql.Driver}
  • Progress v9.x {com.progress.sql.jdbc.JdbcProgressDriver}
  • Progress v10.x and v11.x {com.ddtek.jdbc.openedge.OpenEdgeDriver}
  • Sybase (jConnect 4.2 and earlier) {com.sybase.jdbc.SybDriver}
  • Sybase (jConnect 5.2) {com.sybase.jdbc2.jdbc.SybDriver}
  • Sybase (jConnect 6.05) {com.sybase.jdbc3.jdbc.SybDriver}
* Connection URL string The JDBC connection URL to use when creating a connection to the target database. The URL generally includes the server name or IP address, the port or service, the data source name, and a driver specific prefix.

Select from one of the following options:
  • JDBC-ODBC Bridge {jdbc:odbc:[DB]}
  • Cloudscape {jdbc:cloudscape:[DB]}
  • Cloudscape RMI {jdbc:rmi://[HOST][:PORT]/jdbc:cloudscape:[DB]}
  • IBM DB2 {jdbc:db2://[HOST][:PORT]/[DB]}
  • IBM DB2/400 {jdbc:as400://[HOST][:PORT]/[DB];translate binary=true}
  • IBM DB2 Type 4 {jdbc:db2://[HOST][:PORT]/[DB]}
  • Firebird (JCA/JDBC Driver) {jdbc:firebirdsql:[//[HOST][:[PORT]/][DB]}
  • Hypersonic SQL (v1.2 and earlier) {jdbc:HypersonicSQL:[DB]}
  • Hypersonic SQL (v1.3 and later) {jdbc:hsqldb:file:[DB]}
  • IBI JLINK {jdbc:jlink://[HOST][:PORT][;server=[SERVER];user=[USER];password=[PASSWORD];trace=[n];cfg=[CONFIGFILE];engine=[n]]}
  • IDS Server {jdbc:ids://[HOST][:PORT]/conn?dsn='[ODBC_DSN_NAME]'}
  • Informix Dynamic Server {jdbc:informix-sqli://[HOST][:PORT]/[DB]:INFORMIXSERVER=[SERVER_NAME]}
  • InstantDB (v3.13 and earlier) {jdbc:idb:[DB]}
  • InstantDB (v3.14 and later) {jdbc:idb:[DB]}
  • Interbase (InterClient Driver) {jdbc:interbase://[HOST]/[DB]}
  • MaxDB {jdbc:sapdb://[HOST][:PORT]/[DB]}
  • Microsoft SQL Server (BEA Weblogic Driver) {jdbc:weblogic:mssqlserver4:[DB]@[HOST][:PORT]}
  • Microsoft SQL Server (JTurbo Driver) {csm.pg.servdpjd.driver.msqljt.url}
  • Microsoft SQL Server (Sprinta Driver) {jdbc:inetdae:[HOST][:PORT]?database=[DB]}
  • Microsoft SQL Server 2005, 2008, 2012 (Microsoft Driver) {jdbc:sqlserver://[HOST][INSTANCE][:PORT][;databaseName=[DB]}
  • Microsoft SQL Server 2000 (Microsoft Driver) {jdbc:microsoft:sqlserver://[HOST][:PORT][;DatabaseName=[DB]}
  • Microsoft SQL Server 6.5,7,2000 (JTDS Open Source) {jdbc:jtds:sqlserver://[HOST][:PORT][;DatabaseName=[DBNAME]}
  • MySQL (MM.MySQL Driver) {jdbc:mysql://[HOST][:PORT]/[DB]}
  • Oracle OCI 8i {jdbc:oracle:oci8:@[SID]}
  • Oracle OCI 9i {jdbc:oracle:oci:@[SID]}
  • Oracle Thin {jdbc:oracle:thin:@[HOST][:PORT]:[SID]}
  • PointBase Embedded Servers {jdbc:pointbase://embedded[:PORT]/[DB]}
  • PostgreSQL (v6.5 and earlier) {jdbc:postgresql://[HOST][:PORT]/[DB]}
  • PostgreSQL (v7.0 and later) {jdbc:postgresql://[HOST][:PORT]/[DB]}
  • Progress v9.x {jdbc:jdbcprogress:T:[HOST]:[PORT]:[DB]}
  • Progress v10.x and v11.x {jdbc:datadirect:openedge://[HOST]:[PORT];databaseName=[DB]}
  • Sybase (jConnect 4.2 and earlier) {jdbc:sybase:Tds:[HOST][:PORT]}
  • Sybase (jConnect 5.2) {com.sybase.jdbc2.jdbc.SybDriver}
  • Sybase (jConnect 6.05) {jdbc:sybase:Tds:[HOST][:PORT]}
  User string User name with respect to the JDBC URL and driver.
  Password password Password with respect to the JDBC URL and driver.
* - denotes required
  Parameter Type Description
* Initial Pool Size integer Number of connections to place in the pool at startup.
* Maximum Number of Idle Connections integer Maximum number of idle connections to retain in the pool. 0 means no limit except what is enforced by the maximum number of connections available from the pool.
* Maximum Number of Connections integer Maximum number of connections available from the pool. 0 means no limit. Connections above the Idle Connections limit are not retained in the pool.
  Login Timeout integer Time in seconds to wait for a pooled connection before throwing an exception. 0 means wait forever.
  Behavior When Exhausted string What to do when the pool reaches the maximum number of connections. BLOCK means wait for a connection to become available for the period defined by the login timeout parameter. FAIL means throw an exception immediately.

Select from one of the following options:
  • block {block}
  • fail {fail}
  Cache Prepares boolean Should the provider cache prepared statements? Set this to false if your application generates a large number of prepared or callable statements that are not reused.
* - denotes required
  Parameter Type Description
  Eviction Interval integer Time between runs of the idle connection eviction thread, in seconds. 0 or a negative value means the eviction thread will never run.
  Idle Connection Timeout integer The minimum amount of time a connection can remain idle in the pool before the eviction thread disposes of it. When the eviction thread runs, if it finds that a connection has been idle for at least this interval, the connection will be removed from the pool and closed. 0 or a negative value means the idle connection can remain in the pool indefinitely. Note that a connection can remain in the pool longer than the timeout, depending on the scheduling of the eviction interval.
  Maximum Eviction Tests Per Run integer This is a performance tuning option. Since the eviction thread must lock the pool when it runs, this option allows the user to specify how many connections can be tested in each run, thus limiting the duration of the lock. If the eviction interval is short or the number of connections in the pool is large, performance may improve with fewer connections tested per run. Enter 0 to test all idle connections.
* - denotes required
  Parameter Type Description
  Validation SQL string SQL statement that can be executed to validate the health of a pooled connection. The statement should return a result set of at least one row.
  Validate on Borrow boolean If true, the validation SQL statement will be executed on a pooled connection before returning the connection to the caller.
  Validate on Return boolean If true, the validation SQL statement will be executed on a pooled connection before replacing the connection in the pool.
  Validate Idle boolean If true, the eviction thread will execute the validation SQL statement on connections that have not reached the idle connection timeout. If the statement does not execute successfully, the connection will be dropped from the pool.
* - denotes required


Subscribe to Data Providers