In previous post you learn about JDBC: Drivers Types and Uses. Here are JDBC supported database drivers and connection URL format. You can also check corresponding examples for more detail on it.
| Relational Database | Driver Name | Database URL & Example |
| Oracle | com.oracle.jdbc.Driver | jdbc:oracle:thin:@<server> :<port>:<databaseName> Eg: jdbc:oracle:thin:@localhost :1521:xe |
| MySQL | com.mysql.jdbc.Driver | jdbc:mysql://<server> :<port>/<databaseName> Eg: jdbc:mysql://localhost :3306/myDBName |
| IBM DB2 App | com.ibm.db2.jdbc.app.DB2Driver | jdbc:db2:<databaseName> Eg: jdbc:db2:FacingIssuesOnITDb |
| IBM DB2 Net | com.ibm.db2.jdbc.net.DB2Driver | jdbc:db2//<server> :<port>/<databasebName> Eg: jdbc:db2://localhost:6789/FacingIssuesOnITDb |
| Sybase | com.sybase.jdbc.SybDriver | jdbc:sybase:Tds:<server> :<port>/<databaseName> Eg:jdbc:sybase:Tds:localhost :4100/FacingIssuesOnITDb |
| Microsoft SQL Server | com.microsoft.sqlserver .jdbc.SQLServerDriver | jdbc:sqlserver://<server> :<port>/databaseName=<databaseName> Eg:jdbc:sqlserver://localhost :1433;databaseName=FacingIssuesOnITDb |
| Postgre | org.postgresql.Driver | jdbc:postgresql://<server> :<port>/<databaseName> <b>Eg:</b> jdbc:postgresql://localhost :5432/FacingIssuesOnITDb |
| MS Access(JDBC-ODBC Bridge) | sun.jdbc.odbc.JdbcOdbcDriver | jdbc:odbc:Driver={Microsoft Access Driver (.mdb)}; DBQ=<myDBName.mdb>; Eg: jdbc:odbc:Driver={Microsoft Access Driver (.mdb)}; DBQ=FacingIssuesOnITDb.mdb; |
| Teradata | com.teradata.jdbc.TeraDriver | jdbc:teradata://<server> /database=<databaseName> ,tmode=ANSI,charset=UTF8 <b>Eg:</b>jdbc:teradata://localhost /database=FacingIssuesOnITDb , tmode=ANSI, charset=UTF8 |
| Elasticsearch | jdbc:es//[http|https]?[host[:port]]*/[prefix]*[?[option=value]&]* Ex: jdbc:es://http://server:3456/timezone-UTC&page.size=250 |
Learn More on JDBC
Follow below links to learn more on JDBC and solving JDBC related issues :
You must log in to post a comment.