Eclipse/Hibernate – Installation – Day/01

  Outline Download & Install Eclipse JDBC Driver Microsoft JDBC Driver Download Microsoft JDBC Driver 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 Configure Eclipse Install Components JBoss Tools Hibernate Tasks Download … Continue reading Eclipse/Hibernate – Installation – Day/01

Eclipse – Data Source Explorer – SQL Server – Configuration ( Day 01 )

Background Ran into a blocking issue while playing around with Eclipse. The issue surfaced while trying to configure Hibernate to connect to SQL Server.   Data Source Explorer I tried using the Hibernate Data Tools to connect to my back-end database; SQL Server in this case. Finally gave up and wanted to see if I … Continue reading Eclipse – Data Source Explorer – SQL Server – Configuration ( Day 01 )

DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver

Background As always coming back to DBeaver. This time to connect to a UDB Instance running on Linux. BTW, UDB means Universal Database. UDB JDBC Driver Artifacts DB2 JDBC Driver Versions and Downloads The URL for DB2 JDBC Drivers is Link. Here is a current snapshot. v11.1 FP0 ( GA ) We chose the v11 … Continue reading DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver

DBeaver – Database Connection Configuration – Oracle – Oracle JDBC Driver

Background Towards a couple of sample Oracle Database sample exercises that we have in mind wanted to make sure that our all purpose database client, DBeaver, is able to communicate with an Oracle Database.   Preparation Oracle Java Version Objective The version of JDBC Client that we need will be based on the version of … Continue reading DBeaver – Database Connection Configuration – Oracle – Oracle JDBC Driver

Java – JDBC – Microsoft Drivers – Named Instance/ “Un-Default” Port Issues

Perplexingly, there are various issues one may run into while attempting to connect to a MS SQL Server Instance, especially the partner node of a mirrored-database. This problem seems to be more common when MS SQL Server is running on something other than its default port 1433. The problem is also well chronicled SQL 2005 … Continue reading Java – JDBC – Microsoft Drivers – Named Instance/ “Un-Default” Port Issues

Microsoft – MSSQLServer / JDBC 3.0 Driver Released

Microsoft - MSSQLServer / JDBC 3.0 Driver Released For those who develop\support Oracle\Sun Java based Applications that interacts with MS SQL Server, you may want to consider MS latest JDBC Driver - Microsoft SQL Server JDBC Driver 3.0.  It is available @ http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en