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