Hi Jayesh,
Thanks for your reply.
I am using Oracle11g and it doesnot seem to accept the schema name for the datasource.
My application uses the BasicDataSource which does not accept the schema. Its as bellow.
Although I have found another way to resolve the issue. I used the ComboPooledDataSource. So instead of setting a schema I am setting a
string to alter session every time a connection is issued.
This works for me now.
Anyways it would be helpful to have experts opinion on this move. You can even suggest another approach as well.
I am just concerned that for every connection it issues alter session query. I hope that doesnot hit the performance going forward.
Please suggest.
Regards,
Ashish