Database connectivity issue with JDBC connection to Oracle 9i database

Question

0.00/5 (No votes)

See more:

Hi All,

I am working on a web application which runs on Netscape Application server 4.0. It is built on java 1.1.7. We have Oracle 9i database at back-end.
Recently we migrated our application from HP-UX system to Sun Solaris.
Now-a-days, we face application stall\halt\not working issue frequently.
To make application available immediately, we simply restart the NAS, NES and other services. After that everything works fine

When i checked application logs, i found that it has something to do with free and busy JDBC connections.
Now my question is, when i have set my max connection to more than 100, why it fails after creating 15-20 connections?
Has it something to do with JDBC or the OS or application server.
Please note, the application was built long back and was working all fine on old system.
Even after migrating to new system, it worked very well for 8-9 months. Its recently only the application is giving issue

Your advice\suggestion are much appreciated.
Please help!!!
Thanks in advance!

Posted 26-Nov-13 23:15pm

SanketAB

Add a Solution

Comments

Shubhashish_Mandal 27-Nov-13 5:51am

did you check how much active connections Oracle 9i provide(by default)?

SanketAB 28-Nov-13 1:23am

no...may i know where can i check it?
Anyway but the maximum connections is set to 200, so there should be 200 connections available

CHill60 27-Nov-13 17:58pm

Did you also set the PROCESSES parameter?

SanketAB 28-Nov-13 1:24am

no..what is that??where can i find it

CHill60 28-Nov-13 8:13am

Try here http://docs.oracle.com/cd/B10501_01/server.920/a96521/manproc.htm[^]. This might also be useful debug type post[^]
Let me know if it solves your issue

SanketAB 4-Dec-13 7:08am

Hi CHill60... Thanks for reply.. This looks pretty useful. However, it looks like only system DBA can decode the stuff presented at this link.
Here is my short question,
when there are 100 users working on application, are there 100 connections established to the DB? How this thing work?

SanketAB 28-Nov-13 1:26am

One more thing guys, all these JDBC connection blocks are synchronized and connections are given states as busyconnection and freeconnection.
So when i checked more closely, i found that JDBC is able to establish connections, however, all of them are added to busyconnection

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)