Forum Discussion

Gepir's avatar
Gepir
Occasional Contributor
7 years ago
Solved

groovy blob read

Hi,   I;m trying to read blob from DB, I've created this script (below)    def blob = sql.firstRow("SELECT CASE.APPLICATIONS.DATAPACKAGE as blob FROM CASE.APPLICATIONS WHERE APPLICATIONS.STATUS =...
  • Gepir's avatar
    Gepir
    7 years ago

    So I've found the solution...

    import groovy.sql.Sql
import java.sql.*

sql = Sql.newInstance("jdbc:oracle:thin:@::", "", "")
//selct blob
java.sql.Blob blob = sql.firstRow("SELECT CASE.APPLICATIONS.DATAPACKAGE as blob FROM CASE.APPLICATIONS WHERE APPLICATIONS.STATUS = '0' And APPLICATIONS.APPLICATIONNAME Is Not Null ORDER BY APPLICATIONS.CREATED DESC").blob
byte[] bdata = blob.getBytes(1, (int) blob.length());
String text = new String(bdata);
log.info text;

    next step is decrypt blob... 

Gepir's avatar
Gepir
Occasional Contributor
7 years ago

So I've found the solution...

import groovy.sql.Sql
import java.sql.*

sql = Sql.newInstance("jdbc:oracle:thin:@::", "", "")
//selct blob
java.sql.Blob blob = sql.firstRow("SELECT CASE.APPLICATIONS.DATAPACKAGE as blob FROM CASE.APPLICATIONS WHERE APPLICATIONS.STATUS = '0' And APPLICATIONS.APPLICATIONNAME Is Not Null ORDER BY APPLICATIONS.CREATED DESC").blob
byte[] bdata = blob.getBytes(1, (int) blob.length());
String text = new String(bdata);
log.info text;

next step is decrypt blob... 

  • naveenshetty's avatar
    naveenshetty
    New Contributor
    5 years ago

    Hi,

     

    I am going to use your script for reading BLOB from oracle db.

    In the below line after jdbc connection is it username and password field?

    sql = Sql.newInstance("jdbc:oracle:thin:@::", "", "")

    I will write you if I need any help.

    Thanks in advance.