Help coderanch get a
new server
by contributing to the fundraiser
  • 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

DB2 needed on Application Server?????

 
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi everyone!!!

I hope this is the right forum to post this topic.

I have a Java based web aplication running on an Application Server which uses Websphere as Web Server 4.1.
Application is using database which is on Database sever.
Database Engine is DB2 7.0
My concern is that, to make an application working, I need to install DB2 on Application server as well, though the database is on DB Server.

Can anyone guess the cause for the issue.I dont want to install DB2 on an Application Server.

Thanks & Regards,
Ketan
 
Author
Posts: 531
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
can you please tell us that in case you do not install the db2 on the application server machine , what exception you get in the log file ?

I do not think there is a need to install the db2 database in the client side (application server side) , you just need to copy some of jar files from db2 directory in your application server common lib folder, i do not remember exactly the jar files name , one of them is the license file and the other is its jdbc driver.

you may look into db2_home/java or db2_home/lib .
 
Ketan Mohite
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Masoud,

Thanks for the reply.

Let me put my problem in little detailed manner.
In Websphere Admin Client settings, we have an option of providing the JNDI name, database name etc. and not the actual DSN name.

It picks up the database from DB2 Control center database navigator on left hand side.

So the question is rephrased as , how to configure the DB2 database in websphere 4.0 with out DB2 on same machine?

Thanks & regards,
Ketan
 
I think I'll just lie down here for a second. And ponder this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic