各种数据库jdbc驱动程序及相关的连接方式

《各种数据库jdbc驱动程序及相关的连接方式》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、OracleOracle10.2.0.1.0OracleJDBCDriver10.2.O」.O(DownloadDriver)Files:ojdbcl4.jarDriverClass:oracle.jdbe.OracleDriverURL:jdbc:oracle:thin:@host:portl521:sidjdbc:oracle:oci:@host:portl521:sid•ImportantNotes:Itisgenerallyrecommendedthatyouusethelatestversionofthedriverbasedonthatitissupportedby

2、theversionofJavayouareusing•ItisthesamedriverfileusedforboththinandOCIconnectionsLinks:?OracleJDBCFAQDB2onWindows/LinuxDB28.2IBMDB2JDBCUniversalDriver2.8.46(DownloadDriver)Files:db2jcc.jardb2jcclicensecu.jarDriverClass:com.ibm.db2.jcc.DB2DriverURL:jdbc:db2://host:port50000/databaseInstallati

3、onNotes:Onceyouhavesavedthezipfilethenunzipitandloadthedb2jccejaranddb2jcc_license_cu>jarfileslistedaboveinthedrivermanagerUsefulInfo:retrieveMessagesFromServerOnGetMessagecanbeveryusefultoset.ItspurposeistotelltheJDBCdrivertopresentinformativemessagesintheSQLCommanderinsteadofanonymouscodes

4、.Addittothedriverpropertieslistfortheactualdatabaseconnection.Setthevaluetotrue.SQLServerSQLServer20008.00.2039SQLServer200509・00・1399OnlyforSQLServer2000:SQLServerDriver2.2.0040(DownloadDriver)Files:mssqlserver.jarmsbase.jarmsutiLjarDriverClass:com.microsoft.jdbc.sqlserver.SQLServerDriverUR

5、L:jdbc:microsoft:sqlserver://:;DatabaseName=InstallationNotes:SeeinstallationnotesindriverdownloadpageSQLServerDriverl.0.809」02(DownloadDriver)Files:sqljdbc.jarDriverClass:com.microsoft.sqlserver.jdbCeSQLServerDriverURL:jdbc:sqlserver://[:];databaseName=InstallationNotes:Seeinstallationnotes

6、indriverdownloadpagejTDS1.2(DownloadDriver)Files:jtds-1.2jarDriverClass:net.sourceforge.jtdsjdbc.DriverURL:jdbc:jtds:://[:][/]InstallationNotes:Downloadthejtds-1.2-dist.zipfile,unpackitandloadthejtds-1.2.jarinthedrivermanagerorintheconnectionwizard.SybaseASESybaseASEjConnect6.05EBF13044(Down

7、loadDriver)Files:jconn3jar12.5.3DriveSybaseASE15rcom.sybase.jdbc3.jdbc.SybDriverClass:URL:jdbc:sybase:Tds::/InstallationNotes:DownloadandunzipthejConnect-6_05.zipfile,loadtheclasses/jconn3