Problem with configuring Data server for Oracle DB

[Former Member]

Hi,

We have xMII 12.0.3 and Oracle 10.2.0.2.0 (10g Release 2) installed on the same machine. We created a user for oracle and using sqlplus from my machine, I created a table on the DB. Then, I downloaded "ojdbc14.jar" for oracle 10.2.0.2.0, uploaded and deployed it on the xMII portal. Then I configured data servers -> new->IDBC and gave following details:

JDBC driver: oracle.jdbc.driver.OracleDriver

username: OracleUser

password: OraclePwd

Server URL: jdbc:oracle:thin:@<server-path>:1527:<oracle-instance>

Validation query: select sysdate from dual;

When I save it and click on status, it says "Pending". From past 2 days the status is "pending" only.

To check whether my configuration and driver are correct, we wrote a java program and gave the same configuration details and we are able to execute the program without any error.

I am not able to figure out why xMII is not able to connect to Oracle DB. I have also tried giving "localhost" in place of <server-IP. but even that dint help.

Please Help.

Thanks in advance,

Prasanna

[prasanna_vittal]

My Problem got solved. Instead of server IP , I used oracle host string.