× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WDSCI-L
  3. February 2006

Re: MS SQL Server JDBC connections

Glad to see I'm not crazy - oh, well, might be, but was right on this one, anyway. Seems CRTJVAPGM does not affect JVM startup - makes sense - it is really about shortcutting the JIT kind of thing (I'm probably saying that wrong in some way, but do you get the idea?). The JVM startup is not based on any of the created Java program objects, what it is doing is the security and other authentication, the more classes, the longer. At least, according to my colleague across the aisle.
We found one way to get around this is to use an NEP to do the Java stuff. Definitely do NOT start new jobs for every Java evocation, and the same goes for client/server kinds of things that often fire off a new thread of job. 

HTH
Vern

At 07:36 AM 2/22/2006, you wrote:


I tried some jave, and it happens exactly what vernon said, firs time the
job start the JVM, second and other time time was very good
----- Original Message -----
From: "Vernon Hamberg" <vhamberg@xxxxxxxxxxx>
To: "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx>
Sent: Wednesday, February 22, 2006 2:26 PM
Subject: Re: [WDSCI-L] MS SQL Server JDBC connections


> 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.
>
> --
> 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.
>

--
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.