Outline

1. Download & Install Eclipse
2. JDBC Driver
   • Microsoft JDBC Driver
     • Download Microsoft JDBC Driver
3. Configure Database
   • Microsoft SQL Server
     • Provision Database
       • WideWorldImporters ( Sample Database )
         • Restore Database
     • Provision Principal
       • Create SQL Server Principal
       • Grant Principal access to database
       • Grant principal access to database objects
4. Configure Eclipse
   • Install Components
     • JBoss Tools
       • Hibernate

Tasks

Download & Install Eclipse

Please peruse this post per installing Eclipse :-

Eclipse IDE – Installation On MS Windows
Link

JDBC Drivers

Our database back-end is Microsoft SQL Server and so we will reach for Microsoft SQL Server JDBC Drivers.

Microsoft

SQL Server

JDBC Driver

Links

1. Microsoft JDBC Driver for SQL Server
   Link
2. Download Microsoft JDBC Driver for SQL Server
   Link

Available

Here are all the drivers available as of 2019-May-6th :-

We are on 7.0.

And, we will cover that in this post!

Database

Again, our database back-end is Microsoft SQL Server.  There are a few sample databases on that platform; the latest official is WorldWideImporters.

Microsoft

SQL Server

Worldwide Importers

Links

1. SQL Samples
   Link
2. Wide World Importers
   • Wide World Importers sample database v1.0
     Link

Brochure

Brochure

Choice

We can go with traditional database backup files ( bak ).

Or with bacpac.

We chose :-

SQL Server 2016 SP1 (or later) Any Edition aside from LocalDB; SQL Server 2016 RTM (or later) Evaluation/Developer/Enterprise Edition
WideWorldImporters-Full.bak

Restore database

Launched SQL Server Management Studio and restored the backup file

USE [master]
go

exec master..xp_create_subdir N'C:\Microsoft\SQLServer\Datafiles\WideWorldImporters\'
go

exec master..xp_create_subdir N'C:\Microsoft\SQLServer\Logfiles\WideWorldImporters\'
go

RESTORE DATABASE [WideWorldImporters]
FROM  DISK = N'C:\downloads\Microsoft\SQLServer\Sample\WideWorldImporters\WideWorldImporters-Full.bak'
WITH
       FILE = 1
    ,  MOVE N'WWI_Primary' TO N'C:\Microsoft\SQLServer\Datafiles\WideWorldImporters\WideWorldImporters.mdf'
    ,  MOVE N'WWI_UserData' TO N'C:\Microsoft\SQLServer\Datafiles\WideWorldImporters\WideWorldImporters_UserData.ndf'
    ,  MOVE N'WWI_Log' TO N'C:\Microsoft\SQLServer\Logfiles\WideWorldImporters\WideWorldImporters.ldf'
    ,  MOVE N'WWI_InMemory_Data_1' TO N'C:\Microsoft\SQLServer\Datafiles\WideWorldImporters\WideWorldImporters_InMemory_Data_1'
    ,  NOUNLOAD
    ,  STATS = 5
    ,  REPLACE

GO

Create Database Account

Let us create SQL Server Account

use [WideWorldImporters]
go

/*
    SQL Server Principal - helloDB
*/
if suser_id('helloDB') is null
begin

    create login [helloDB]
    with password = 'Nu3Hu5RuSt'
       , DEFAULT_DATABASE = [WideWorldImporters]
       , CHECK_EXPIRATION = OFF
       , CHECK_POLICY = OFF

end
go

/*
    SQL Server Principal - helloDB
*/
if user_id('helloDB') is null
begin

    create user [helloDB]
    from login [helloDB];

end
go

grant select, insert, update, delete on schema::[Application] to [helloDB]
go

grant select, insert, update, delete on schema::[Purchasing] to [helloDB]
go

grant select, insert, update, delete on schema::[Sales] to [helloDB]
go

grant select, insert, update, delete on schema::[Warehouse] to [helloDB]
go

jboss.org

Available Software

In the Work With entry box, please enter :-

http://download.jboss.org/jbosstools/photon/development/updates

Once entered please click the “Add…” button

Add Repository

Please give a Name for the Repository we are adding.

In our case we chose jboss.

Check the items that you wish to install

Using Web Services, jboss.org is reached.

Available Items are returned and displayed.

Item – jBoss Data Services Development

We selected the following items :-

1. JBoss Data Services Development
   • Hibernate Tools

Item – jBoss Data Services Development – Install Details

Please review the selected items :-

1. JBoss Data Services Development
   • Hibernate Tools

Item – Review Licenses

Please review License Agreement

1. License text(for Hibernate Tools 5.4.4.v20190328-1505)

Item – Review Licenses

Please review License Agreement

1. License text(for Hibernate Tools 5.4.4.v20190328-1505)

Item – Installing Software

Item – Security Warning

Security Warning – The authenticity or validity of the software cannot be established

Even Hibernate.org is shipping software without SSL Certificates?

It is good, please click “Install anyway”.

Restart

Please restart Eclipse ID to effect the changes.

Restarted

Upon restart, we are asked to opt in for anonymous usage statistics.

Summary

Enough shenanigans for Day 01.