Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not a valid month error??

Muralidharan KMay 3 2018 — edited May 4 2018

Hi all,

Am using j developer Studio Edition Version 11.1.1.9.0.

I've data in my table with date field (Showing Day as VARCHAR)

My scenario is i've created ADF business component based on Table.

In VO i have added bind variables (fromDate and toDate), to search data that lies between those two dates and i have drag and dropped that

in page as ADF table with query.

Im My EO i have given that the date attribute as Date and (SQLType="TIMESTAMP" Type="java.sql.Date")

pastedImage_0.png

pastedImage_1.png

In VO i have given type attributes for the bind variables FromDate and ToDate as java.sql.Date

pastedImage_2.png

But when i search by giving date after deploying application it shows (not a valid month error).

pastedImage_9.png

How to overcome this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2018
Added on May 3 2018
#application-development-in-java, #jdeveloper-and-adf
4 comments
362 views