JDBC Sender Selects Queries

[Former Member]

I know that the JDBC sender adapter can handle joins, but can it handle more sophisticated SELECT queries such as subselects, group by, rownum, etc. In other words, are there any limitations in the SELECT query?

Thanks in advance.

[bhavesh_kantilal · Accepted solution]

Hi bevan,

I dont think this should be a problem. Only criteria is that Select Query should contain one Select Statement.

Regards,

Bhavesh

[former_member189324]

Hi Bevan,

The only limitation with XI30-JDBC Sender Adapter is with Oracle Stored Procedure/Functions, as Oracle SP Query returns a cursor, and not a resultset.

Thanks

Prasad