RE: DB Connection Issue after upgrade from v5r2 to v5r3

From: Kara Burkhalter

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"

Have you started the host servers? Can you get at the database using
alternative methods? For example, fire up a generic SQL client (such as
Squirrel) on your PC and see if you can access the database on the System i.
If you can, then there's something else wrong with your Java code. But if
you can't, it's either a server or a firewall issue.

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 "

This is the way things work. You can't get the driver until the driver
class registers itself. It registers itself upon the first reference to the
class. So if you put the println AFTER the registerDriver, the "no suitable
driver" error will go away.

Joe