Gen Java EJB and Column Encryption in Microsoft SQL Server

Products

• Gen
• Gen - Workstation Toolset
• Gen - Host Encyclopedia
• Gen - Run Time Distributed

Issue/Introduction

Using Gen Java EJB server applications and would like to perform column encryption in MSSQL Server, which is pretty easy at server level. However, how can we handle this within Gen?

Example from SQL Server 2019: Encrypt a Column of Data

The idea would be that we could either change a properties file within the Gen runtime so that it is all included with the toolset without any external generation and or major code changes to the model code/CA runtimes etc.

Environment

Release : 8.6

Component : Gen Enterprise Java Beans

Resolution

This is something that would need to be done for the MSSQL datasource configuration in the Java Application Server being used and is not part of the actual Gen generated application/runtime.

The MSSQL JDBC Driver supports setting "columnEncryptionSetting=Enabled" - more details here: Using Always Encrypted with the JDBC driver