Re: How to install MSSQL jdbc driver on iSeries

Hi,

just put the jar with the Driver anywhere, you want and add the jar to the 
classpath. You could call your program from a CL like this:
 PGM
     DCL   &CMD  *CHAR (256)
     CHGVAR &CMD (                                                   +
              'java -classpath '                                  !! +
            /* your application directory or jar              */+
              '/home/bender/java:'                                !! +
            /*  your MSSQL driver              */+
              '/yourPath/yourDriverclasses.jar:' !! +
            /* the toolbox driver               */+
              '/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar'    !! +
            /* your mainClass                */+
            /* myMainClass            */+
                 )
     SBMJOB CMD(                                                     +
                QSH CMD(                                             +
                        &CMD                                         +
                       )                                             +
               )                                                     +
            JOB(MSSQLSTUFF)
ENDPGM

I would not recommend to use any plstform dependent stuff, if not really 
needed.

Dieter

On Donnerstag, 20. Mai 2004 06:51, John Gilmore-Baldwin wrote:
> 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
>
> _______________________________________________
> 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.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de
eMail dieter.bender@xxxxxxxxxxxx