× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Have they got the host server jobs running on the as400. I haven't got a 5250 connection available however the os/400 command is something like:

STRHOSTSVR *ALL

This starts all the host servers, you could optionally just start the database server. that server must be running to server out the data to the client requests. If it's not running there's nothing for your driver to connect to.

Mike

----- Original Message ----
From: Kara Burkhalter <Kara.Burkhalter@xxxxxxxxxxxxxxxxxxxxx>
To: java400-l@xxxxxxxxxxxx
Sent: Thursday, 17 January, 2008 5:21:42 PM
Subject: DB Connection Issue after upgrade from v5r2 to v5r3

Ok, this is my last hope. I had written some java code a couple of years
back when I was a consultant. They upgraded in December from v5r2 to
v5r3. Since the upgrade the java program cannot connect to the DB which
is on their production box. When using the following code, we got the
error "The application requester cannot establish the connection"

DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());
con = DriverManager.getConnection(driver, username, password);
stmt = con.createStatement();

The driver was using the name of the URL it had always been using. So I
then switched the the driver to be the IP address and we got the following
error: "The application requester cannot establish the
connection.(operation timed out"

So then I added the following code before it registers the driver:
"System.out.println("check=" + DriverManager.getDriver(driver));" and get
the following error now: "No suitable driver "

The client contacted IBM in the beginning before we changed it to the IP
address and IBM was no help. They came back saying "It looks like the
servlet is running, and encountering a problem making a data connection to
another system, or to a 'remote' database. " Well, yeah, we know that,
but WHY?

Again - this code worked correctly on Tomcat server on v5r2, the client
then upgraded to v5r3 and it hasn't worked since.

Any help is greatly appreciated!

Thank You,
Kara



This message may contain confidential or proprietary information and is
intended only for the person(s) to whom it is addressed. Any use,
distribution, copying or disclosure of confidential information by any
other person is strictly prohibited. If you have received this message in
error, please notify the e-mail sender immediately, and delete the
original message without making a copy. For information on the UW
Foundation's privacy policy, please visit:
UW Foundation Privacy Policy



This message may contain confidential or proprietary information and is
intended only for the person(s) to whom it is addressed. Any use,
distribution, copying or disclosure of confidential information by any
other person is strictly prohibited. If you have received this message in
error, please notify the e-mail sender immediately, and delete the
original message without making a copy. For information on the UW
Foundation's privacy policy, please visit:
UW Foundation Privacy Policy

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.