Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Richard Raquepo 
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...

Re: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Micha Postupalski 
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]

RE: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Marc Esher 
Hopefully your lastupdate field is a timestamp field, and so you could use
pstmt.setTimestamp(xxx) or possibly pstmt.setDate()

-Original Message-
From: Micha3 Postupalski [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 8:37 PM
To: Struts Users Mailing List
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]

Re: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Richard Raquepo 
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 (-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]

Re: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Micha Postupalski 
On 3/18/2003 2:57 AM, Richard Raquepo wrote:
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 (-MM-DD) but not the
time...
U should use pstmt.setTimestamp(1, well_formed_field ) because:

The DATETIME type is used when you need values that contain both date 
and time information. MySQL retrieves and displays DATETIME values in 
'-MM-DD HH:MM:SS' format.

So try this way:
pstmt.setTimestamp(1,now);
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]