I have SailPoint IdentityIQ running on MySQL and wanted to use Oracle SQL Developer for general query purpose to see some data.
Most of the tables in SailPoint database have one column with name "ID" so it is useful to use "Alias" in the select query but somehow alias for column was not working even for simple query.
For example: SELECT ID as "UserKey" from SPT_IDENTITY;
After doing research on this issue, I found about "useOldAliasMetadataBehavior" parameter. In previous versions of mysql connector, default value for this parameter is set to true but in newer versions, value for this parameter is set as false by default. This was the reason, alias was not working for me.
As a solution, I had to pass the value for this parameter as true in the JDBC URL. Here's the example of JDBC URL:
jdbc:mysql://IP_Address:Port/identityiq?useOldAliasMetadataBehavior=true
