tag:blogger.com,1999:blog-6527688743456205256.post229926945183053910..comments2023-12-18T09:38:33.215+11:00Comments on The Blas from Pas: How to populate v$session.program from mid tier data source connectionsPas Apicellahttp://www.blogger.com/profile/09389663166398991762noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6527688743456205256.post-26331291330722912922007-11-26T09:32:00.000+11:002007-11-26T09:32:00.000+11:00Jayesh,Those properties need to be set at the data...Jayesh,<BR/><BR/>Those properties need to be set at the data source level in the data-sources.xml and this is only supported in OAS 10.1.3.x. The Context is used to provide authentication details for example prior to obtaining a resource from the server and cannot be used to set JDBC properties as you have tried, so it's ignored when you try that.<BR/><BR/>If your using OAS 10.1.2 this solution won't help but if your using OAS 10.1.3.x it will work as I have shown.<BR/><BR/>Thanks<BR/>PasPas Apicellahttps://www.blogger.com/profile/09389663166398991762noreply@blogger.comtag:blogger.com,1999:blog-6527688743456205256.post-59340983114757193262007-11-22T09:33:00.000+11:002007-11-22T09:33:00.000+11:00Pas,I am trying to the same thing using JNDI but n...Pas,<BR/>I am trying to the same thing using JNDI but not achieving any success.<BR/>It works when you try using DriverManager.getConnection, but fails when you want to use DataSource ds = (DataSource)ctx.lookup(datasourceName);<BR/><BR/>Here is my little code, which is not giving me any value for v$session.program.<BR/><BR/>-----------------------------------<BR/>java.util.Properties params = new java.util.Properties();<BR/> params.put("v$session.program", "MyApp"); <BR/> Context ctx = new InitialContext(params);<BR/> <BR/> DataSource ds = (DataSource)ctx.lookup(datasourceName);<BR/><BR/>-----------------------------------<BR/>Any insights ??<BR/><BR/>Thanks,<BR/><BR/>JayeshAnonymoushttps://www.blogger.com/profile/12411538409291699139noreply@blogger.com