Nicholas, Thanks for your reply. I am a little new to jboss so forgive me if I am missunderstanding. I thought about using new-connection-sql but I wanted something more granular. What I really wanted to do was have an interceptor examine the incoming invocation and determine if the class / method was a method we wanted to trace. Methods would be flagged as interested via a properties file or mbean interface. What I wanted to do was pull the same connection out of jboss' connection pool the the calling method would use and turn on tracing. I wanted to go down the interceptor route so the tracing would work no matter what persistence code was being used (JDBC, CMP, Hibernate). The problem with writing a wrapper around DataSource is that it would require changes to application code which isn't feasable. Is there another way you can think of to accomplish what I'm trying to do?
Thanks, John "nickman" wrote : John; | | I guess you need to issue an Oracle specific call at the creation of the connection, no ? You can do this in the Data Source definition file (oracle-ds.xml). We do this to set the date format: | | | | <new-connection-sql>Alter session SET NLS_DATE_FORMAT='mm/dd/yyyy'</new-connection-sql> | | | | Perhaps that will work for you. If not, you could create a wrapper MBean for the DataSource. Initialize it with the JNDI location of the real data source and then bind it into JNDI at a different name space. You can request connections from your proxy, which will acquire the connection for you, but execute the required operation before it hands the connection back to you. | | //Nicholas View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839456#3839456 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839456 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
