Guest User

Untitled

a guest
Nov 9th, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.94 KB | None | 0 0
  1. Microsoft SQL Server
  2.  
  3. Microsoft SQL Server JDBC Driver (一般用来连接 SQLServer 2000)
  4.  
  5. 驱动程序包名:msbase.jar mssqlserver.jar msutil.jar
  6. 驱动程序类名: com.microsoft.jdbc.sqlserver.SQLServerDriver
  7. JDBC URL: jdbc:microsoft:sqlserver://<server_name>:<port>
  8. 默认端口1433,如果服务器使用默认端口则port可以省略
  9. Microsoft SQL Server 2005 JDBC Driver
  10.  
  11. 驱动程序包名:sqljdbc.jar
  12. 驱动程序类名: com.microsoft.sqlserver.jdbc.SQLServerDriver
  13. JDBC URL: jdbc:sqlserver://<server_name>:<port>
  14. 默认端口1433,如果服务器使用默认端口则port可以省略
  15. Oracle
  16.  
  17. Oracle Thin JDBC Driver
  18.  
  19. 驱动程序包名:ojdbc14.jar
  20. 驱动程序类名: oracle.jdbc.driver.OracleDriver
  21. JDBC URL:
  22. jdbc:oracle:thin:@//<host>:<port>/ServiceName
  23. jdbc:oracle:thin:@<host>:<port>:<SID>
  24. IBM DB2
  25.  
  26. IBM DB2 Universal Driver Type 4
  27.  
  28. 驱动程序包名:db2jcc.jar db2jcc_license_cu.jar
  29. 驱动程序类名: com.ibm.db2.jcc.DB2Driver
  30. JDBC URL: jdbc:db2://<host>[:<port>]/<database_name>
  31. IBM DB2 Universal Driver Type 2
  32.  
  33. 驱动程序包名:db2jcc.jar db2jcc_license_cu.jar
  34. 驱动程序类名: com.ibm.db2.jcc.DB2Driver
  35. JDBC URL: jdbc:db2:<database_name>
  36. MySQL
  37.  
  38. MySQL Connector/J Driver
  39.  
  40. 驱动程序包名:mysql-connector-java-x.x.xx-bin.jar
  41. 驱动程序类名: com.mysql.jdbc.Driver
  42. JDBC URL: jdbc:mysql://<host>:<port>/<database_name>
  43. 默认端口3306,如果服务器使用默认端口则port可以省略
  44. MySQL Connector/J Driver 允许在URL中添加额外的连接属性jdbc:mysql://<host>:<port>/<database_name>?property1=value1&property2=value2
  45. Informix
  46.  
  47. Informix JDBC Driver
  48.  
  49. 驱动程序包名:ifxjdbc.jar
  50. 驱动程序类名: com.informix.jdbc.IfxDriver
  51. JDBC URL: jdbc:informix-sqli://{<ip-address>|<host-name>}:<port-number>[/<dbname>]: INFORMIXSERVER=<server-name>
  52. Sybase
  53.  
  54. Sybase Adaptive Server Enterprise JDBC Driver
  55.  
  56. 驱动程序包名:jconn2.jar 或jconn3.jar
  57. 驱动程序类名: com.sybase.jdbc2.jdbc.SybDriver (com.sybase.jdbc3.jdbc.SybDriver)
  58. JDBC URL: jdbc:sybase:Tds:<host>:<port>默认端口5000
  59. Sybase Adaptive Server Anywhere or Sybase IQ JDBC Driver
  60.  
  61. 驱动程序包名:jconn2.jar 或jconn3.jar
  62. 驱动程序类名: com.sybase.jdbc2.jdbc.SybDriver (com.sybase.jdbc3.jdbc.SybDriver)
  63. JDBC URL: jdbc:sybase:Tds:<host>:<port>?ServiceName=<database_name>
  64. 默认端口2638
  65. PostgreSQL
  66.  
  67. PostgreSQL Native JDBC Driver
  68.  
  69. 驱动程序包名:驱动程序类名: org.postgresql.Driver
  70. JDBC URL: jdbc:postgresql://<host>:<port>/<database_name>
  71. 默认端口5432
  72. Teradata
  73.  
  74. Teradata Driver for the JDBC Interface
  75.  
  76. 驱动程序包名:terajdbc4.jar tdgssjava.jar gui.jar
  77. 驱动程序类名: com.ncr.teradata.TeraDriver
  78. JDBC URL:
  79. Type 4: jdbc:teradata://DatabaseServerName/Param1,Param2,...
  80. Type 3: jdbc:teradata://GatewayServerName:PortNumber
  81. /DatabaseServerName/Param1,Param2,...
  82. Netezza
  83.  
  84. Netezza JDBC Driver
  85.  
  86.  
  87. 驱动程序包名:terajdbc4.jar tdgssjava.jar gui.jar
  88. 驱动程序类名: org.netezza.Driver
  89. JDBC URL: jdbc:netezza://<host>:<port>/<database_name>
Add Comment
Please, Sign In to add comment