Problem in datasource lookup with jboss and oracle

[prashanthgane]

Hi All,
Can any one please explain me how to configure for oracle datasource and have a jndi look up for it...

I am getting the following error when i make a jndi look up for the datasource..

java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.local.LocalDataSource
Please help..it is very critical for me..

Cheers,
Prashanth

[lepekhine]

Get oracle-service.xml from docs/examples/jca,
edit it with your database properties
(set youroraclehost, youroraclesid etc.),
and put it to jboss deploy directory
(that is "deploy").
The jndi name will be "java:/OracleDS"

[prashanthgane]

Hello Sir,
Yep it worked beautifully..
Thank You very much for the reply...
One more thing i wanted to ask about it is..
Does it serves the purpose of connection pooling and connection resource pooling etc..
If there is any other uses of oracle-service.xml file can u please mention about it..
I am looking forward for a reply from you...
Please reply..
Regards,
Prashanth