RE: Driver for NT SQL Db?

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

Ill try this too.

Right now I had an amazingly successful attempt using inet OPTA 2.05.  moved
the JAR file into a dir, changed the classpath, and it worked right away.  I
couldn't believe it. 

Data access to the SQL DB servers seems much faster than hitting AS/400
data, though.

> -----Original Message-----
> From: Shawn Church [mailto:shawn@boxity.com]
> Sent: Wednesday, March 21, 2001 11:45 AM
> To: JAVA400-L@midrange.com
> Subject: Re: Driver for NT SQL Db?
> 
> 
> I have had good luck with DB2 Universal Database for NT, but 
> any database
> which provides JDBC drivers should work fine, such as MySQL, 
> etc.  My '400
> connects to my NT database routinely, and it works very 
> reliably.  Early on
> (about a year and a half ago) I had some problems with the 
> isolation level
> which I had to contact IBM database support to resolve (these 
> may not be a
> problem in V4R5, but were in V4R4).  Here is a snippet which 
> works (notice
> the comments):
> 
>     // This is necessary due to a java bug on the AS/400.  If this
>     // is not done, we will fail with an SQL package error 
> (bind error).
>     Properties db2Properties = new Properties();
>     db2Properties.put ("user", "db2admin");
>     db2Properties.put ("password", "mypassword");
>     db2Properties.put ("transaction isolation", "read uncommitted");
>     db2Properties.put ("cursor hold", "false");
> 
>    // URL to remote database.  webdata must exist in the AS/400
>    // relational database (wrkrdbdire).
>     String urldb2 = "jdbc:db2:webdata";
> 
>     // The same db2driver class will work for the local db2/400
>     // as well as for the remote DB2 UDB database.
>     // This is the native driver.  If this code is ported to
>     // a non-local host, then the toolkit driver should be used:
>     //   Class is com.ibm.as400.access.AS400JDBCDriver",
>     //  URL subcomponent is jdbc:as400
>     Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
> 
>     // Connect to UDB
>     db2Conn = DriverManager.getConnection(urldb2, db2Properties);
> 
> Shawn
> 
> ----- Original Message -----
> From: "Stone, Brad V (TC)" <bvstone@taylorcorp.com>
> To: <JAVA400-L@midrange.com>
> Sent: Wednesday, March 21, 2001 10:17 AM
> Subject: Driver for NT SQL Db?
> 
> 
> > Interested in what driver folks use for attaching to an NT 
> SQL database.
> > Any info is appreciated.  For example, one that comes with 
> JDK, or it has
> to
> > be downloaded, etc.
> >
> > Right now I'm not worried about speed, I just want to see 
> if I can attach
> to
> > one on our network.  I am using the "properties" method 
> explained a while
> > ago here where I have a db properties file that looks like:
> >
> > driver=com.ibm.as400.access.AS400JDBCDriver
> > url=jdbc:as400://machine
> > user=user
> > password=password
> >
> > So Im really looking for something as easy as replacing the 
> driver and url
> > properties in the file for the particular machine (I plan 
> on having one db
> > properties file for each machine that I want to attach to).
> >
> > Thanks!
> >
> > Brad
> > +---
> > | This is the JAVA/400 Mailing List!
> > | To submit a new message, send your mail to JAVA400-L@midrange.com.
> > | To subscribe to this list send email to 
> JAVA400-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner: joe@zappie.net
> > +---
> >
> 
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: joe@zappie.net
> +---
> 
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---