Re: JDBC drivers are where ??

["Brad Stone" <brad@xxxxxxxxxxxx>]

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"
> ---------------------------------

Bradley V. Stone
BVS.Tools
www.bvstools.com
+---
| 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
+---