Announcement Announcement Module
Collapse
No announcement yet.
Using Oracle DBMS_APPLICATION_INFO package Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Using Oracle DBMS_APPLICATION_INFO package

    Hi,

    We're switching from direct JDBC calls to using Spring JDBC. One of the things we do is to tag our connections with something like this:

    Code:
    CallableStatement pstmt = conx.prepareCall("{call DMBS_APPLICATION_INFO.SET_CLIENT_INFO(?)}");
    pstmt.setString(1, "my client");
    pstmt.executeUpdate();
    We'd like to continue to do this after switching to Spring JDBC. We've found it's possible to do this in a transaction, but implementing this in our code would require making every query a transaction and adding that bit of code everywhere. We could also wrapper Spring JDBC so at least the code is in one place and isolated from the developer.

    Is there another way to do this that doesn't require doing what I've described above?

    Thanks!

    Paul
Working...
X