Thanks Anantha...
I have created the DataSource in the weblogic...(Production Mode)
But after doing that I faced two Problems....
1) with CLOB data weblogic wrapped the result and returned it....so I have to typecast it with weblogic CLOB instead of sql CLOB...thus writing the App Server dependent code....
any alternative for this...?
2) I am having procedure doing following 2 things... i ) inserts data into Global Temporary Table (Oracle) ii) Opens a Cursor which fetches the data from the same table...
Now the problem is..When I am Using Hibernate Configuration for Connection Parameters .. the proc works absolutely fine i.e the cursor opens with correct data....
But when I use DataSource... the Proc doesn't return anything...i.e the cursor contains zero rows...
Any Idea what could the Problem....?