Problem in Jdbc connection

Dear All

I am using oracle

IntegrationServer\lib\jars install the

And created the userName and password in oracle database and granted the DBA and connection, resource persmisson also.

in Jdbc connection mention the parameters for userName and password and also jdbc:wm:oracle://localhost:1521;SID=orcl.

even though its throwing error like.

Test of TN Failed
[wm-cjdbc34-0042][Oracle JDBC Driver]Error establishing socket to host and port: localhost:1521. Reason: Connection refused: connect

Thanks in advance

With Regards

The root of the problem was that they had an improperly encrypted password in the file - after using the webMethods Encryption Utility and updating the file with a properly encrypted pwd the problem will get solved.

Vishal Chaudhary

Confirm that you have the DB running on your machine (localhost) and it is listening for connections on port 1521.