Well, updating the driver did not work.
This, is the query and passing now().
The error is the datetime2 conversion I mentioned earlier. The binding for this.custom.now is this: dateFormat(now(), 'yyyy/MM/dd hh:mm:ss').
The commented datetime in the Value field was a successful test.
Using the Scripting Tool, system.date.now() is a java.util.date object. If I print that out, I get: Wed Jul 31 15:34:05 PDT 2024 .
If I send that to the SAME query used in the binding, I get the expected integer returned!
I am missing something here in the expression language versus Jython. A simple cast, convert, format???
I found this thread:
Not sure how Transistor's code worked with the 0 in the now(0). I kept getting errors. So I adapted r123's code to fit my widget, removed the binding on this.custom.now and that seems to work.
I just don't understand why now() will not work in an expression binding for a named query datetime parameter, but system.date.now() will.