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