On Wed, Jul 31, 2002 at 01:26:07PM -0400, [EMAIL PROTECTED] wrote: > > Hello all, > > I finally resolved the problem... > Problem lied in the as everyone mentioned Connection URL > Earlier I was using url = "jdbc:db2:sample" > Then I changed it to follwing > and everything worked fine... > > String url = "jdbc:db2://xxx.xxx.xxx.xxx/SAMPLE"; > > where xxx.xxx.xxx.xxx is the IP address of my machine. > > Three Important things: > 1. Database name should be all in capital letters.( strange but yes) > 2. If you notice I never specified any PORT NUMBER... (I don't know why it > doenot need any port number...though ealier I was using 50000 as listening > port for DB2 instance DB2MPP but it didn't work) > but without port number it worked...
It was strange to me too. Unlike other databases DB2 requires DB2 Client to be installed on machine running application server (here: tomcat); then you have to catalog the (possibly remote) database locally and you can connect to it using the name it was cataloged as. Richard. -- "First they ignore you. Then they laugh at you. Then they fight you. Then you win." - Mohandas Gandhi. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
