Do not use on any
shared computer
September 7, 2008 04:00am pdt
 
[x]
Attachment Details

Running AS/400 Program Remotely Connection gets Hang!

Tags: IBM websphere, Websphere studio client for iseries  6.0
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.

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
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()));
	     }
Start your free trial to view this solution
Question Stats
Zone: Programming
Question Asked By: vikasbapat
Question Asked On: 06.16.2008
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by murphey2

Rank: Master

Expert Comment by murphey2:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by momi_sabag

Rank: Wizard

Expert Comment by momi_sabag:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628