Hook sm.getSession() globally

Hi. You know how most JDBC connection pools have the feature to validate connections before they're borrowed, usually, by running "select 1 from dual".

I was wondering if something similar was possible for borrowing sessions from the session manager. Actually, I need to set certain connection properties with "execute exec_sql '' when I obtain a session. The problem is: for xCP Realtime Query and Advanced Repository Query you cannot put custom java code before it runs the select DQL.

Find more posts tagged with

Comments

DCTM_Guru

I would create a xcp stateless process to call your exec_sql prior to calling RTQ or ARQ. You can the associate the SP to UI action (eg Submit button).

basinilya

DCTM_Guru said:

I would create a xcp stateless process to call your exec_sql prior to calling RTQ or ARQ. You can the associate the SP to UI action (eg Submit button).

This wouldn't work because the IDfSession used by this stateless process is not guaranteed to be reused by the subsequent data action.

For now, I'm going to register a custom low-level connection factory by calling RuntimeContext.getInstance().setDocbaseConnectionFactory().

The factory will notify me when a connection is created.

There's a problem though: in case of a network disconnect DocbaseConnection will silently reconnect and re-run the current RPC, but the RDBMS session will be different and the user code has no means of being notified.