Solved

Io exception: The Network Adapter could not establish the connection

Posted on 2009-07-09
5
2,608 Views
Last Modified: 2013-11-16
Hi experts,

Please help me on the following strange problem. Thanks in advance!
My JSP Web application runs on Weblogic server (ver 8.3.1), uses Oracle 9i DB. It's main process is
- Step 1: Upload an excel file with more 11 thousands of data row in only one sheet
- Step 2: Read above excel file
- Step 3: With each row:
    + Parse it to build an appropriate object
    + Open a connection to DB
    + Call a stored function in DB to write parsed object to a table in DB
    + Close connection

I'm testing this application in two cases.
    Case 1: Running on Sever A, installed on machine A, using DB installed on machine B
    Case 2: Running on Sever B, installed on machine B, using DB installed on machine B
With Case 1, everything's OK but with Case 2, it throws SQLException 'Io exception: The Network Adapter could not establish the connection' at row 3938 (8 times per 10 times of testing).
So strange that it thows that error at rows below: (one case of testing)
- from 3938 to 5709
- from 6609 to 6633
- from 10937 to 11138

Please help.
Thanks again!
0
Comment
Question by:ncsvietnam
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Murali Murugesan
ID: 24811321
initially try loading the excel file with just 4000 records and see if the same exception arises at line 3938 to 4000.

Is your server running in Cluster environment?.

0
 
LVL 13

Expert Comment

by:Murali Murugesan
ID: 24811396
i would also suggest you to increase the number of connections in your connection pool before you test on Server B. This is more of a Network error rather than a db error.

-Murali*
0
 

Author Comment

by:ncsvietnam
ID: 24811457
@MuraliKanth: I've tried with 4000, even 3938 records, and it raised the same exception
And I think it's not DB error too.
Please tell me how to increase the number of connections in connection pool. I'm sorry because I'm new to DB management.

Open-Close connection and Re-Open too many times is my problem?
0
 
LVL 13

Accepted Solution

by:
Murali Murugesan earned 500 total points
ID: 24811490
You need to go to weblogic Administrator console. Under Connection pools you need to set the number for Maximum Capacity.

I would suggest a quick way to find out wherever your connection hangs. If you can deploy ur app to tomcat there is a connection log trace by setting like this  in server.xml

    <Context path="/proj" docBase="proj" debug="1" reloadable="true">
          <Resource name="<jdbc name>" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbcurl" username="<username>" password="<pwd>" maxActive="4" maxIdle="2" maxWait="-1"
            logAbandoned="true"  removeAbandoned="true"  removeAbandonedTimeout="60"/>
        </Context>

So the highlighted ones will pointout the exact place where ur connection gets locked.

refer this for connection pool increase  http://edocs.bea.com/wls/docs61/jdbc/programming.html


-Murali*
0
 

Author Closing Comment

by:ncsvietnam
ID: 31601460
OK
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now