Can anyone throw some light on leagcy databases? How do we access them through our java code?
Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
Franck Rasolo
Greenhorn
Joined: May 29, 2001
Posts: 21
posted
0
What type of databases are you talking about ? Do you mean data stores for which there isn't a standard API ? Franck Rasolo Independent Java Consultant London, UK
Frank, I think he is talking about DB2 and cics. Am I right, Prameet? Yes you can. You need the appropriate drivers. For non-standard databases for which there are no drivers written, the solution would be custom made, I think.
Sun certified , with the lowest score possible.
Franck Rasolo
Greenhorn
Joined: May 29, 2001
Posts: 21
posted
0
Originally posted by vasuma puljety: Frank, I think he is talking about DB2 and cics. Am I right, Prameet? Yes you can. You need the appropriate drivers. For non-standard databases for which there are no drivers written, the solution would be custom made, I think.
Well, I would be surprised if there wasn't any JDBC driver for IBM's DB2. As to connectivity with CICS, IBM (obviously) provides connectors for it. In fact, the whole concept of connectors for Enterprise Information Systems was originated by IBM, and later standardized with the J2EE Connector Architecture. Parmeet, what type of architecture does your application follow ? If it a J2EE application, you may want to take a closer look at WebSphere 3.5 (or greater) or WebLogic 6.x (with JCA support). Then, you would need to write a resource adapter for your legacy data store, and declare it in the deployment descriptor for your EJBs... I'll stop here, since I may be way off track by now ;-) Good luck Franck Rasolo Independent Java Consultant London, UK
Joel Cochran
Ranch Hand
Joined: Mar 23, 2001
Posts: 301
posted
0
Franck, You are right, there definitely are JDBC drivers for DB2. I don't know about the 390s, but for the AS/400 there are even 'Native' java drivers. Personally, I want to avoid the Native drivers because anything written with them would not be platform independent but they do exist. Just FYI, Joel ------------------ I'm a soldier in the NetScape Wars... Joel
Wait a minute, I'm trying to think of something clever to say...<p>Joel
Chris Behr
Greenhorn
Joined: Jun 12, 2001
Posts: 17
posted
0
I have written a intranet website that uses servlets to connect to a DB2 database on OS/390. The servlet is making a JDBC connection using a software package from IBM called DB2Connect. I'm not sure how we got the software or if you can get a demo version from IBM. I found the official IBM site at http://www-4.ibm.com/software/data/db2/db2connect/ If you have anymore questions let me know. ------------------
0
