Question
Connection pooling and contexts
Hello.
I need to use contexts in Oracle so the first step requires me to execute a procedure and then execute a query.
Doing single tests this works perfectly, however my doubts arise for the scenario where 2 concurrent accesses for the database. each one sets the context and then call the query. This could cause that the connection used for the query was accessing the other user context.
I saw that we can do the following:
Does anyone know if by doing this I'm forcing both actions to use the same connection without releasing it to the connection pool?
If it does not can you suggest a way to force that?
Thanks for all the input.
Regards,
Pedro Barbosa
I need to use contexts in Oracle so the first step requires me to execute a procedure and then execute a query.
Doing single tests this works perfectly, however my doubts arise for the scenario where 2 concurrent accesses for the database. each one sets the context and then call the query. This could cause that the connection used for the query was accessing the other user context.
I saw that we can do the following:
<cfquery ..>
<cfstoreproc ...>
</cfstoreproc>
select something from table
</cfquery>
Does anyone know if by doing this I'm forcing both actions to use the same connection without releasing it to the connection pool?
If it does not can you suggest a way to force that?
Thanks for all the input.
Regards,
Pedro Barbosa
