GeeCON Prague 2014*
The moose likes JDBC and the fly likes Legacy Databases Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Legacy Databases" Watch "Legacy Databases" New topic
Author

Legacy Databases

rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
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
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


<i>Franck Rasolo<br />Independent Consultant<br />London, UK</i>
vasuma puljety
Ranch Hand

Joined: Jun 01, 2001
Posts: 35
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
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
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
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
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
U can find some info at these forums

One
Two.


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


SCJP 1.5, SCEA, ICED (287,484,486)
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
Thanks everyone
 
GeeCON Prague 2014
 
subject: Legacy Databases