検索

Question
· Avr 27, 2018

PostgreSQL query returns error

#JDBC #SQL #HealthShare #Ensemble #Health Connect

LS,

I'm executing a query using JDBC on a PostgreSQL db:

SET statement_timeout TO 600000000; COMMIT SELECT * FROM bi_hour

The query is aborted with the following message:

FOUT #5023: Fout in Java Gateway: JDBC Gateway getClob(0,2) errorBad value for type long : active

The column 'blocked_status' contains the value 'active' is of type 'text'. I figure somewhere the SQL Gateway tries to convert the text value into a long but I can't find where, any suggestions?

4 Comments
Discussion (4)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Avr 20, 2018

Special Character API

#Opérations d'entreprise #JSON #Object Data Model #REST API #Ensemble

Hi

Made a request for API REST.

Using HTTP Request adapter.

Adapter As EnsLib.HTTP.OutboundAdapter

Outside the Ensemble an API response is JSON (CORRECT)

Answer in Ensemble: =?Á
Â0 
?_eä,cÒ
'=
*^<YÙF¡í$í¼ÈÞÝt 
oÉ÷ý$?|
¤1¡{Dâhà°Ý?Öù)2ós??R?¸¼?ºd?$,ñD+»??
? 
ÔºQZéýNÕ V{C?óò?b¢?éÍ )$ 
²5Å?wEë? ??©tÖã1z×2FëÊnôeË æ??]Zßq ܺ?á

Help me.

Thank you

8 Comments
Discussion (8)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Avr 11, 2018

ENSEMBLE used in a AutoCad / ArchiCad / ARchiFM environment.

#Ensemble

We are planning to integrate drawing software like AutoCad with an in-house facility management software and plan on using Ensemble. Has this been done before? And if so we would like to get the necessary assistance or guidance. 

Thanks.

Izak.

1 Comment
Discussion (1)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Avr 6, 2018

Class storage definition in atelier

#Git #InterSystems IRIS

I am using Atelier + EGit plugins for a project. Is it possible to turn the storage definition off in Atelier so this does not get copied to Git when I make changes? While developing on different versions of the code on different systems, it may cause conflicts and excess noise in the source control history

6 Comments
Discussion (6)1
Connectez-vous ou inscrivez-vous pour continuer
Discussion (11)1
Connectez-vous ou inscrivez-vous pour continuer