Prakash Chicka

Hi,
I am very much intrested to join..please send me the details....

prakash_042@rediffmail.com

Regards,
Prakash

Mark,
Thanks for your help but still we are not able to figure out the root cause. we cant expreriment each time as the application is in production and we are not able to reproduce the same in our test environment.

Regards,
Prakash

Pat,
Thanks lot for your reply, I have, Connection Timeout=180, idle timeout=1800, and orpahn timeout=1800. I really dont know where we set this "SELECT_OPEN_CURSOR=true".
The client is using WAS 4.0.4 and its in the production.

Regards,
Prakash

I need a help on how to set up trace for IBM WAS. We have a application, which is running on WAS and Oracle is the DB server. We are coming across "com.ibm.ejs.cm.portability.ResourceAllocationException: ORA-01000: maximum open cursors exceeded" error even though we are explicitly closing connections/resultsets/statements in the code.

Is there any possibility that WAS not releasing the connections back to the pool and causing this problem. If so, please let me know if there are any settings in the WAS.

The connection values in the WAS are set to min=1 and max=10, the open_cursor value is set to 600 and there are more than 100 apps using the same instance.

It would be great if anybody can help me as earliest.

Hi Avi,
Thanks lot for your reply. The problem is happening in the production server (may be tomorrow they will take our app out from production) and they have executed the query and sent me the output. According to that, our application has opened 160 cursors.
I have been telling them that, there are many ways they can tune the database to overcome this problem. Since I am not a DBA, I dont know where exactly we can tune it in the databse.Also they are not ready to trace it and give us the inputs.
Strange thing they are saying that "There are more than 100 Apps. using this Instance and they are not facing such problem". I just cant beleive this as cursors will be shared across the applications.

It would be great if anybody can give me the exact solution in the oracle level or WAS level, so that I can ask them to do the same.

Regards,
Prakash

Hi Mohan,
Thanks again for your reply..HP is selected me, based on my real time problem solving skills.Though I have not worked on any of the automation tools, they liked the kind of work i have done.
In HP, they wont give a lead role for less than 5 yrs exp(i am not sure, just i heard it from someone), so there is no way that I can get the lead role. Also the offer letter has been issued and I cant go back and ask them.

Regards,
Prakash

Hi Mahesh,
Thanks for your reply. As I have mentioned earlier, I am not doing any automation or scripting work here. Just doing configuration management, building, deploying and manula testing. I am worried coz when I see the adds, they are asking for people who has got exp.on automation tools or on scripting. Do you think that, what I am doing currently will help me in the long run?

Regards,
Prakash

Hi Shalini,
Thanks for your reply, it would be great if you can get me in touch with him.
Also I am thinking of other alternative, ask for a shift to development here in the present company. But I have few concerns as whether I can do justice to my job or not, since its allready 2.9 yrs, I am into testing(never done any development). Is it worth to shift for development if I get a chance or better to continue in the Testing field itself?

Regards,
Prakash

Thanks for your suggestion...also I met few of my friends in the week end, some says better join HP, you will have company tag. Few says, the work in big companies is just 9 to 6 and you will not be having more to do. Since I never worked for big companies before, I am totally confused. Would be great if anybody can give me some information on the work culture in HP and learning opportunities.

Regards,
Prakash

Hi Avi,
Thanks for your help. I have executed my this query many times and also we can see some of our our queries holding the cursor. But we are closing the connections/resultsets/statements properly after executing the query. Please let me know if there is way, i can find out that eiter application server or the oracle server are not releasing the cursors properly.

Also the client says, there are more than 100 apps using the same Instance and they are not facing the problem. Is it possible for other applications to get the cursor when it says, ORA-01000: maximum open cursors exceeded for the other application which is using the same instance.

Regards,
Prakash

yes its been closed in the finally block only.....all that part is very fine...please let me know if there are any settings in oracle level or WAS level can help us to solve this problem...

Hi Gregg,
Thanks lot for your suggestions and let me elaborate my confusion. Right now I am leading a team of 4 members and we work here on J2EE/J2ME projects. I am getting all sort of exposure like setting up the DB server, app server, deploying packaging and also some time i do client interaction. But I am not doing any test automation or coding or anything. We just do the manual testing.
When I look into the job coloumns, everybody is asking for work exp either on any of the tools(win runner, load runner, silk test etc)or any of the scripting language (perl, tcl/tk, unix shell scripting).

So the HP manager has told me that, I will get a chance to work there on perl and unix shell scripting. But this is hard to beleive, who knows after joining there they may give me some junk work.

I have allready resigned from the present company and given the joining date as 20th. But still i can manage to stay back as my manager is very close to me.

Also this decision is hard for me to digest as my manager was very close to me and he never expected that i will quit the company.When i think of all this, will go more emotional and feel that should stay back.

My mind is absolutely not working as it has become very hard for me to take the decision.
It would be great if you can give me some more inputs....

Regards,
Prakash

Now I am working in a small organisation as Lead Test Engineer(40 employees including India and US). I have an offer from HP and they have offered 30% more to my present CTC. May be after next month i will get the same if i stick to the present company.
Since I have only 2.9 yrs exp.SO have to join as Test Engineer as HP will not give lead position for my exp. Also my present company is ready to send me onsite for a moth period after 2 months.

My feeling is, if i go to HP, there is company tag and which will help me in the future.
Would anybody suggest me, whether I should stick to the present company or go to HP.

Regards,
Prakash

Hi All,
Could any one help me on this as its very urgent and the application has been removed from the production because of this problem.

We went through the code just to make sure if there are any connections/resultsets/statements are left openend. But we have taken care to close all connections, resultsets and statements and its been done in the standard format.

public boolean closeConAndStatement(Connection con, PreparedStatement prepareStmt, ResultSet resultset)
{
try
{
if (resultset != null)
resultset.close();

if (prepareStmt != null)
prepareStmt.close();

if (con != null)
con.close();

resultset = null;
con = null;
prepareStmt = null;

return true;
}
But still i dont know why the hell this problem is happening.

Server details:
1. Oracle database server
2. WAS 4.0.4
Connection pool settings in WAS: min=1 and max=30
open_cursors=300 in init.ora file

The application runs fine for some days and then starts giving this problem.
The open_coount has reached to 150.

Also it would be great if explain the difference b/n cursor and connection.

Thanks in advance,
Prakash
[ May 17, 2006: Message edited by: Bear Bibeault ]

James, thank you very much for your response....let me elaborate my problem. Basically the application has been developed using MVC architecture and I have to do the performance test for following requests....

1. Login
2. Send message
3. Track message (here the user can see the messages sent and received)
4. Logout

The session will be created when the user goes to the the login page. When the user hits submit button after entering username/password, it gets "carrID" from the session (we are using cookies to mantain session) and invokes a servlet. I have given some souts to check what session value is coming, it says session value=null. But when I see the TCP dump, the jmeter is sending the proper values. Could you please let me know how to debug this problem and if there are any different settings in jmeter for MVC architecture.

thanks & regards,
Prakash