RE: JDBC drivers are where ?? -- MIDRANGE-L


The toolbox (jt400.jar) is located at:

/QIBM/ProdData/Http/Public/Public/Jt400/lib


The following document tells you how to install it on your workstation:

http://as400bks.rochester.ibm.com/pubs/html/as400/v4r5/ic2924/index.htm?info
/java/rzahh/rzahnm09.htm


For additional java information, related to the AS/400, try www.rpg2java.com



John Taylor


> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Brad Stone
> Sent: Monday, July 23, 2001 6:50 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: JDBC drivers are where ??
>
>
> They should be there.  There should be a file on your system
> named jt400.jar which is the "toolbox" containing the AS/400
> DB JDBC drivers.
>
> You need to set your classpath to point at it, then all is
> good.  I know this sounds easy, but it's not until you get
> the hang of classpaths.  Think of them as library lists for
> java and it will come easier.  (but you may already know
> that.)
>
> As to where exactly they are on the AS/400, they're in the
> IFS somewhere.  I can't remember offhand.  I think in /QIBM
> root somewhere.  If you want, I can look, otherwise I know
> someone else will post.
>
> What I would suggest it to copy jt400.jar to your PC and do
> your java developement there.  It's much easier to manage
> and works just the same.
>
> On Mon, 23 Jul 2001 15:12:37 -0700
>  KirkG@PacInfoSys.com wrote:
> > Per the link
> > http://www-1.ibm.com/servers/eserver/iseries/toolbox/faqjdbc.htm#faqA1
> >
> >
> >                     What JDBC drivers does IBM provide
> > for the OS/400
> > database?
> >
> >                     IBM provides two different JDBC
> > drivers for the OS/400
> > database:
> >
> >                          The "Native" JDBC driver. This
> > is shipped as part
> > of the AS/400 Developer Kit for Java (57xxJV1). It is
> > implemented
> >                          by making native method calls to
> > the SQL CLI
> > (Call Level Interface). Consequently, it only runs on the
> > OS/400 JVM.
> >                          The class name to register is
> > com.ibm.db2.jdbc.app.DB2Driver . The URL subprotocol is
> > db2 .
> >
> >                          The "Toolbox" JDBC driver. This
> > is shipped as
> > part of the IBM Toolbox for Java (57xxJC1). It is
> > implemented by
> >                          making direct socket connections
> > to the database
> > host server. This happens to be the same route that the
> > Client
> >                          Access/400 ODBC driver takes.
> > However, Client
> > Access/400 is NOT required. The Toolbox runs on any JVM.
> > The
> >                          class name to register is
> > com.ibm.as400.access.AS400JDBCDriver . The URL
> > subprotocol is as400 .
> >
> >
> > While I have both JC1 and JV1 installed on my 4.4 box
> > only the second
> > driver is where the data above shows. On my client's 4.5
> > box neither
> > driver is at the above location. My box has the jdk 1.1.7
> > the 4.5 has
> > 1.1.8 and 1.2 jdk's
> >
> > I'm new to installing and using Java and JDBC so... who
> > uses this, are
> > there extra steps above installing JV1 or JC1 to get the
> > JDBC drivers
> > loaded and where do they end up?
> >
> > Thanks
> > ---------------------------------
> > Kirk Goins
> > IBM Certified AS/400 Technical Solutions
> > DataMirror High Availability Certified
> > Pacific Information Systems - An IBM Premier Business
> > Partner
> > 503-674-2985             kirkg@pacinfosys.com
> > "WE KNOW TECHNOLOGY"
> > ---------------------------------
>
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---