* |
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. |