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

Java – Set – Method – Remove – Null Exception

Background Trying to familiarize myself with Collection classes in Java. With Hibernate being an ORM tool that encapsulates database processes, one has to have a good grasp of records and set operations. Error I ran into a blocking error. It simply read null.   Code Original Code Java Snippet Output Exception Revised Code Java Snippet … Continue reading Java – Set – Method – Remove – Null Exception