RE: Insert Statement and DateTime

[Jean Guillaume LALANNE]

Finally it was simple to solve … I just have to avoid using TO_DATE(#StartDate#,'MM-DD-YYYY'). #StartDate# is enough.   Regards Jean-Guillaume LALANNE   De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoyé : vendredi 21 janvier 2005 16:36 À : ibatis-user-cs@incubator.apache.org Objet : Insert Statement and DateTime   Hi everybody,   I am trying to insert a row in a table where one column is an Oracle Date. To do so, I use a parameterClass that have the corresponding DateTime element. My SQL request works correctly :   INSERT INTO TWIMB_HTTPREQUEST ( HTTPREQUEST_ID, HTTPREQUEST_BROWSER, HTTPREQUEST_IP, HTTPREQUEST_TYPE, HTTPREQUEST_ENTITYNUM, HTTPREQUEST_STARTDATE, HTTPREQUEST_ENDDATE, HTTPREQUEST_RESULT ) VALUES (SEQ_WIMB_HTTPREQUEST.NEXTVAL ,'MSIE', '192.168.1.30', 'CONTAINER', 'ECMU544154', TO_DATE('05-23-1972','MM-DD-YYYY'), TO_DATE('05-23-1972','MM-DD-YYYY'), 'OK' )   But when I want to use the following insert statement,   <insert id="insertHTTPRequest" parameterClass="HTTPRequest">                                       INSERT INTO TWIMB_HTTPREQUEST         (                     HTTPREQUEST_ID,                     HTTPREQUEST_BROWSER,                     HTTPREQUEST_IP,                     HTTPREQUEST_TYPE,                     HTTPREQUEST_ENTITYNUM,                     HTTPREQUEST_STARTDATE,                     HTTPREQUEST_ENDDATE,                     HTTPREQUEST_RESULT         )         VALUES         (                     SEQ_WIMB_HTTPREQUEST.NEXTVAL,                     #Browser#,                     #Ip#,                     #RType#,                     #EntityNum#,                     TO_DATE(#StartDate#,'MM-DD-YYYY'),                     TO_DATE(#EndDate#,'MM-DD-YYYY'),                     #Result#         ) </insert>   I get and error:   Exception non gérée : IBatisNet.Common.Exceptions.IBatisNetException: Error executing query 'insertHTTPRequest' for insert.  Cause: ORA-01843: not a valid month  ---> System.Data.OracleClient.OracleException: ORA-01843: not a valid month    at System.Data.OracleClient.OracleConnection.CheckError(OciHandle errorHandle, Int32 rc)    at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle,CommandBehavior behavior, Boolean isReader, Boolean needRowid,OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals)   How can I define a good datetime for my request ?   Thanks in advance for your help,   Regards Jean-Guillaume LALANNE