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

http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

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

 

Sample Connection String for Oracle XE

jdbc:oracle:thin:@localhost:1521:XE

 

Note:

 To use the standard JDBC4.0 java.sql.SQLXML interface with JDBC 11.2.0.3, you need to use xdb6.jar (instead of xdb.jar) from the 11.2.0.3 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

jdbc:mysql://localhost:3307/testdb

 

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

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

Driver name is sqljdbc4.jar

 

Sample connection String for MS SQL Server

jdbc:sqlserver://localhost:1433;databaseName=hiberdb


 

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.

Tags: 

Comments

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)