본문 바로가기

OS&TOOL/eclipse

이클립스 데이터베이스 설정

  • DB2
    o Driver Class: COM.ibm.db2.jdbc.app.DB2Driver
    o Connection URL: jdbc:db2:<database>
    o Driver .jar/.zip: db2java.zip
  • Sybase
    o Driver Class: com.sybase.jdbc2.jdbc.SybDriver
    o Connection URL: jdbc:sybase:Tds:<host>:<port>/<database>
    o Driver .jar/.zip: jconn2.jar
  • Oracle
    o Driver Class: oracle.jdbc.driver.OracleDriver
    o Connection URL: jdbc:oracle:thin:@ <host>:<port>:<sid>
    o Driver .jar/.zip: classes12.zip
  • SQLServer
    o Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
    o Connection URL: jdbc:microsoft:sqlserver://localhost:1433
    o Driver .jar/.zip: mssqlserver.jar, msbase.jar, msutil.jar
  • PostgreSQL
    o Driver Class: org.postgresql.Driver
    o Connection URL: jdbc:postgresql://<server>:<port>/<database>
    o Driver .jar/.zip: postgresql.jar