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

Failed to connect Sybase to BI via UD connect , JDBC connect

Hi,

I try to connect Sybase and BI wih using JDBC connection based on SAP Guides :

How to Transfer Data from SYBASE to BI Using UD Connect.pdf

How to Configure UD Connect on the J2EE Server for JDBC Access to External Databases.pdf

Then I try to test JDBC connection with Visual Composer by using URL http://<server>:<port>/TestJDBC_Web/TestJDBCPage.jsp

and I try to test "SDK_JDBC" and click Check Connections, it is gives me an error

500 Internal Server Error

SAP J2EE Engine/7.00

Application error occurred during request processing.

Details:

java.lang.NoClassDefFoundError: com.sap.ip.bi.sdk.dac.connector.odbo.impl.Connection (initialization failure)

Exception id: 00145E74A198006200000AA0000B91A6000482E7D9CDD471

The configuration that I've set :

1. JCo RFC Connector

program ID :BIdev_PORTAL_BID

gateway Host : bidev

gateway service : sapgw00

application server host : bidev.smr.com

user : j2ee_admin

2. in RFC destination in BW (SM59) :

program ID :BIdev_PORTAL_BID

gateway Host : bidev

gateway service : sapgw00

3.Driver :

Driver name : SYBASE

add 4 files : jconn3.jar, jTDS3.jar,jconn3d.jar, jTDS3d.jar

4.Connector container :

BI_JDBC_CONNECTOR : reference : library:SYBASE

5.Properties tab :

Driver name : com.sybase.jdbc2.jdbc.SybDatasource

URL:jdbc:sybase:Tds:190.165.0.1:2368?map

username : username in database map

password : password

Then I run smoke test URL http://190.165.0.1:2368/TestJDBC_Web/TestJDBCPage.jsp

I haven't configure setting environment JDBC_HOME and CLASSPATH on J2EE visual composer, I don't know where to set, could somebody help me with these issues..

Thanks,

Jane

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2010 at 01:46 AM

    Hello Jane,

    We are trying to connect BI 7.0 (AIX 5.3,Oralce10g) to MS-SQL Server 2005 using UD connect.

    We are receving the similar error message "Application error occurred during request processing.

    Details: java.lang.NoClassDefFoundError: com/sap/ip/bi/sdk/dac/connector/odbo/impl/Connection

    Exception id: [00096B6BFB820056000003F10008F062000488165C099206]"

    How did you resolve the issue?

    Did you set the parameters CLASSPATH and JDBC_HOME?

    if so, what was the values you provided for the two parameters ?

    I look forward for your reply.

    Regards,

    Wahab.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2011 at 09:49 PM

    This looks old but it looks like here is your problem...

    Your driver name does not correspond to the version of the driver file you load. You load the jconn3.jar (notice the 3). Then you use com.sybase.jdbc2.jdbc.SybDatasource (notice the 2).

    This is why you are getting the class not found error, you need to fix the driver name to match the driver name inside the jconn3.jar.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.