File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Java Products and Servers and the fly likes DB2 needed on Application Server????? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "DB2 needed on Application Server?????" Watch "DB2 needed on Application Server?????" New topic
Author

DB2 needed on Application Server?????

Ketan Mohite
Ranch Hand

Joined: Feb 14, 2006
Posts: 45
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
Masoud Kalali
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

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 .


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Ketan Mohite
Ranch Hand

Joined: Feb 14, 2006
Posts: 45
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 agree. Here's the link: http://aspose.com/file-tools
 
subject: DB2 needed on Application Server?????