2 Replies Latest reply on Oct 23, 2007 11:29 AM by Pete Muir

    How to intercept EM creation to run custom SQL?

    Alex Savitsky Novice

      We need to be able to run some custom SQL (a stored procedure call, actually) every time a connection is opened to the database, and the SQL in question would be taken from an HttpSession-scoped object - does Seam provide a way to accomplish that, using events/interceptors or such?

      Thanks,

      Alex

      P.S. The gory details: we're planning to use Oracle Workspace Manager in our app, and the SQL call in question would be either GotoDate or GotoWorkspace SP call, to control the point in time at which the DB session would see the data...