| IBM Java Toolbox (JT400.jar) JDBC Driver Extremely Slow Performance [message #176260] |
Mon, 10 July 2006 12:19  |
Eclipse User |
|
|
|
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 #180055 is a reply to message #179963] |
Tue, 25 July 2006 16:32  |
| Eclipse User |
|
|
|
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 #1693230 is a reply to message #180243] |
Wed, 22 April 2015 10:32 |
| Eclipse User |
|
|
|
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)
|
|
|
Powered by
FUDForum. Page generated in 0.35403 seconds
Home