Problem in creating a JDBC System on VC7.1 portal ( CE7.1 SP3)

[Former Member]

I have a problem in creating a JDBC System on VC7.1 portal (CE7.1 SP3)

I get the following error:

Test Details:

The test consists of the following steps:

1. Retrieve the default alias of the system

2. Check the connection to the back-end application using the connector defined in this system object

Results

Default alias retrieved successfully

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

Could you please let me know if there are any guides on SAP Library; I was not able to find any documentation nor any threads discussing this on VC7.1

Although, I saw this thread

which says that VC7.1 can connect to SAP backend

and web services only, and there is no direct connection to the db.

Help needed please.

[Former Member · Accepted solution]

Hi Srivani,

Has Shai Kfir said in the thread that you linked to, JDBC connection are currently not supported in CE 7.1. They will be supported with Enhancement Pack (EhP) 1 or 7.1.1.

Regards,

Oliver

[Former Member]

Hi All,

Thanks for the replies.

Now I have the system configured.

Regards,

Srivani

[Former Member]

Hi Srivani,

Are you able to access this system from Visual Composer?

Regards,

Shai

[Former Member]

Hi,

I have configured an SQL system in portal content (not oracle system) but I'm not able to see this system in VC (in task panel->Search dropdown.)

Help required please.

-Srivani

[Former Member]

Hi

This is because SQL is not supported by Visual Composer 7.1.

It was supported in 7.0 and it will be supported in 7.1.1.

Regards,

Shai

[Former Member]

Hi,

Atleast, is Oracle-JDBC System supported in VC7.1 and CE7.1

Regards,

Srivani.

[Former Member]

Hi Shai,

When is 7.1.1 expected to release?

Best regards,

Dharmi

[Former Member]

Hi Dharmi

Here is a quote of Dafna's post in [another thread in this forum|]

CE7.1.1 will be released at September 2008 for ramp-up customers.
There are many improvements and new capabilities in the new release of Visual Composer for CE7.1.1. Among the new features you can find:
The missing features from Visual Composer 7.0 (Html view, portal Eventing support (EPCM), JDBC, Undo/Redo, and more..)
Many layout & modeling improvements
Additional ALV table functionality - export to Excel, switch to chart, configure ALV behavior at design time
Integration of Visual Composer in Eclipse - additional entry point to the Visual Composer models from the NWDS. This integration provides the option to add a WD component (in case of missing functionality in Visual Composer), as a black box component to the Visual Composer model. Right-clicking the component will open the Web Dynpro perspective for creating/modifying the component.

Regards,

Shai

[Former Member]

Hi Shai,

Thank you for your reply.

One strange thing with VC and JDBC, that I observed is if I create a JDBC connection form the portal (not from NWA), although the test connection, doesn't succeed, I see that in search of the Visual composer.

Best regards,

Dharmi

[Former Member]

Hello Srivani,

Please follow this blog to create a JDBC connection

[Connecting an Application to an External Database in SAP NW CE 7.1|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/8675] [original link is broken] [original link is broken] [original link is broken];

Yesterday we successfuly created a JDBC connection with the help of it.

Good luck,

Dharmi

[Former Member]

Hi Sreevani,

I think from ur results ,u did some mistake in the Usermapping for the JDBC System.

Do the usermapping for ur system with the System login credentials

i hope this will helpful

Regards,

Govindu