2 Replies Latest reply on Oct 23, 2012 11:02 AM by Steven Hawkins

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

    Shantanu D Newbie

      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]