Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / February 2008

Tip: Looking for answers? Try searching our database.

JDBC driver fro DB2?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Usenet User - 28 Feb 2008 00:08 GMT
Java web application, based on J2EE  and JBOSS 4.0.0.2, installed on
Windows 2003 Server

Database: DB2 on AS/400 iSeries V5R3M0

Which JDBC driver can be used? One choice is DataDirect, but they are
*too* expensive.

TIA!
Saml - 28 Feb 2008 04:04 GMT
Google for JT400.JAR.

Sam

> Java web application, based on J2EE  and JBOSS 4.0.0.2, installed on
> Windows 2003 Server
[quoted text clipped - 5 lines]
>
> TIA!
Usenet User - 28 Feb 2008 18:46 GMT
Isn't jt400.jar for Web Sphere only?

(Sorry, I am not really familiar with these technologies or Java.)

>Google for JT400.JAR.
>
[quoted text clipped - 9 lines]
>>
>> TIA!
Karl Hanson - 28 Feb 2008 18:52 GMT
> Isn't jt400.jar for Web Sphere only?
>
> (Sorry, I am not really familiar with these technologies or Java.)

No.
www.ibm.com/systems/i/software/toolbox/faqjdbc.html

--
Karl Hanson
Dr.UgoGagliardelli - 28 Feb 2008 18:21 GMT
il 28/02/2008 1.08, Scrive Usenet User 40447544:
> Java web application, based on J2EE  and JBOSS 4.0.0.2, installed on
> Windows 2003 Server
[quoted text clipped - 5 lines]
>
> TIA!
You can use both jt400.jar coming from client access or from jtopen,
that's the equivalent open source project.

Signature

Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'

Usenet User - 28 Feb 2008 18:50 GMT
>il 28/02/2008 1.08, Scrive Usenet User 40447544:
>> Java web application, based on J2EE  and JBOSS 4.0.0.2, installed on
[quoted text clipped - 8 lines]
>You can use both jt400.jar coming from client access or from jtopen,
>that's the equivalent open source project.

What about IBM's DB2 UDB JDBC Universal Driver? Can that one be used?

Thanks!
Dr.UgoGagliardelli - 29 Feb 2008 08:52 GMT
il 28/02/2008 19.50, Scrive Usenet User 34260568:

>> il 28/02/2008 1.08, Scrive Usenet User 40447544:
>>> Java web application, based on J2EE  and JBOSS 4.0.0.2, installed on
[quoted text clipped - 10 lines]
>
> What about IBM's DB2 UDB JDBC Universal Driver? Can that one be used?
It's somewhat uncomfortable. It uses a sort of database driver installed
on the client. jt400 AS400JDBCDriver class is very flexible, it can be
used as a standard jdbc driver but it has it's own mathods too.
A typical connection could be:
Connection con = new AS400JDBCDriver().connect(new AS400(host, user,
password), sqlProperties, defaultSchema));
where sqlProperties and defaultSchema are optional.
Signature

Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.