RE: Connecting to the iSeries DB using a user with no password

David Morris wrote:

> The two drivers do behave differently but the differences are
> manageable. I would avoid exception handling for normal processing;
> instead you could use the os.name System property. Here is a simple
> connection class I use to treat connections more generically:
> http://cvs.sourceforge.net/viewcvs.py/iseries-toolkit/span/src
> /org/iseriestoolkit/database/AS400ConnectionManager.java?view=markup

Thanks for that, David, there's some useful stuff there.  I haven't got
round to looking at the iSeries Toolkit yet, but it looks like I should.
One question, though.  In this code:

    /** Flag showing system name */
    private static boolean os400 = System.getProperty("os.name")
                                         .equals("OS/400");

Do we know that the value will continue to be "OS/400" in the future?  This
seem particularly relevant in the light of the recent renaming of the OS.
Thought of course, the classes in the Toolbox still begin with "AS400", and
they can't change those.

Colin Williams wrote

> If this is gonna be a cross-platform app, where the app could be one
> platform or box, and the database another as400, i think your going to
> have
> to use the toolbox driver.

It's cross-platform, but for the particular problem I'm investigating at the
moment, I am only considering it when it is running on the iSeries.  Our
users can select a database driver and connection URL, so if I can't get the
toolbox driver to connect with a user whose password is *NONE, we'll just
have to tell them to use the native driver.  Which is a shame, as I believe
that only the toolbox is being actively developed, and I've read that it now
performs better than the native.

Are any of the toolbox developers reading this?  Would you like to comment?

> still kicking around at misys, are many of the old faces still there?

More than you might expect, and I am close to an alarming seventeen-year
anniversary!

Cheers,

Martin.

-- 
Martin McCallion
Senior Technical Consultant
Misys Wholesale Banking Systems
1 St George's Road, London, SW19 4DR, UK
T +44 (0)20 8486 1951
F +44 (0) 20 8947 3373
martin.mccallion@xxxxxxxxx
www.misys.com

This email and any attachments have been scanned for known viruses using
multiple scanners. We believe that this email and any attachments are virus
free, however the recipient must take full responsibility for virus
checking. This email message is intended for the named recipient only. It
may be privileged and/or confidential. If you are not the intended named
recipient of this email then you should not copy it or use it for any
purpose, nor disclose its contents to any other person. You should contact
the Misys Banking and Securities Division as shown below so that we can take
appropriate action at no cost to yourself. 

Misys Banking and Securities Division, 1 St George's Road, Wimbledon,
London, SW19 4DR, England. Email: banking.postmaster@xxxxxxxxxx Tel: +44 (0)
20 8879 1188 Fax: +44 (0) 20 8947 3373