Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Legacy Databases

 
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anyone throw some light on leagcy databases?
How do we access them through our java code?
 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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

 
Ranch Hand
Posts: 301
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
------------------
 
Ranch Hand
Posts: 527
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
U can find some info at these forums

One
Two.


[This message has been edited by Anil Vupputuri (edited June 15, 2001).]
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks everyone
 
Do not set lab on fire. Or this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic