RE: AccessControlException while trying to use a AS400JDBCConnect ionPool on V5R1 & JDK 1.4

Martin, David

I can definitely connect to a local as400 without a userid or password using
the toolbox driver, 
com.ibm.as400.access.AS400JDBCDriver,

with this URL, "jdbc:as400://", no problem at all, 

or "jdbc:db2:*local", for native driver

cheers
Colin.W
 
Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: McCallion, Martin [mailto:martin.mccallion@xxxxxxxxx] 
Sent: 08 June 2004 15:20
To: 'Java Programming on and around the iSeries / AS400'
Subject: RE: AccessControlException while trying to use a AS400JDBCConnect
ionPool on V5R1 & JDK 1.4


Colin Williams wrote:

> but I would have thought that the userid and password would
> be specified
> wherever you configure the datasource (server.xml maybe)
> 
> Try removing the *CURRENT and just using the server name, I
> think if it's a
> local connection it should work (theory!)

This seems similar to the discussion we had recently (thread "Connecting to
the iSeries DB using a user with no password") (but may not be, of course).
If it is, then what you describe may work with the native driver, but not
the toolbox, as I found.  Though I am thinking of trying it with the latest
version of JTOpen, to see whether anything has changed.

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.