Skip to Content
0
Former Member
Sep 04, 2006 at 02:18 PM

Cry of desperation... JDBC in Portal not working

9 Views

I am already puzzling a few days....

I defined a JDBC Connector in the Visual Administrator.

The definition there are ok, because I can connect perfectly using the test servlet at http://sapserver:50100/TestJDBC_Web/TestJDBCPage.jsp.

The next step was defining a system in my landscape. I followed the instructions in the document "How To... Configure a BI JDBC System for Visual Composer"

I am using these properties:

CodeLink = com.sap.portal.systems.bi.SAP_BI_JDBC

ConnectionFactoryClass = SDK_TESTDB

ConnectionUrl = jdbc:jtds:sqlserver://sapserver:1433;databaseName=TestDb

(this url is the same as in Vis. Administrator)

Driver Class Name = net.sourceforge.jtds.jdbc.Driver

Fixed Catalog = TestDb

Fixed Schema = dbo

System Type = SAP_BI_JDBC

User Mapping = admin, user

I am logged in as Administrator, so I added the login credentials at the User Mapping page of the Administrator user.

When I use Connection Test function from the portal I get the following messages:

Retrieval of default alias successful

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

What can I do to solve this problem?

I have already tried so many changes in the properties...

It is driving me on the wall !!

Where can find a logfile to see what is going wrong?