JDBC to Oracle

[Former Member]

Hello,

I am trying to connect BI system to external Oracle database using JDBC.

I have configured the system using the steps of the guide: "How to transfer data from SYBASE to BI using BD Connect"

(http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c0d70315-958f-2a10-bc88-eb91e36f4037&overridelayout=true)

But, when I execute the Test JDBC, I get the following error:

500 Internal Server Error SAP J2EE Engine/7.00

Application error occurred during request processing.

Details: java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC

In the log file:

#1.5 #001E4F1977D000770000006500000A8800047A5DB92CB73C#1260442864125#/Applications/BI/UDI#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.ip.bi.sdk.dac.connector.relational.CommonConnection#J2EE_GUEST#0##n/a##4f436ad0e57b11de85f5001e4f1977d0#SAPEngine_Application_Thread[impl:3]_22##0#0#Error#1#com.sap.ip.bi.sdk.dac.connector.relational.CommonConnection#Plain###Exception during SAPQuery connection: 'ashost' is missing#

#1.5 #001E4F1977D0006A000000AB00000A8800047A5DBA9E4095#1260442888343#/Applications/BI/UDI#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.ip.bi.sdk.dac.connector.relational.CommonConnection#J2EE_GUEST#0##n/a##5db2ca70e57b11de8a4a001e4f1977d0#SAPEngine_Application_Thread[impl:3]_27##0#0#Error#1#/Applications/BI/UDI#Plain###java.sql.SQLException: The url cannot be null#

#1.5 #001E4F1977D0006A000000AD00000A8800047A5DBA9E4553#1260442888359#/Applications/BI/UDI#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection#J2EE_GUEST#0##n/a##5db2ca70e57b11de8a4a001e4f1977d0#SAPEngine_Application_Thread[impl:3]_27##0#0#Error#1#/Applications/BI/UDI#Plain###com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source#

I have been looking for a solution during some weeks but I have not found it.

Please, anybody could help me with this problem?

Thanks,

[Former Member · Accepted solution]

For 'ashost' is missing#, please refer the

OSS Note - 1058327:

If the system cannot locate the file sapnwrfc.ini or a destination entry in the file, the system issues the error message "no SAP ErrInfo available". This was replaced by the message "Parameter ASHOST, GWHOST or MSHOST is missing.".

Note 831162, is also worth looking.

[Former Member]

Thanks!

The problem is solved. I was using a wrong "CLASSPATH" in Environment Variables.

Regards.

[Former Member]

Hi Carmelo,

I'm facing the same problem. Could you tell me where I should set the CLASSPATH variable on UNIX?

thx,

Jane