java openclient datetime-tz - Forum - OpenEdge General - Progress Community

java openclient datetime-tz

 Forum

java openclient datetime-tz

This question is not answered

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
  • 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
     

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


  • 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
     

  • 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