Up to Discussions in EGL Café

This Question is Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
1 Replies Last post: Aug 18, 2009 5:23 PM by MaxHarris  
Click to view clausweiss's profile  
clausweiss
26 posts since
May 9, 2008

Aug 18, 2009 3:52 PM

EGL data access to DB2 on IBM i doesn't work, jt400.jar might be old


Hi folks, I have seen this happen now a couple of times so I thought I append this info here, so people might be able to find this tip.

If you have DB2 for Windows installed on your workstation there is the following scenario.

When you use the EGL data access application wizard and create a connection to IBM i, the data source is automatically created with this wizard and the class location for the jt400 driver is created pointing to the DB2 directory SQLLIB\tools . The problem is that this jar is totally outdated, it is from 2004. When you try to connect to IBM i with this old jar you will get a connection refused message in the app server console.

You can fix this by copying a newer version of the jt400.jar into the SQLLIB\tools directory, or by pointing to another location that contains a newer jar.

If you go to the properties for the project that contains the EGL data access application and look at the EGL Runtime Data Source property and select the generated data source. You can see the class location that has been generated.

This seems to be behavior that got introduced with RBD V7.5.1, I don't think I have seen this before. Check the data source jt400.jar file when in doubt why a connection doesn't work.

Claus

Tags: egl, ibm_i, db2, rbd, data_access_application
Click to view MaxHarris's profile  
MaxHarris
13 posts since
Jun 2, 2009
1. Aug 18, 2009 5:23 PM Up Image in response to: clausweiss
Re: EGL data access to DB2 on IBM i doesn't work, jt400.jar might be old

Thanks for your response, Claus, but I am doing RichUI EGL with EGL Services rather than an EGL data access application, and the services project seems to be using the right jt400.jar in the plugins\com.ibm.datatools.db2.iseries_3.0.3.v20090522_1813 directory. At least it looks that way wherever I look (EGL Runtime Data Source, etc.). I don't have DB2 for Windows installed.

I have opened a case with IBM and have a PMR in the works. I frankly can't tell if this problem is with EGL or RBD. I will post a final comment here to indicate what the problem was determined to be and how it was fixed. I am confident that it will be resolved.

Actions

More Like This

Bottom Banner