How to check if an object is of <type 'oracle.sql.BLOB'> in Python?

Question

We are looking for this type of statement, but when trying it, it doesn't work:

if type(item) == "<type 'oracle.sql.BLOB'>"

Background: We are receiving BLOB type objects back from a JDBC connection in Jython. We are trying to check whether the type of a column returned is of type so we know to decode the binary object.

What else we have tried: Other answers to questions show examples where they use the class name (i.e. type(i) is int) as a test - but in this case, if we use the supposed class name like this:

if type(item) == oracle.sql.BLOB:

We get this error:

NameError: name 'oracle' is not defined

Multiple other answers to questions of this type mention using isinstance() as a preferable method for checking types - but all the answers we saw showed coders using existing objects of that type to test against.

Yet, in this instance, we don't have an object of that oracle blob type.

How do we test for a object type? Or, how do we create an object of that type so we can use isinstance()? Or is there another approach?

Bilesh Ganguly · Accepted Answer · 2020-01-09 01:34:26Z

2

You can get the runtime class of an object using -

.getClass().getName()

You would need to do something as follows:

if item.getClass().getName() == 'oracle.sql.BLOB':
    print "This is a BLOB."

Sample code:

import java.util.ArrayList as ArrayList

arr = ArrayList()
arr.add(10)
arr.add(20)
print arr
print "Name:", arr.getClass().getName()
print "Simple Name:", arr.getClass().getSimpleName()

if arr.getClass().getName() == 'java.util.ArrayList':
    print "This is an ArrayList."

Output:

> jython check_type.py
[10, 20]
Name: java.util.ArrayList
Simple Name: ArrayList
This is an ArrayList.

edited Jan 9, 2020 at 1:34

answered Jan 8, 2020 at 4:15

Bilesh Ganguly

4,1914 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to check if an object is of <type 'oracle.sql.BLOB'> in Python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related