Skip to Content
Former Member
Jan 29, 2009 at 01:43 PM

JDBC sender adapter - driver problems



Iu2019m struggling with a little problem regarding the JDBC sender adapter, querying an Oracle database.

Iu2019m making a simple SELECT statement, where one of the fields is of the typeu201DTIMESTAMP(0) WITH LOCAL TIMEu201D.

Making the query in a SQL client works just fine, but in the JDBC sender adapter, it generates this error u201DError during conversion of query result to XML: java.sql.SQLException: Session Time Zone not set!u201D

Iu2019ve searched for answers on numerous forums, and found one place, where the following where the solution:

>>> Hi. The issue is that the driver itself needs to have a time zone

>>> set. You have to call setSessionTimeZone() on the connection object.

Unfortunately it is a bit hard to call this function in the adapter.

Any of you guys have an idea what to do?

I can add, that making a query, where no date fields are selected, works fine in the adapter.