Ask a Question

sql query works in toad but not in ready api

Chiam_c
Occasional Contributor

sql query works in toad but not in ready api

Admitedly i dont know why this is not working but i have happened upon an odd issue.

 

I have a rather long sql query that works fine in toad but throws a null pointer exception when running in  ready api (1.7.0 Soapui NG pro) . 

 

I know what your thinking its a null pointer, but i should also add that the query works just fine when i run it from the build query screen in the jbdc test step.  Below you will find the query that i am attempting to run.  The connection tests fine and all other queries to the database run fine.  The exact error states :   SQL Query - Plus1 Accociated Device: Error getting response; java.lang.NullPointerException  

 

anyone have any clues what is going on? is this a limitation of ready api (number of char on a single line string?) , or am i hitting a bug?

 

SELECT
'r << TOK 1' || chr(10) ||
'0 PIN_FLD_POID POID [0] 0.0.0.1 /device/num ' || TO_DEVICE.POID_ID0 || chr(10) ||
'0 PIN_FLD_STATE_ID INT [0] 1' || chr(10) ||
'TOK' || chr(10) || 'xop PCM_OP_WRITE_FLDS 0 1' || chr(10) ||
'r << XX 1' || chr(10) ||
'0 PIN_FLD_POID POID [0] 0.0.0.1 /device/num ' || FROM_DEVICE.POID_ID0 || chr(10) ||
'0 PIN_FLD_SERVICES ARRAY [0] allocated 20, used 1' || chr(10) ||
'1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/iri_tel ' || DS.SERVICE_OBJ_ID0 || chr(10) ||
'1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account ' || DS.ACCOUNT_OBJ_ID0 || chr(10) ||
'0 PIN_FLD_PROGRAM_NAME STR [0] "BillingOps Device Associate"' || chr(10) ||
'0 PIN_FLD_FLAGS INT [0] 0' || chr(10) ||
'XX' || chr(10) || 'xop PCM_OP_DEVICE_ASSOCIATE 0 1' || chr(10) ||
'r << XX 1' || chr(10) ||
'0 PIN_FLD_POID POID [0] 0.0.0.1 /device/num ' || TO_DEVICE.POID_ID0 || chr(10) ||
'0 PIN_FLD_SERVICES ARRAY [0] allocated 20, used 1' || chr(10) ||
'1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/iri_tel ' || DS.SERVICE_OBJ_ID0 || chr(10) ||
'1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account ' || DS.SERVICE_OBJ_ID0 || chr(10) ||
'0 PIN_FLD_PROGRAM_NAME STR [0] "BillingOps Device Associate"' || chr(10) ||
'0 PIN_FLD_FLAGS INT [0] 1' || chr(10) ||
'XX' || chr(10) || 'xop PCM_OP_DEVICE_ASSOCIATE 0 1' || chr(10)
FROM PIN.DEVICE_T FROM_DEVICE, PIN.DEVICE_T TO_DEVICE, PIN.DEVICE_SERVICES_T DS
WHERE FROM_DEVICE.POID_ID0 = DS.OBJ_ID0
AND FROM_DEVICE.DEVICE_ID = 'xxxx' <- this is retrieved from a data source but i have tried a real number
AND TO_DEVICE.DEVICE_ID = 'yyyy'  <- this is retrieved from a data source but i have tried a real number

2 REPLIES 2
TanyaYatskovska
Community Manager

Re: sql query works in toad but not in ready api

Hi Chiam_c,

 

 

I suggest that you check if you see the same behavior in the latest Ready! API version - v. 1.8. You can download the installation file here:

https://support.smartbear.com/downloads/readyapi/

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Chiam_c
Occasional Contributor

Re: sql query works in toad but not in ready api

Yes ! thank you that worked perfectly.

cancel
Showing results for 
Search instead for 
Did you mean: