java DB2 program
i log in my mainframe environment using my user id and password ..
After that i go to QMF and fire my DB2 queries...
I want to read the DB2 tables , through my JAVA program..can anybody please guide on how i can od the connection to the DB2 database and what drivers are required..i am using Java 1.4
[319 byte] By [
anaik100a] at [2007-10-2 14:25:34]
DB2 is just another database, that you access via JDBC. There's nothing more to say to add to what DrClap already said, other than you'll need to know what the JDBC URL will look like to connect to that database. So add DB2 to your search string.
> My speicifc questions aredid you hit Google? I did, and it gave me: http://sis36.berkeley.edu/projects/streek/howto/testCallProcedureJava.html http://www.db2mag.com/story/showArticle.jhtml?articleID=23902546 http://datacentral.sdsc.edu/sample.javaLee
tsitha at 2007-7-13 12:45:07 >
Well, when I wrote my application using jdbc, I had to scrounge the net for free drivers.
DriverManager.registerDriver(new DB2Driver());
Connection conn = DriverManager.getConnection(url, username, password);
the url string structure should be documented with whatever driver you download. I prefer the 3 argument version of getConnection, but many drivers will allow you to put the username and password in the url itself.
