Solved

Io exception: The Network Adapter could not establish the connection

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
squirrelPlay java challenge 40 157
dynamic reloading of jsp in jetty 2 118
Using Tomcat as raspberry pi java app server 13 140
maven j2ee examles 2 49
When CRM stops functioning propperly or mysteriously disappears then this is something you should always check. This can be useful when looking at an end users machine or your own machine if you are the end user. It may be fairly obvious to some but…
Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and marke…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 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

14 Experts available now in Live!

Get 1:1 Help Now