AnsweredAssumed Answered

JBOSS SQL normalizer issue

Question asked by Danaddo on Aug 27, 2018
Latest reply on Aug 30, 2018 by Hallett_German

I am trying to use Regualar expression to normalize SQL (Oracle) database within jboss application on both Windows and AIX servers. The interesting thing is on Windows server when used the below regular expression, works but not on AIX servers. Please help. Find the expression below:

introscope.agent.sqlagent.normalizer.regex.keys=key1,key2,key3,key4

 

introscope.agent.sqlagent.normalizer.regex.key1.pattern=SELECT.*FROM.*

introscope.agent.sqlagent.normalizer.regex.key1.replaceAll=true

introscope.agent.sqlagent.normalizer.regex.key1.replaceFormat=SELECT FROM

introscope.agent.sqlagent.normalizer.regex.key1.caseSensitive=false

 

introscope.agent.sqlagent.normalizer.regex.key2.pattern=CREATE.*TABLE.*

introscope.agent.sqlagent.normalizer.regex.key2.replaceAll=true

introscope.agent.sqlagent.normalizer.regex.key2.replaceFormat=CREATE TABLE

introscope.agent.sqlagent.normalizer.regex.key2.caseSensitive=false

 

introscope.agent.sqlagent.normalizer.regex.key3.pattern=DROP.*TABLE.*

introscope.agent.sqlagent.normalizer.regex.key3.replaceAll=true

introscope.agent.sqlagent.normalizer.regex.key3.replaceFormat=DROP TABLE

introscope.agent.sqlagent.normalizer.regex.key3.caseSensitive=false

 

introscope.agent.sqlagent.normalizer.regex.key4.pattern=INSERT.*INTO.*

introscope.agent.sqlagent.normalizer.regex.key4.replaceAll=true

introscope.agent.sqlagent.normalizer.regex.key4.replaceFormat=INSERT INTO

introscope.agent.sqlagent.normalizer.regex.key4.caseSensitive=false

Outcomes