> > >>>> We have some working tomcat 6 instances that we'd like to identify
>
> > >> As David said, this does work with the thin driver, but I need the
> > >> service/load balancing functionality from OCI. Any more suggestions
> > >> are welcome!
>
You didn't say what connection pool you are using, but if you setup DBCP,
you could use the connectionInitSqls property to execute some proprietary
set_context call in Oracle e.g.
dbms_session.set_context('vpd_new','loc_code', pLocCode)
This might allow you to set a flag on a per connection pool basis for all
connections coming from that instance.
I've never done it personally, but sounds like what you are after
Chris
