How to install MSSQL jdbc driver on iSeries

[John Gilmore-Baldwin <jbaldwin@xxxxxxxxxxxxxxx>]

I'm writing a small java program that will be called from a CL. It 
accesses MSSQL server to compare data against a file on the iSeries.

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). Is there a ext directory I 
can use?

In the interim, I've added the jdbc driver classes into my program's 
jar file to work around the problem. But a couple of specific 
questions:

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?

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

Sorry if this is documented and I'm missing it. I'm fairly new to java 
on iSeries. Any pointers to documentation are most welcome.

John Gilmore-Baldwin