Solved

Running AS/400 Program Remotely Connection gets Hang!

Posted on 2008-06-16
4
287 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
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

810 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