URGENT SCRIPT LOGIC required

Shell Programming and Scripting
1

Hello friends,

It will be great if we found some way to check this our:

we have some databases (teradata and oracle).
our applications(in java on weblogic) are using connection pools of these databases.

we have a pair of userID and password for every pool.

If we have any logic to test these pair of credentials thru unix script.

eg :

Connection pool Name: Test
COnnection pool URL:
jdbc:teradata://t61edw.abc.com/CHARSET=UTF8,TMODE=TERA

userID: TEst123
Password: 1234

Please help me to check this .

Looking for a try from all of my friends.

Regards,
Nimish

2

hi,

base on your example, what kind of result you are expecting, pls provide.

3

Thanks Cherry !!

Basically i just want to check that the credentials(userId and password)
for the connection pools is working or not.

So a text message or something to intimate about the status s OK with me.

Regards,
Nimish