JDBC - Adapter error

[Former Member]

Hi,

i am trying to do a JDBC with a sender adapter.

In the adapter monitoring i get this error:

- 2006-02-27 10:16:46 GMT+02:00: Error: Stopped unexpectedly - reconfigure and activate to continue processing. Error: java.lang.NullPointerException

- 2006-02-27 10:16:46 GMT+02:00: Processing started

what can be wrong?

[Former Member]

Hi,

I may not have a exact solution for this but you can recheck your configuration, for that you can refer my weblog on jdbc,

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Also refer to FAQ on jdbc adapters for the exce[tion you are doing and also check the mapping if it runs in standalone,

OSS for FAQ 831162

hope all these may narrow down the scope of the error.

Regards,

Anirban.

[Former Member]

how can i run it as stand alone?

do you have an example?

[Former Member]

I see that in the VA i don't have a datasource for this DB.

Do i need one? can anyone tell me how to do that?

[Former Member]

Hi,

<i>how can i run it as stand alone?

do you have an example?

</i>

the weblog i gave is that of a standalone ocally, locally configured maxdb using jdbc, you may use that.Its from file xijdbc.

Regards,

Anirban.

[Former Member]

Bhavesh Kantilal

>this is happening because, the SQL query that your JDBC >sender is executing is actually throwing up NO ROWS at all.

Really?

I get the same error after 10-30 hours. The "Poll Interval(secs) is set to 300sec for my JDBC adapter. The SQL query is always returning no rows. But the same JDBC adapter

in another XI system does not throw any problems for a months.

[bhavesh_kantilal]

Hi Mushon,

this is happening because, the SQL query that your JDBC sender is executing is actually throwing up<b> NO ROWS</b> at all.

I would suggest that you run the same SQL query on your Database client and check if any rows are returned.

Change the Database query such that it does return some valid row and then check it on your adapter monitoring.

Hope this helps,

Regards,

Bhavesh

[Former Member]

Where can i see the stack of the exception?