JDBC system on EP 6.0.

[Former Member]

Hi all,

I have created the jdbc system for oracle database (this is the database of portal) in ep 6 sp 11 . But we are getting connection test result negative . we are giving the following connection parameters in system.

Connection URL = jdbc:oracle:thin:@ep62:1527:SAA

Driver Class Name = oracle.jdbc.OracleDriver.

(above values i have taken from the file DB_connect.properties on portal server)

I have created the system alias and mapped the userid password . But the connection test is negative.

Am i missing something?

rgds

Rajendra

[Former Member · Accepted solution]

Hi Rajendra,

Previously when I tried to create an alias to connect MS SQL, I made the following mistakes. Try to compare and solve your problem:-

Previously :

jdbc:microsoft:sqlserver://localhost:1433

And it was supposed to be:

jdbc:sap:sqlserver://localhost:1433

As well as the connector, I changed from:

com.microsoft.jdbc.sqlserver.SQLServerDriver

into:

com.sap.portals.jdbc.sqlserver.SQLServerDriver

Thanks,

Deep Chakrabarti

[venkata_ramisetti]

Hi Rajendra,

You have to use the following properties.

Driver: com.sap.portals.jdbc.oracle.OracleDriver

URL: jdbc:sap:oracle://<server>:<port>;SID=<sid>

e.g. jdbc:sap:oracle://myoracleserver:1521;sid=PIL

Please go through the OSS note 773401 for more details.

Thanks,

Ramakrishna