Gen Java EJB and Column Encryption in Microsoft SQL Server
search cancel

Gen Java EJB and Column Encryption in Microsoft SQL Server

book

Article ID: 139381

calendar_today

Updated On:

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