connection pooling in Websphere

[Namrta Pandey]

Hi all,

I am new to Websphere.Can somebody tell me the steps I am following to create connection pool are right or wrong. because I'm getting the following exception when I test the connection.(I am trying to connect to oracle 10g)

Steps:
1. JDBC-> JDBC Provider ,then provided all information there.
2. Create Data Source.
and then tested the connection in websphere only it is giving the following error:

The test connection operation failed for data source data1 on server server1 at node wksit004Node01 with the following exception: java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433

Thanks in advance.

Namrta

[Naveen Sundaram]

Could you please be more specific regarding the server ,port and other properties
Check whether you have the server name in your host file.

Before testing ,try it with a client software like toad.