Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » IBM Java Toolbox (JT400.jar) JDBC Driver Extremely Slow Performance
IBM Java Toolbox (JT400.jar) JDBC Driver Extremely Slow Performance [message #176260] Mon, 10 July 2006 16:19 Go to next message
Robert McCoy is currently offline Robert McCoyFriend
Messages: 2
Registered: July 2009
Junior Member
Hello,

I am currently trying to get started with BIRT 2.1RC6 and connecting to an
AS400 using the IBM Java Toolbox (jt400.jar) JDBC driver in the JTOpen 5.1
package.

I define the datasource in BIRT as:

Driver Class: com.ibm.as400.access.AS400JDBCDriver ( v7.0)
Database URL: jdbc:as400:<server name>/<default
library>;libraries=<libraries in my library list>
Username: <valid username>
Password: <valid password>
JNDI URL: <blank>

I can test the connection and the message comes back quickly that it tests
successfully.

However, when I set up a data set using this connection, it will take
minutes for it finally bring up the dialogue to edit that data set. Also,
when I go to the "Query" section, under the available items subsection it
will display all system schemas (libraries) defined on the server.

After a report is created, I get the same performance (very slow) when I try
to view this report. I suspect that it is loading all of the metadata for
the system schemas each time it makes a connection, but I have tried
numerous properties associated with the JT400 JDBC driver and nothing keeps
it from loading this data. Has anyone had a similar experience or know of a
way to resolve this issue?

Thank you in advance for you help!

Bob
Re: IBM Java Toolbox (JT400.jar) JDBC Driver Extremely Slow Performance [message #179963 is a reply to message #176260] Tue, 25 July 2006 13:01 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: susanb.softlanding.com

I followed the Birt World article "Using BIRT on the iSeries", up to the
point of designing a report, and I am experiencing the same. Actually, most
times I never even get to the data set dialog. Eclipse seems to hang on the
New Data Set dialog. Have you , or anyone else, gotten any further with
using the jt400.jar?

Thanks,
Susan
Re: IBM Java Toolbox (JT400.jar) JDBC Driver Extremely Slow Performance [message #180055 is a reply to message #179963] Tue, 25 July 2006 20:32 Go to previous messageGo to next message
Robert McCoy is currently offline Robert McCoyFriend
Messages: 2
Registered: July 2009
Junior Member
No, due to other project priorities we have had to leave Birt alone for the
time being. We currently use Actuate eReports for our reporting (it is
being phased out since Actuate is now involved in the BIRT project). We
experienced the same issue using the jt400.jar JDBC driver in that product.
We have switched to using the Sun ODBC-JDBC bridge driver which uses ODBC to
make the connection. The response time is phenomenally different. The Sun
bridge would complete a report in a matter of seconds and the jt400 would
literally take minutes.

We have inquired with IBM to determine if it is an issue with the driver
itself but have gotten no where. I was hoping with BIRT rising popularity
that someone would have the same issue and would know how to work around
this issue.

However, I have used other utilities with the jt400.jar driver and they
perform great. I'm not sure what the difference is. One would think that
it may be BIRT not properly using the driver to make the connection.

By the way Susan, I see that your email address is SoftLanding.com. I am a
big fan of the plugins you all have put out! Sorry I couldn't be much help.
Hopefully someone else may be able to shed some light on the situation.


"Susan Bradeen" <susanb@softlanding.com> wrote in message
news:ea54ng$2v6$1@utils.eclipse.org...
> I followed the Birt World article "Using BIRT on the iSeries", up to the
> point of designing a report, and I am experiencing the same. Actually,
most
> times I never even get to the data set dialog. Eclipse seems to hang on
the
> New Data Set dialog. Have you , or anyone else, gotten any further with
> using the jt400.jar?
>
> Thanks,
> Susan
>
>
Re: IBM Java Toolbox (JT400.jar) JDBC Driver Extremely Slow Performance [message #180243 is a reply to message #180055] Wed, 26 July 2006 15:04 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: markp.softlanding.com

Robert McCoy wrote:

> However, I have used other utilities with the jt400.jar driver and
> they perform great. I'm not sure what the difference is. One would
> think that it may be BIRT not properly using the driver to make the
> connection.

I think the problem is that BIRT tries to automatically retrieve all of
the schemas and tables without letting you apply a filter to the
process. In our case, we have 5000 libraries/schemas on our iSeries,
with probably 10 times that many tables. So BIRT is locked up trying
to get at that information.

If the schemas could be filtered before it tries to connect it would
help. The DTP project lets you define JDBC drivers and then browse
schemas and tables. It also lets you define filters on the connection.
So I can filter by a specific library to only see tables in that
library. This works much faster in retrieving the information.

BIRT probably needs something like that added to make it work
effectively with an iSeries.

Mark
Re: IBM Java Toolbox (JT400.jar) JDBC Driver Extremely Slow Performance [message #1693230 is a reply to message #180243] Wed, 22 April 2015 14:32 Go to previous message
kate fryatt is currently offline kate fryattFriend
Messages: 3
Registered: February 2015
Junior Member
I believe it can be down to the data that you using that can make everything slow?

For example if your db has 50,000 records and your query is to select everything - it will cause everything to become slow and sluggish even more so if the database is not indexed accordingly.

I found this was the reason myself and I have the same set up as yourself using the jt400. I have since changed my queries to ensure I bring back more specific data or if you do need all of the data, it's just a waiting game I think unfortunately (but indexing will make it quicker as far as I'm aware)

(I know this post is old but I am posting this in the hope it can help another who visits this topic as it seems to effect a lot of people)
Previous Topic:Revisiting BIRT on the iSeries
Next Topic:Hibernate + Birt Report Engine API + Tomcat
Goto Forum:
  


Current Time: Thu Mar 28 20:45:26 GMT 2024

Powered by FUDForum. Page generated in 0.04746 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top