bdeboe / isc-datafest Goto Github PK

To make docker-compose build equivalent to docker build --tag iris-datafest, it's needed to include the line:

image: iris-datafest in the definition

version: '3.6'
services:
iris-datafest:
build:
context: .
dockerfile: Dockerfile
image: iris-datafest
container_name: iris-datafest
command: --check-caps false --ISCAgent false
restart: always
hostname: iris
ports:
- 41773:1972
- 42773:52773
- 8080:8080

IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2023.3 (Build 233U) Tue Sep 19 2023 15:25:13 EDT

Here is the sequence:

[SQL]USER>>CREATE FOREIGN SERVER datafest.MySelf FOREIGN DATA WRAPPER JDBC CONNECTION 'MySelf'
17. CREATE FOREIGN SERVER datafest.MySelf FOREIGN DATA WRAPPER JDBC CONNECTION 'MySelf'
1 Row Affected
statement prepare time(s)/globals/cmds/disk: 0.0068s/2,172/17,436/0ms
execute time(s)/globals/cmds/disk: 0.0137s/9,880/146,107/0ms
query class: %sqlcq.USER.cls16

[SQL]USER>>CREATE FOREIGN TABLE datafest.RemoteDelhi SERVER datafest.MySelf TABLE 'datafest.Delhi'
18. CREATE FOREIGN TABLE datafest.RemoteDelhi SERVER datafest.MySelf TABLE 'datafest.Delhi'
0 Rows Affected
statement prepare time(s)/globals/cmds/disk: 0.0073s/2,172/19,567/0ms
execute time(s)/globals/cmds/disk: 0.1416s/56,801/481,826/0ms
query class: %sqlcq.USER.cls15

[SQL]USER>>select * from datafest.RemoteDelhi
19. select * from datafest.RemoteDelhi
OBSDATE HUMIDITY PRESSURE TEMPERATURECEL WINDSPEED
[SQLCODE: <-230>:<Foreign table query Execute() failed>]
[%msg: <Foreign Tables - ERROR #8104: Gateway Exception: com.intersystems.gateway.GatewayException com.intersystems.gateway.JavaGateway.dynamicExecuteMethod(JavaGateway.java:3748) Remote database reported error: Method not found: com.intersystems.xdbc.gateway.ForeignConnection.prepareStatement(3)>]
0 Rows(s) Affected
statement prepare time(s)/globals/cmds/disk: 0.0515s/44,400/231,301/0ms
execute time(s)/globals/cmds/disk: 0.0177s/114/4,764/0ms
query class: %sqlcq.USER.cls16