Re: MS SQL Server JDBC connections

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

A maybe - the JVM on the iSeries has not started up, so it has to go 
through its initial authentication. This always takes a long time. 
Whereas, in Eclipse, your JVM is already running. Consider how long 
it takes to start up Eclipse.

So can you try doing the extract twice in one program (or job on the 
iSeries)? The second should be faster if my theory is anywhere close.

HTH
Vern

At 04:38 AM 2/22/2006, you wrote:

> All,
>
>
>
> I have a JDBC based application that is extracting data from an iSeries
> database, and writing it out to an MS SQL Server database. In eclipse on my
> PC a simple extract takes about 5 secs. However when I move the code onto
> the iSeries, the same extract takes 55 secs, a 10 fold increase. Changing
> the iSeries database driver from jt400 to db2 makes no difference. Running
> crtjvapgm on all the jar's makes no difference.
>
>
>
> Looking at my log output, most of the time is spent creating the SQL server
> connection. Why would this take so long on the iSeries, but be practically
> instantaneous on my PC? (The SQL server database is not local to my PC
> either, it's on the other side of a firewall). I'm using the MS sqljdbc.jar
> I downloaded from the MS website. Are there some tuning options I can play
> with? Is there a better jar to use?
>
>
>
> Anyone else had this problem?
>
>
>
> Regards,
>
> Chris.
>
>
> ******************************************************
> The information in this E-mail and in any attachment is
> confidential and is intended solely for the addressee.
> Access, copying, disclosure or use of such information
> by anyone else is unauthorised. If you are not the
> intended recipient please contact postmaster@xxxxxxxxxxxxxx
> While reasonable efforts are made to ensure these files are free
> of virus infection and offensive materials, if something of this
> nature is inadvertently sent to you, please destroy it, accept
> our apologies and contact postmaster@xxxxxxxxxxxxx with
> details of the sender. We will ensure that action is taken
> immediately to prevent any recurrence. Debenhams accept no
> responsibility for any views expressed by the originator of this email.
>
>
> Debenhams Retail plc (reg. no. 83395) Registered in England and Wales.
> Registered office: 1 Welbeck Street, London W1G 0AA.
>
> http://www.debenhams.com
> ******************************************************
> --
> This is the Websphere Development Studio Client for 
> iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.