• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connection pooling in Websphere

 
Namrta Pandey
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic