I have imported the db2 jdbc into the awl developer and I can find the db2 tab. But I can't find any setting that can apply a securityMechanism into the connection string. So when I connect the db it kept prompting security mechanism not supported. Is there any way I can apply the security mechanism to the connection, or if there is any way I can manually configure a jdbc connection string?
0
votes
1 Answers
0
votes
The DATA_ENCRYPT setting is not something that you set up with the securityMechanism property. This is a server level setting, but it only applies to JDBC Type 2 drivers (i.e. using a JDBC URL of the form jdbc:db2:YOURDB).
That said, DATA_ENCRYPT uses a weak security mechanism, and many IBMers from the DB2 Development Lab have recommended strongly against relying on it. SSL is the recommended security mechanism, so you really should talk to your DBA about enabling on your database server so you can use it with your java application.
