Re: Connecting to the iSeries DB using a user with no password -- JAVA400-L

Martin,

I can definitely say that the toolbox driver and the native driver do not
work the same. ive been caught by this a couple of times.

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.

I have tried to use the driver option on the toolbox driver in the past,
that is supposed to auto-magically select the toolbox driver for a remote db
connect, or the native driver for a local db connect, but because the native
and the toolbox drivers specify there properties in different ways, unless
your using the default properties, it just doesnt work.

You could also try using the native driver first, in a try/catch block, and
falling back to the toolbox driver if that throws and exception.

Are you externalising all your db connection values
(driver,url,userid,password etc) from the application so that you can change
them as necessary?

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

cheers
Colin.W


----- Original Message ----- 
From: "McCallion, Martin" <martin.mccallion@xxxxxxxxx>
To: "'Java Programming on and around the iSeries / AS400'"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, June 01, 2004 3:09 PM
Subject: RE: Connecting to the iSeries DB using a user with no password


> Colin Williams wrote:
>
> > Is this a local connection to the database, or is this from
> > another system,
> > as I don't think that local connections need a userid or password,
> > they can use the current user profile to connect?
>
> Colin, thanks for your suggestions.  Sorry it has taken me so long to get
> back to this.  This is, indeed, a local connection, though the application
> is designed to run on multiple platforms, so I don't want to introduce too
> much iSeries-specific stuff.
>
> > con =
> > DriverManager.getConnection("jdbc:db2:*local",
> > properties);
>
> I can get this to work, as I can the jdbc:db2://localhost form of the URL,
> and indeed, the version I'm accustomed which specifies the name of the SQL
> collection (= library) on the URL, like this:
> jdbc:db2://localhost/library-name.
>
> All well and good.  However, it seems to me that I ought to be able to do
> the same thing when using the toolbox driver with native optimisations.
So
> using a URL like jdbc:as400://localhost/library-name, after loading
> com.ibm.as400.access.AS400JDBCDriver, should work.  However, instead I get
> an SQLException saying "Password is *NONE" (see stack trace below).
>
> Now, we can tell our clients that they should use the native driver; but I
> think that both drivers ought to behave in the same way here, and that the
> native driver is doing the correct thing.  Others may disagree, of course.
> I would be particularly interested to hear from the Toolbox developers who
> sometimes post here; or anyone who has any ideas about how to get round
> this, of course.
>
> Note also that I get the same results when I call
> DriverManager.getConnection(url) as when I call
> DriverManager.getConnection(url, user, password) with null values for user
> and password, or with "*CURRENT" for user and password.
>
> Here's the stack trace when I use the Toolbox driver with native
> optimisations:
>
> java.sql.SQLException: The application server rejected the
> connection.(Password is *NONE.)
>       java/lang/Throwable.<init>(Ljava/lang/String;)V+4
(Throwable.java:85)
>       java/lang/Exception.<init>(Ljava/lang/String;)V+1
(Exception.java:33)
>
java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1
> (SQLException.java:34)
>
>
com/ibm/as400/access/JDError.throwSQLException(Ljava/lang/String;Ljava/lang/
> Exception;)V+66 (JDError.java:480)
>
>
com/ibm/as400/access/AS400JDBCConnection.setProperties(Lcom/ibm/as400/access
>
/JDDataSourceURL;Lcom/ibm/as400/access/JDProperties;Lcom/ibm/as400/access/AS
> 400;)V+10 (AS400JDBCConnection.java:2738)
>
>
com/ibm/as400/access/AS400JDBCDriver.prepareConnection(Lcom/ibm/as400/access
>
/AS400;Lcom/ibm/as400/access/JDDataSourceURL;Ljava/util/Properties;Lcom/ibm/
> as400/access/JDProperties;)Ljava/sql/Connection;+56
> (AS400JDBCDriver.java:807)
>
>
com/ibm/as400/access/AS400JDBCDriver.initializeConnection(Lcom/ibm/as400/acc
>
ess/JDDataSourceURL;Lcom/ibm/as400/access/JDProperties;Ljava/util/Properties
> ;)Ljava/sql/Connection;+365 (AS400JDBCDriver.java:698)
>
>
com/ibm/as400/access/AS400JDBCDriver.connect(Ljava/lang/String;Ljava/util/Pr
> operties;)Ljava/sql/Connection;+82 (AS400JDBCDriver.java:285)
>
>
java/sql/DriverManager.getConnection(Ljava/lang/String;Ljava/util/Properties
> ;Ljava/lang/ClassLoader;)Ljava/sql/Connection;+144
(DriverManager.java:512)
>
>
java/sql/DriverManager.getConnection(Ljava/lang/String;Ljava/lang/String;Lja
> va/lang/String;)Ljava/sql/Connection;+37 (DriverManager.java:172)
>
> 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
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>


This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WG. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.