Provider - Data Provider - JDBC

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