JDBC : Referensi Daftar Connection String

posted Sep 20, 2011, 2:52 AM by Editor KursusInternet   [ updated Sep 24, 2011, 8:24 PM ]
Berikut adalah daftar-daftar konfigurasi untuk melakukan koneksi ke berbagai database melalui JDBC :
  • MySQL

    • Driver Class Name : com.mysql.jdbc.Driver
    • Connection URL : jdbc:mysql://[HOST]/[DATABASE]?user=[USERNAME]&password=[PASSWORD]
    • Default port number : 3306
  • SQL Server (JTDS)

      • Driver Class Name : net.sourceforge.jtds.jdbc.Driver
      • Connection URL : jdbc:jtds:sqlserver://[HOST]/[DATABASE];user=[USERNAME];password=[PASSWORD]
      • Default port number : 1433
    • Oracle

      • Driver Class Name : oracle.jdbc.OracleDriver
      • Connection URL : jdbc:oracle:thin:@HOST:PORT:SID
      • Default port number : 1521
    • Sybase

      • Driver Class Name : oracle.jdbc.OracleDriver
      • Connection URL : jdbc:sybase:Tds:[HOST]:[PORT]/[DATABASE]
      • Default port number :
    • POSTGRESQL

      • Driver Class Name : org.postgresql.Driver
      • Connection URL : jdbc:postgresql://[HOST]:[PORT]/[DBNAME]
      • Default port number : 5432
    • HSQLDB

      • Driver Class Name : org.hsqldb.jdbcDriver
      • Connection URL : jdbc:hsqldb:hsql://[HOST]:[PORT]/[DBNAME]
      • Default port number : 9001

    Sumber Referensi


    Comments