Skip to Content
avatar image
Former Member

JDBC Sender Adapter on Oracle DB

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 13, 2013 at 02:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded