Java/JDBC – SQL Server – “Integrated Security”

Background Wanted to go over the steps to take when one needs to connect to a Microsoft SQL Server Instance using Integrated Security. Outline Java JDBC JDBC Connecting String Class Path Includes SQL Server JDBC Driver ¬†System System Path Add [jdbc-sql]\enu\auth\[platform]\ Tasks Java JDBC JDBC Connecting String Outline JDBC URL IntegratedSecurity=True authenticationScheme=NativeAuthentication Syntax Sample java … Continue reading Java/JDBC – SQL Server – “Integrated Security”

Hibernate / DB Metadata

Background In the early stages of learning Hibernate, I wanted to get some metadata about my database. But, was lost as to how to do so. Outline Connect to Database Get Session Cast Session to sessionImpl Get Connection from sessionImpl Get metadata from Connection Access metadata getURL getDriverName getDatabaseProductName getDatabaseProductVersion getUserName getDefaultTransactionIsolation Code   Output … Continue reading Hibernate / DB Metadata