Re: How to install MSSQL jdbc driver on iSeries -- JAVA400-L

Thanks all. I guess my problem was in trying to combine the -jar parameter with the -classpath parameter to the java command. Once I got away from that and included my program jar in the classpath and invoked the class name, it worked.

Now that I know how to use the -classpath properly, there are no problems. (The sysadmin objected to using the ext directory method, so I had to learn a new way to do things.)

Thanks again.

On May 20, 2004, at 1:47 AM, McCallion, Martin wrote:

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