 Problem with CMTDataSource [message #132342] |
Fri, 12 August 2005 01:10 |
eknath_singh
Messages: 2
Registered: August 2005
Location: Hyderabad
|
Junior Member |
|
|
I am getting problem with temporary tables in oracle.
In oracle stored procedure we are getting data from database and storing it in temporary tables. We are returning this data through cursor from this temporary tables. This data we are displaying in the front end from jsp pages and getting data through the DBManager.java.
When we are using the OracleXADataSource we are not getting any problems, but when we are using the CMTDataSource then we are getting data doubled for every call of this procedure. It seems that the data from the temporary tables is not cleaned for every search. And it is compulsory that i have to use CMSDataSource, because i am getting some other problems with OracleXADataSource.
What is the feasible solution for this. Can any one have the solution ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
