upgrade to 12.2.1.4 adf.currentDate + 90 does not work

User_H6Z6F

We are trying to upgrade from 12.2.1.0 to 12.2.1.4. We have VO attributes with expression like adf.currentDate+ 90 to initialize the attributes. This does not work in new version. Does anyone know any workaround?

Below is the log

groovy.lang.MissingMethodException: No signature of method: java.sql.Date.plus() is applicable for argument types: (Integer) values: [90]
  Possible solutions: parse(java.lang.String), is(java.lang.Object), use([Ljava.lang.Object;), split(groovy.lang.Closure), wait(), clone()

User_H6Z6F

We found that the jar groovy-dateutil-2.5.6 is missing in the new jdev version. After adding it the issue is solved.

Timo Hahn

Well, the groovy expression adf.curentDate returns a Date type. As you can't add an integer to a Date, you get the error.

What 90 do you want to add anyway? Days? Month? Seconds?

Timo

User_H6Z6F

yes we need to add 90 days to current day. This is working in 12.2.1. currently.

Timo Hahn

In 12.1.2 groovy was not type save and some things worked. Now you have to program it yourself.

Eg. you can get the current date as milliseconds and add the milliseconds calculated for 90 days (90*24*60*60*1000) add the two values and create a new date from the result.

Timo

dvohra21

What is the Groovy version? Could be the bug discussed at https://github.com/groovy/GMavenPlus/issues/100

User_H6Z6F

We found that the jar groovy-dateutil-2.5.6 is missing in the new jdev version. After adding it the issue is solved.

User_S75WS

I have used groovy-dateutil-2.5.6 jar in my application, but still, the issue is not been resolved.

User_3SMA4

Can you confirm that groovy expressions work in the 12.2.1.4 version? We did not upgrade from 12.2.1.3 version because of those issues.

dvohra21

<dependency>
    <groupId>org.codehaus.groovy</groupId>
    <artifactId>groovy-dateutil</artifactId>
    <version>2.5.0</version>
    <classifier>indy</classifier>
</dependency>

Which is what was suggested earlier:

Could be the bug discussed at https://github.com/groovy/GMavenPlus/issues/100

User_H6Z6F

@User_3SMA4

Yes groovy expressions work in the 12.2.1.4 version which is why we are in the middle of the upgrade.

User_D571K

Hello there, you can use this syntax to add days to current date instead of using adf.currentDate+ (no of days):

import groovy.time.TimeCategory

def now = new Date()

use(TimeCategory) {

  days365 = now + 365.days

  return new java.sql.Timestamp(days365.time)

}

Let me know if this is not working for you!

Thanks.