JDBC Drivers and Connection Strings

Here we will list down the sample connection urls used in the jdbc examples at javajee.com.

Oracle Database 11g JDBC Drivers and Connection String


Driver Download Url


Driver names include ojdbc5.jar for java 5,  ojdbc6.jar for java 6 etc.


Sample Connection String for Oracle XE




 To use the standard JDBC4.0 java.sql.SQLXML interface with JDBC, you need to use xdb6.jar (instead of xdb.jar) from the distribution.


MySQL JDBC Connector and Connection String


Driver Download Procedure:

  1. Search for MySQL JDBC Connector, get driver names such as mysql-connector-java-5.0.8, mysql-connector-java-5.1.24.
  2. You need .jar file, not the .zip or .tar. find the .jar within the zip.
  3. Or download and use the .jar by searching the name with .jar (I got it from jarfinder.com url in search results)


Sample connection String for MySQL



Known Issues with MySQL Drivers

  • When using the mysql-connector-java-5.0.8 driver, you need to use Class.forname(com.mysql.jdbc.Driver);  before calling DriverManager.getConnection(url, username, password); This is not required with mysql-connector-java-5.1.24 dricer.
  • When using the mysql-connector-java-5.0.8 driver, prepared statement call will not take space in a table name or a stored proc name even if it is properly quoted.  For example, consider con.prepareCall("{call `sp_with_space in name`()}");. It will give an error: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION sp_with_space does not exist. But this will work with mysql-connector-java-5.1.24 driver.


MSSQL JDBC Connector and Connection String


Driver Download Url


Driver name is sqljdbc4.jar


Sample connection String for MS SQL Server



Important Note

Urls and driver issues mentioned here are based on the time of updating the details for a particular driver/database. If you find any change of url/behaviour, please do let us know.



shams.tabrez.9's picture

i have download the ojdbc6.jar file. now what should i do ? please explain the procedure. thank 

Was it useful?

Please refer to the notes from beginning @ http://javajee.com/java-database-connectivity-jdbc-book and try running the programs having the jar in classpath.

Was it useful?

Quick Notes Finder Tags

Activities (1) advanced java (1) agile (3) App Servers (6) archived notes (2) Arrays (1) Best Practices (12) Best Practices (Design) (3) Best Practices (Java) (7) Best Practices (Java EE) (1) BigData (3) Chars & Encodings (6) coding problems (2) Collections (15) contests (3) Core Java (All) (55) course plan (2) Database (12) Design patterns (8) dev tools (3) downloads (2) eclipse (9) Essentials (1) examples (14) Exception (1) Exceptions (4) Exercise (1) exercises (6) Getting Started (18) Groovy (2) hadoop (4) hibernate (77) hibernate interview questions (6) History (1) Hot book (5) http monitoring (2) Inheritance (4) intellij (1) java 8 notes (4) Java 9 (1) Java Concepts (7) Java Core (9) java ee exercises (1) java ee interview questions (2) Java Elements (16) Java Environment (1) Java Features (4) java interview points (4) java interview questions (4) javajee initiatives (1) javajee thoughts (3) Java Performance (6) Java Programmer 1 (11) Java Programmer 2 (7) Javascript Frameworks (1) Java SE Professional (1) JPA 1 - Module (6) JPA 1 - Modules (1) JSP (1) Legacy Java (1) linked list (3) maven (1) Multithreading (16) NFR (1) No SQL (1) Object Oriented (9) OCPJP (4) OCPWCD (1) OOAD (3) Operators (4) Overloading (2) Overriding (2) Overviews (1) policies (1) programming (1) Quartz Scheduler (1) Quizzes (17) RabbitMQ (1) references (2) restful web service (3) Searching (1) security (10) Servlets (8) Servlets and JSP (31) Site Usage Guidelines (1) Sorting (1) source code management (1) spring (4) spring boot (3) Spring Examples (1) Spring Features (1) spring jpa (1) Stack (1) Streams & IO (3) Strings (11) SW Developer Tools (2) testing (1) troubleshooting (1) user interface (1) vxml (8) web services (1) Web Technologies (1) Web Technology Books (1) youtube (1)