Question Re: Error while consuming Northwind service into CAP (java) application in Technology Q&A

Error while consuming Northwind service into CAP (java) application

Poorva_Sonawane — Fri, 20 Jan 2023 06:40:46 GMT

Hello,

I am trying to import and mock external service (Northwind) into my bookstore app (java) by following steps given in: https://cap.cloud.sap/docs/guides/using-services

I followed below steps:

1. import API definition using cds import command

cds import ~/Downloads/NorthWind.edmx

It created these files in srv/external folder

Configured remote service in application.yaml and added dependency to pom.xml

When running using cloud profile,

I get ""Failed to start a new transaction"" error to access entities under Northwind services

2. Mock remote service as OData service:

- Added mocked spring profile in application.yaml as below:

- Added DestinationConfiguration.java file as follows:

When running app with mocked profile :

mvn spring-boot:run -Dspring-boot.run.profiles=default,mocked

I am getting this error:

Can someone help?

Regards,

Poorva.

Re: Error while consuming Northwind service into CAP (java) application

marcbecker — Fri, 20 Jan 2023 10:01:37 GMT

Your application.yaml is not valid. Under application.services and remote.services we expect a Map or array of services and not directly a service definition. You need to rewrite it like this:

cds:
  application.services:
  - name: "NorthWind-mocked"
    model: "NorthWind"
    serve.path: "NorthWind
  remote.services:
  - name: NorthWind
    destination:
      name: "northWind-mocked"

Re: Error while consuming Northwind service into CAP (java) application

Poorva_Sonawane — Mon, 23 Jan 2023 10:59:37 GMT

Hi marcbecker,

Thanks for the answer.

Now I am able to run the application locally.

But when I click on service which extends external entity, I get this error : "Error executing the statement"

I have defined entity "clothes" which extends external entity "Products" from mocked Northwind service as follows

Also added "ClothStore" service which containing "Clothes" entity

When I run application on localhost and click on clothes entity under clothstore service,

I get 500 error with message "Error executing the statement".

I see below error in console,

Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/view CLOTHSTORE_CLOTHES in schema 829841A637474F279F717E05EC123891: line 1 col 118 (at pos 117)

Also,

in schema.sql, I don't find any table generated for that entity.

Could you please help me resolving this issue ?

Regards,

Poorva.

Re: Error while consuming Northwind service into CAP (java) application

marcbecker — Mon, 23 Jan 2023 11:43:22 GMT

This seems to be the default behaviour of delegating the query to the database. If you want to delegate incoming API calls to the external service you need to write a custom ON handler for this.

I'd recommend you read through our "Consuming Services" cookbook here: https://cap.cloud.sap/docs/guides/using-services
This case is described exactly here: https://cap.cloud.sap/docs/guides/using-services#expose-remote-services