Solved

Io exception: The Network Adapter could not establish the connection

Posted on 2009-07-09
5
2,643 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exchange 2010 SP3 Enterprise - ActiveSync Policy - Recovery Password option 6 94
web application structure 18 130
login form jsp example 2 69
dao vs facade design patterns 2 68
If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

739 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