ncsvietnam
asked on
Io exception: The Network Adapter could not establish the connection
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!
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!
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*
-Murali*
ASKER
@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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK
Is your server running in Cluster environment?.