Forum Discussion

Gepir's avatar
Gepir
Occasional Contributor
8 years ago

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
    8 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

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
6 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.