Hello Richard..
Now I just tested the all lowercase (sample) and all uppercase (SAMPLE)
name of database
and it works or both the cases.
It showed some strange behaviours..sometime back.
AN hour ago I tried to compile using all lowercases and it didn't find the
database.
then I opted for all Uppercase DATABASE name and it worked...
Hence I would Like to take one of my point back that
Database name should be defined in Uppercase. (wrong >>> either all upper
or all lower)
Thanks for invoking this point...
------------------------------------------------------------------------------------
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Ryszard Lach
<[EMAIL PROTECTED]> To: Tomcat Users List
<[EMAIL PROTECTED]>
07/31/2002 cc: (bcc: Nishant Awasthi)
02:49 PM Subject: Re: AW: Connection between
TOMCAT
Please and DB2 (RESOLVED)
respond to
"Tomcat Users
List"
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]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
