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=3839451#3839451 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839451 ------------------------------------------------------- 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
