Working with additional data store and REST Add-on

Support
#1

I have a server side application where I used REST API add-on. Apart from the local database “mainDb”. I have two additional database connected to this application say, data store “ip” and “sf”. When I am reading any Entity in mainDb from postman it is working perfectly. But when I try to read any entity from additional data stores “ip” or “sf”, it fails with the following exception:

image

here is an example of entity defined for additional data store:


@DdlGeneration(value = DdlGeneration.DbScriptGenerationMode.DISABLED)
@JmixEntity
@Store(name = "ip")
@Table(name = "ArCustomer")
@Entity(name = "apis_ArCustomer")
public class ArCustomer {
    @Column(name = "CustId", nullable = false, length = 10)
    @Id
    private String cust;

    @Column(name = "AbcCategory", length = 20)
    private String abcCategory;

here is my application properties:

# Rest API
#==================================================================================================
# --- OAuth client registration (Auth Server) ---
spring.security.oauth2.authorizationserver.client.myclient.registration.client-id=my-client
spring.security.oauth2.authorizationserver.client.myclient.registration.client-secret={noop}my-secret
spring.security.oauth2.authorizationserver.client.myclient.registration.authorization-grant-types=client_credentials
spring.security.oauth2.authorizationserver.client.myclient.registration.client-authentication-methods=client_secret_basic

# optional: scopes (only add if you plan to pass scope=... in requests)
spring.security.oauth2.authorizationserver.client.myclient.registration.scopes=rest-api

# Use opaque tokens (reference) as the docs say
spring.security.oauth2.authorizationserver.client.myclient.token.access-token-format=reference
spring.security.oauth2.authorizationserver.client.myclient.token.access-token-time-to-live=24h

# Give REST roles to the OAuth client (so client_credentials tokens can call REST)
jmix.authserver.client.myclient.client-id=my-client
jmix.authserver.client.myclient.resource-roles=rest-minimal,rest-full-access,system-full-access

Is there anything specific I have to follow when I am working with additional data store from remote application using REST API?

#2

Hi,

I suppose that the application log should contain the full stack trace. Could you please attach it? Also, could you please provide a request example?

Regard,
Gleb