Search

1 to 3 of 3
Sort by

Discussion Post
How to get Readable data of a BLOB type field while querying DB

StephaneMOLDOCH4453211 norre01 sridevi.kanchustambham #layer7gateway #jdbcquery Hi, 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


Discussion Thread 5
How to get Readable data of a BLOB type field while querying DB

Focus Search - StephaneMOLDOCH4453211 norre01 sridevi.kanchustambham #layer7gateway #jdbcquery Hi, 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( AS CHAR(10000) CHARACTER SET utf8) FROM ; but the result i get from this is in unreadable format. please advice on how to query such rows


Discussion Thread 7
SQL Job Error Message: java.lang.UnsatisfiedLinkError: ocijdbc11 (Not found in java.library.path)

Focus Search - When checking the logfile you see the following : 20161019/132830.244 - U02012035 Start Agent query with RunID '******'. 20161019/132830.246 - U02012041 Query a table without waiting for a database. RunID: '******' 20161019/132830.248 - U02012046 RunID '******': Failed to create a database connection: 'java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path' 20161019/132830.250 - U02012037 Query with RunID '******' ended abnormally