Skip to Content
author's profile photo Former Member
Former Member

JDBC to Oracle

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,

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2010 at 04:37 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2010 at 05:01 PM

    Thanks!

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

    Regards.

    Add comment
    10|10000 characters needed characters exceeded