How To Connect To Microsoft Sql Server Database Using Eclipse

Though I prefer SQL Server Management Studio to access in addition to piece of work amongst Microsoft SQL Server database, Sometimes, it's ameliorate to connect MSSQL database straight from Eclipse. This volition relieve a lot of fourth dimension which is wasted on switching betwixt ii applications, Eclipse in addition to SSMS. It volition also proceed your PC fast plenty because less application agency less overhead. JDBC drivers inwards your classpath. This is done business office of New Database Connection Profile, ane of the steps, which nosotros volition encounter later. In this article, I'll demonstrate yous measuring past times measuring direct to connect to Microsoft SQL Server database using Eclipse.

For a Java developer proficient noesis of Eclipse IDE, or whatsoever IDE they move e.g. Netbeans or IntelliJ, is a must. It's ever worth to invest to a greater extent than or less fourth dimension in addition to coin learning the Eclipse IDE itself, this volition brand yous to a greater extent than productive inwards Eclipse IDE.

If yous receive got downloaded Eclipse IDE in addition to non certain how to start, read the Eclipse IDE (vogella) past times Lars Vogel. This majority assumes no prior noesis in addition to tin live on used past times a novel Java developer to larn Eclipse. It's an essential read if yous desire to exceed away to a greater extent than productive Java developer. It covers to a greater extent than recent version of Eclipse IDE e.g. Eclipse 4.2 in addition to Eclipse 4.3, hence it's ane of the updated books to larn Eclipse inwards the market.

Just remember, yous require Eclipse IDE for Java EE developers to access the database. It contains tools for database evolution e.g. database explorer. The Eclipse IDE for Java Developers doesn't comprise those tool past times default. FYI, I am using Eclipse Java EE IDE for Web Developers, Version: Kepler Service Release 2.

Alternatively, if yous are primarily a Java EE developer hence yous tin also accept a await at Ram Kulkarni's Java EE Development amongst Eclipse book, which volition attention yous to write code, debug, test, in addition to troubleshoot Java EE seven applications correct from the Eclipse IDE.  One of the best Eclipse books for Java EE developers.

Steps to connect Eclipse to Microsoft SQL Server database

1) Open Eclipse IDE in addition to Select Database Perspective (Windows >> Open Perspective >> Other >> Database Development).
2) Create Connection Profile
3) Select the Database yous desire to connect
4) Put connexion detail
5) Add JDBC JAR
6) Test Connection
7) Use SQL ScrapBook to write in addition to execute SQL Query
8) View Execution Plan

Let's encounter measuring past times measuring direct to connect to Microsoft SQL Server database from Eclipse itself.

1) Open Eclipse IDE in addition to Select Database Perspective (Windows >> Open Perspective >> Other >> Database Development).

2) Create Connection Profile in addition to chose the database yous desire to connect. I receive got chosen Microsoft SQL Server every bit shown below:

3) Specify the JDBC Driver details

Specify a Driver Template in addition to definition Name every bit per your chosen database inwards the previous screen. Here, nosotros receive got selected Microsoft SQL Server 2008 JDBC Driver

Now exceed away to the minute tab, JAR List in addition to specify the path of JDBC driver from your local computer. By default sqljdbc.jar is added at that spot but since the path is non specified yous volition encounter something similar "Unable to locate JAR/zip inwards file organisation every bit specified past times the driver definition: sqljdbc.jar", every bit shown below:

To solve this problem, yous only require to click on Add JAR/Zip alternative in addition to specify the Path where yous receive got downloaded the JDBC driver for Microsoft SQL Server 2008 Edition i.e. sqljdbc.jar or sqljdbc4.jar. Use sqljdbc4.jar if yous are running on JDK seven or using JDBC 4.0, otherwise, yous volition acquire next error:

java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is non supported past times this driver. Use the sqljdbc4.jar course of report library, which provides back upward for JDBC 4.0.
at com.microsoft.sqlserver.jdbc.SQLServerConnection.(SQLServerConnection.java:304)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:328)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)


If yous don't receive got JDBC driver for Microsoft SQL Server, hence yous tin download from here.


4) Specify database connexion special e.g. host, port, username, password in addition to database etc

You are done. Now yous are connected to the SQL Server database from Eclipse itself. Just opened upward an SQL file in addition to pick out the connexion in addition to write SQL queries to execute.

List of Database Supported past times Eclipse

As I told yous inwards the commencement paragraph that Eclipse supports several databases, hither is a total listing of the database which yous tin connect straight from Eclipse.

DB2 for Linux, UNIX, in addition to Windows
DB2 for i5/OS
DB2 for z/OS
Derby
Flat File Data Source
Generic JDBC
HSQLDB
Informix
Ingres
MaxDB
MySQL
Oracle
PostgreSQL
SQL Server
SQLite
Sybase ASA
Sybase ASE
Web Services Data Source
XML Data Source


That's all near how to connect Eclipse to Microsoft SQL Server database using JDBC. Yes, yous read it right, Eclipse internally uses JDBC to connect to these diverse databases. That's why it needs the JDBC JAR files inwards the classpath. You tin farther  use the SQL ScrapBook to write in addition to execute SQL Query in addition to stance Execution Plan. It provides both text in addition to icon based execution plan.

Further Learning
Beginners Eclipse Java IDE Training Course
Eclipse Debugging Techniques And Tricks
The Eclipse Guided Tour - Part 1 in addition to 2

Share this post