Re: DB Connection Issue after upgrade from v5r2 to v5r3

[Pete Helgren <Pete@xxxxxxxxxx>]

Kara,

Mike, Joe and Rick covered the basics.  Check Java version that is 
installed (and Java Lic Pgm and features).  Check your classpath and 
make sure you are current on PTF's groups for Java and DB.

If all else fails, write a simple DB connect and list routine than can 
check your DB connection.

Pete Helgren


Kara Burkhalter wrote:
> 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
>