Hi All,
I am having the following " interface error : not connected" to the DB while connecting to the DB through DRF.
whereas I have written a separate test class for connection to the DB it works fine , but when I am trying to do it using the DRF I am getting issues . I am using the cx_oracle driver for getting connected.
the test connection when I run works fine
$> /usr/local/bin/python testDBConn.py
select count(*) from boa_packages
[(3,)]
but the same DB credentials when I am working with the DRF , its giving me the error , can someone point me to the issue
mycursor.execute(sqlqry)
InterfaceError: not connected
I have set the LD_LIBRARY_PATH in the same python script using os.environ , should I use something else. Appreciate some help in this regard.
further earlier the same code used to work perfectly when I was connecting to a testDB , but now I am trying to connect to the production DB which is where the issue is.
thanks
Raghu