RE: How to install MSSQL jdbc driver on iSeries

["McCallion, Martin" <martin.mccallion@xxxxxxxxx>]

John Gilmore-Baldwin wrote:

> Where should I put the jdbc driver? On other platforms, I've put the 
> driver in the java extensions directory, but "Q" directories are 
> supposed to be off limits for user stuff (hence 
> /QIBM/UserData/Java400/ext/ can't be used).

I think it's OK to put user data in the UserData subtree, even though it's
under QIBM.  I've never used the ext directory mechanism, though: I always
put drivers and other third-party jars in a directory of my own choosing and
make sure they're on the classpath at runtime.

> 1. If I avoid my workaround and avoid the /QIBM directories, 
> no matter 
> what I do with classpath, I always get an error "No suitable driver 
> found" when I try to connect to MSSQL. What is the right way to set 
> classpath?

The most common way is to set the CLASSPATH environment variable.  You can
do this in a couple of ways.  Since you're running your Java program from
CL, I'm assuming you are calling it with the native JAVA command.  In which
case the simplest way is probably to include an ADDENVVAR command in jour
CL, before the JAVA command.  You could also specify the classpath on the
relevant JAVA command parameter itself.

> 2. What is the difference between UserData and ProdData in the /QIBM 
> directory?

As I said above, as far as I know, UserData is for user data ;-)  Though how
that is defined, I don't know.

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