Solved

Io exception: The Network Adapter could not establish the connection

Posted on 2009-07-09
5
2,638 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
application support SLA 2 159
excpetion with multiple catch 11 132
Use tracing facilities in your browser steps 2 126
physical application forms to digital format 2 77
Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Read about achieving the basic levels of HRIS security in the workplace.

713 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