https://github.com/UnionVMS/UVMS-SalesModule-ECBPROXY
...
JMS-Queue dependencies
Name | JNDI name | Description |
|---|---|---|
UVMSSalesEcbProxy | java:/jms/queue/UVMSSalesEcbProxy | Request queue to the Sales ECB Proxy |
UVMSSalesEcbProxyConfig | java:/jms/queue/UVMSSalesEcbProxyConfig | Queue to sync with config |
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<datasource jta="true" jndi-name="java:/jdbc/uvms_salesecbproxy" pool-name="uvms_salesecbproxy" enabled="true" use-ccm="true">
<connection-url>jdbc:postgresql://dbunid02/duvms?defaultSchema=salesecbproxy</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>postgresql</driver>
<security>
<user-name>salesecbproxy</user-name>
<password>salesecbproxy</password>
</security>
</datasource>
|
The sales ecb proxy lets you free in choosing the schema name.
On the other side, this also means that the schema name is not included in queries, so make sure that the schema is on the user's search path.
Whitelist the url
When you use the default ECB webservice, make sure to whitelist: http://sdw-wsrest.ecb.europa.eu/service/data/EXR/D..EUR.SP00.A
...