JDBC driver connection string大全，
| Database / data source | URL format / driver name | Value | Default port |
| MySQL | URL format: | jdbc:mysql://<HOST>:<PORT>/<DATABASE_NAME> | 3306 |
| Driver name: | com.mysql.jdbc.Driver | ||
| Microsoft SQL Server | URL format: | jdbc:microsoft:sqlserver://<HOST>:<PORT>;databaseName= <DATABASE_NAME>;SelectMethod=<SELECT_MODE> | 1433 |
| Driver name: | com.microsoft.jdbc.sqlserver.SQLServerDriver | ||
| Oracle (thin), 9i, and 10g | URL format: | jdbc:oracle:thin@<HOST>:<PORT>:<DATABASE_NAME> | |
| Driver name: | oracle.jdbc.driver.OracleDriver | ||
| Oracle type2 (OCI) 9i, and 10g | URL format: | jdbc:oracle:oci:@<DATABASE_NAME> | |
| Driver name: | oracle.jdbc.OracleDriver | ||
| Virtual View Manager | URL format: | jdbc:cognos:dbapi@<HOST>:<PORT>?domain= <DOMAIN>&dataSource=<DATABASE_NAME>Normally this is the only JDBC client connection used to establish client-server connections to Virtual View Manager, where cognos is the default <DOMAIN> value unless an LDAP or dynamic domain user is negotiating the connection. | |
| Driver name: | cs.jdbc.driver.CompositeDriver | ||
| DataDirect Mainframe | URL format: | jdbc:neon:; APNA=<APP_NAME>; CPFX=<CATALOG_PREFIX>; DBTY=<DBMS_TYPE>; HOST=<HOST>; PORT=<PORT>; SUBSYS=<DATABASE_NAME>; TRLT=NO; DTFM=ODBC; | |
| Driver name: | com.neon.jdbc.Driver | ||
| Driver name: | COM.ibm.db2.jdbc.net.DB2Driver | ||
| DB2® v8 (type_2) | URL format: | jdbc:db2:<DATABASE_NAME> | |
| Driver name: | Driver Name: | ||
| DB2 v8 (type_4) | URL format: | jdbc:db2://<HOST>:<PORT>/<DATABASE_NAME> | |
| Driver name: | com.ibm.db2.jcc.DB2Driver | ||
| DB2 z/os v8 (type_4) mainframe | URL format: | jdbc:db2://<HOST>:<PORT>/<DATABASE_NAME> | |
| Driver name: | com.ibm.db2.jcc.DB2Driver | ||
| IBM Informix® | URL format: | jdbc:informix-sqli://<HOST>:<PORT>/<DATABASE_NAME>: informixserver=<IBM Informix instance name>;user=<user_name>; password=<password> | |
| The informixserver variable is the name of the IBM Informix instance, and not the server host name, and <user_name> and <password> are recognized by the IBM Informix server. | |||
| Driver name: | com.informix.jdbc.IfxDriver | ||
| Netezza® | URL format: | jdbc:netezza://<HOST>:<PORT>/<DATABASE_NAME> | 5480 |
| Driver name: | org.netezza.Driver | ||
| Sybase | URL format: | jdbc:sybase:Tds:<HOST>:<PORT>/<DATABASE_NAME> | |
| Driver name: | com.sybase.jdbc3.jdbc.SybDriver | ||
| Teradata | URL format: | jdbc:teradata://<HOST>/DBS_PORT=<PORT>/DATABASE= <DATABASE_NAME>/CHARSET=UTF8,COMPAT_DBS=true | |
| Driver name: | com.ncr.teradata.TeraDriver |
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。