JDBC Sender Adapter on Oracle DB

[Former Member]

Hi Guru.

I've a big problem. When I try to read a table from a DB Oracle with the following settlement:

SELECT T.* FROM S3T_OGG T  (is the same with SELECT * FROM S3T_OGG)

The Communication Channel Monitor return this error:

Unexpected error converting database resultset to XML, reason: java.lang.NullPointerException: while trying to invoke the method java.lang.Object.toString() of an object returned from java.sql.ResultSet.getObject(int)

at com.sap.aii.adapter.jdbc.JDBC2XI.convert2XML(JDBC2XI.java:1107)

at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:602)

at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:529)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:185)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:302)

I try to reduce the select with some filter but I can't to determinate the problem.

The table has 240 fields only the keys are a "NOT NULL" fields. I've a lot of fields without value.

Can you help me?

Thanks.

Manuel

[Former Member · Accepted solution]

Hi Guru.

I investigate the problem and I resolve it myself.

The origin of the error is caused by the field type. When I make the select on the TABLE if in the table is present a DATE field I need to convert it to CHAR with the following expresion:

SELECT ...,

TO_CHAR( DATE_FIELD, 'YYYYMMDD' ) AS DATE_FIELD,

...

FROM TABLE

bye

Manuel