StephaneMOLDOCH4453211 norre01 sridevi.kanchustambham #layer7gateway #jdbcquery
I am trying to query a MySQL RDS Database using Query JDBC assertion, but the result i get is in BLOB(binary) format.
i even tried CASTING it with following query:
SELECT CAST(<column_Name> AS CHAR(10000) CHARACTER SET utf8) FROM <table_name>;
but the result i get from this is in unreadable format.
please advice on how to query such rows.
It may due to the charset, the default charset should be utf8, but the content input on client side might not be utf8
Let me explain what i am trying to do exactly.
Layer7 stores Audits in MySql db. audit_message stores the request and response messages of an API. We need to list all APIs which contains speicific data.
For example: CustomerId = 123,
To list all APIs audits whose request contains customerid:123.
MySQL Query: Select * from audit_message where request_zipxml like '%123%'
This query has given a result but we are not able to validate as columns request_zipxml and response_zipxml are of type blob. It is not in human readable format.
There are some other fields like 'goid' which is of type binary.
How to convert this data into human readable format on query?
I am looking at the wrong place? Any suggestions ?
The DB i have connected to is an External RDS Mysql DataBase.
The client I am using is MySQL Query Browser.
You can use the uncompress function for the "*zipxml" columns to retrieve the data
Awesome Arvind !
UNCOMPRESS function Worked for me, able to see the Data now
Thanks a lot.