Getting NullPointerException in JDBC Prod during connection of ORACLE DB

[Atul Kumar2]

Hi Team,

I am getting this below error in response entry in the ecc_queue via mid server during insert operation via JDBC Prod. Could you please suggest what to do. I am unable to access the hi article on the same which is mentioned in the other post related to this issue, can some one suggest how to fix this or post the content of the hi support article related to this.

!

Regards,

Atul Kumar

[Atul Kumar2 · Accepted solution]

Hi Tony,

Managed to resolve the issue by below code.

// Obtain MID Server

var mid = new GlideRecord('ecc_agent');

mid.addQuery('name','sdbx');

mid.query();

mid.next();

// Get a specific Data Source (predefined to connect to a specific database instance)

var ds = new GlideRecord('sys_data_source');

ds.addQuery('sys_id','b67a63a7dummy0128144b0ed');

ds.query();

ds.next();

gs.log("DataSource:" + ds.sys_id);

//Create a JDBC Probe to Select/Query

var u = new JDBCProbe(mid.name);

u.agent_correlator=u.addParameter('agent_correlator',gs.generateGUID());

u.setDataSource(ds.sys_id);

u.setTable("ODRPOC.INCIDENT");

u.setFunction("insert");

u.addField("SHORT_DESCRIPTION", "My chair will not roll smoothly");

u.addNumberField("PRIORITY", 1);

u.addField("URGENCY", "2");

u.addField("IMPACT", "1");

u.addField("IMPACT", "1");

u.create();

Thanks.

Regards,

Atul Kumar