Getting 'org.teiid.api.exception.query.QueryResolverException' for CREATE operation

[shan_dind]

Hi All,

I am using teiid-8.1.0.Final in my project for data virtualization, while doing a create operation on one of the table which is having a date column, we receive the date as jodatime and convert it to java.util.date and pass it on to the teiid in parameter list. Somehow in the teiid code before create statement execution the date gets formatted to 'MM/DD/YY HH.MM' format and the create fails saying 'TEIID30558 Error converting parameter number 2 with value "10/23/12 4:47 PM" to expected type date'.

Below is the detiled exception I received from teiid, please let me know what could be the issue and the workaround if any.

Thanks,

Shantanu

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: org.teiid.jdbc.TeiidSQLException: TEIID30558 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30558 Error converting parameter number 2 with value "10/23/12 4:47 PM" to expected type date.

Error Code: 0

Call: INSERT INTO well_interest (type,date_acquired,well_location_uwi,company,SOURCE_NAME) VALUES (?,?,?,?,'OWHP64_FL2D_IP')

          bind => [UNKNOWN, 2012-10-23 16:47:26.658, 49, TEST]

[rareddy]

Try converting it into java.sql.Date

[shawkins]

You must also converting from java.util.Date to String prior to passing to Teiid, the string form does not match the expected format for a java.sql.Date.  As Ramesh says, just use java.sql.Date instead of java.util.Date.