java openclient datetime-tz

Posted by marian.edu on 04-May-2018 07:24

It looks like there is still an issue with array fields in resultset (temp-table), date and datetime now works but not datetime-tz :(

Calling any procedure that returns a temp-table/dataset with one field being an datetime-tz array (extent) result in the following error. 

com.progress.open4gl.Open4GLException: Input result set error: com.progress.open4gl.Open4GLException: 0 (7176)
at com.progress.open4gl.dynamicapi.ExceptionConverter.convertToOpen4GLException(ExceptionConverter.java:155)
at com.progress.open4gl.dynamicapi.Session.handleOutputErrors(Session.java:1659)
at com.progress.open4gl.dynamicapi.Session.runProcedure0(Session.java:1282)
at com.progress.open4gl.dynamicapi.Session.runProcedure(Session.java:830)
at com.progress.open4gl.dynamicapi.Session.runPersistentProcedure(Session.java:607)
at com.progress.open4gl.javaproxy.Procedure.runPersistentProcedure(Procedure.java:458)
at com.progress.open4gl.javaproxy.Procedure.runPersistentProcedure(Procedure.java:375)
at com.progress.open4gl.javaproxy.OpenProcObjectImpl.<init>(OpenProcObjectImpl.java:24)
at com.progress.open4gl.javaproxy.OpenProcObject.<init>(OpenProcObject.java:23)
at com.progress.open4gl.javaproxy.OpenAppObject.createPO(OpenAppObject.java:353)

Seems to be a sequel of this, https://knowledgebase.progress.com/articles/Article/000052040... I can confirm any other data type works just fine (including RAW).

As a side note, is there any reason the entries in that list aren't native date objects for DATE/DATETIME fields? For all other data types the entries in the list are primitive Java data types (Integer, BigDecimal, bool, String, byte[])... for DATE/DATETIME those are GregorianCalendarHolder???

And, the ecore version there urge to be updated to a more recent one :)

Thanks,

Marian

All Replies

Posted by Brian K. Maher on 04-May-2018 07:32

What version are you running?
 
Brian Maher
Principal Engineer, Technical Support
Progress
Progress
14 Oak Park | Bedford, MA 01730 | USA
phone
+1 781 280 3075
 
 
Twitter
Facebook
LinkedIn
Google+
 
 
ProgressNext2018_Email_Signature
 

Posted by marian.edu on 04-May-2018 08:34

11.6 no service pack, will try with 11.7 in a bit.


Posted by Brian K. Maher on 04-May-2018 08:44

If it still exists in 11.7 please open a support case.
 
 
Brian Maher
Principal Engineer, Technical Support
Progress
Progress
14 Oak Park | Bedford, MA 01730 | USA
phone
+1 781 280 3075
 
 
Twitter
Facebook
LinkedIn
Google+
 
 
ProgressNext2018_Email_Signature
 

Posted by marian.edu on 04-May-2018 12:22

OK, in 11.7 the o4glrt.jar was changed compared to 11.6 and using that seems to work even if the appsrv we connect to is still 11.6 so I guess we just have to update the openclient library we deploy.


However, for date/datetime/datetime-tz the Java objects in the list returned are still GregorianCalendarHolder instead of plain java Date objects... that seems like an odd choice, especially since all other data types are returned as native Java types.
 
Marian Edu

Acorn IT 
+40 740 036 212

This thread is closed