Solved

Running AS/400 Program Remotely Connection gets Hang!

Posted on 2008-06-16
4
291 Views
Last Modified: 2008-09-30
Hi Experts!
I am using jsp  to connect DB2 Universal database for iseries, but my application is hanging while trying to connect to the 400. No exception is returned - it just sits there. I have no real knowledge of the 400 side of things so I don't know how to log user activity to see what is going wrong or anything.

I have checked with debugging on the line connection1 = d.connect(o,p,"xxxxx"); it gets hanged. please help me out of this problem.


Connection connection1 = null;
		 
		
	     AS400JDBCDriver d = new AS400JDBCDriver();
	     Properties p = new Properties();
	
	     AS400 o = new AS400("HOSTSEVRENAME");
	
	     p.put("user", "USERNAME");
	     p.put("password", "PASSWORD");
	     try
	     {
	    	 connection1 = d.connect(o,p,"LIB");
//on this line the application gets hang
 
	     }
	     catch(SQLException sr)
	     {
	    	 try
	    	 {
	    		 connection1.close();
	    	 }
	         catch(Exception e)
	         {
	        	 response.sendRedirect(response.encodeRedirectURL("login.jsp?action=efailed_" + e.getMessage()));
	         }
	         response.sendRedirect(response.encodeRedirectURL("login.jsp?action=srfailed_" + sr.getMessage()));
	     }

Open in new window

0
Comment
Question by:vikasbapat
[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
4 Comments
 
LVL 16

Accepted Solution

by:
theo kouwenhoven earned 500 total points
ID: 21801260
Hi Vikasbapat,

Did you include the jar files util400.jar and jt400.jar? You need them both.
What will you do with the "LIB" in the connect? using the library list require "*LIBL"

If we don't get more info, we can't really help more I think, but in the mean time, check these examples,
I think it will help you a lot.

http://www.code400.com/viewsamples.php?lang_id=19

Regards,
Murph

0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 21802259
are you sure that the session can be made on the network ? maybe some ports are blocked
what do you mean by hang? when does it unhang and what message do you receive?
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

Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Suggested Courses

632 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