Legacy Databases

[rani bedi]

Can anyone throw some light on leagcy databases?
How do we access them through our java code?

[Franck Rasolo]

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

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

[Franck Rasolo]

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]

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

[Chris Behr]

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

[Anil Vupputuri]

U can find some info at these forums

One
Two.


[This message has been edited by Anil Vupputuri (edited June 15, 2001).]

[rani bedi]

Thanks everyone