Solved

Running AS/400 Program Remotely Connection gets Hang!

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

911 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

22 Experts available now in Live!

Get 1:1 Help Now