Datetime i used pstmt.setString(1,fdate.format(now)); because it does the data does not correctly forms the correct date pstmt.setDate(1,now); will only save the date (YYYY-MM-DD) but not the time...
----- Original Message ----- From: "Micha³ Postupalski" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 9:37 AM Subject: Re: Error in Prepared Statement in my Struts Action Class > On 3/18/2003 2:28 AM, Richard Raquepo wrote: > > I doing an app with struts. Although my problem is not directly related to struts maybe any could help me out. > > > > I have this prepared statement > > SQLDef.BUSEMPINFO_INSERT= > > INSERT INTO busempinfo (lastupdate) VALUES (?) > > > > but when i use this on my Java servlet like this > > pstmt = conn.prepareStatement(SQLDef.BUSEMPINFO_INSERT); > > pstmt.setString(1,fdate.format(now)); > > pstmt.executeUpdate(); > > > > i got an error an Exception type error. which just state > > null. It did not go to my SQLException catch. > > > > what seems to be cause this null error. When i turn to the mysql client and run this insert > > INSERT INTO busempinfo(lastupdate) VALUES('2003-01-01'); > > > > i worked fine. Please help me out anyone. Thanks... > > what type is lastupdate field in your DB ??? > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]