struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andre Beskrowni <ABeskro...@axeda.com>
Subject RE: URGENT: Null Strings in Websphere
Date Thu, 14 Feb 2002 05:02:04 GMT
how are you storing your data?  is it stored in a database using jdbc?  and
if so, are you constructing your insert statements as strings and directly
appending the values onto the string rather than using bind values?  i've
seen this problem come up before, and it's always been the case that people
aren't using jdbc the way it's meant to be used.  their inserts were always
done like this:

String insert = "insert into customer " +
               "(customer_id, name, address) " +
               " values (customer_seq.nextval," +
               myCustomer.getName() + ", " + myCustomer.getAddress() + ")";

PreparedStatement insertStmt = connection.prepareStatement(insert);
insertStmt.executeUpdate();

instead of the correct way, which would be like this:

String insert = "insert into customer " +
                "(customer_id, name, address) " +
                "values (customer_seq.nextval, ?, ?);
PreparedStatement insertStmt = connection.prepareStatement(insert);
insertStmt.setString( 1, myCustomer.getName() );
insertStmt.setString( 2, myCustomer.getAddress() );
insertStmt.executeUpdate();

if you think this is the source of your problem, please read the java
tutorial chapter on JDBC asap.

ab


-----Original Message-----
From: Phillips, George H. [mailto:ghp@miami.edu]
Sent: Tuesday, February 12, 2002 3:20 PM
To: 'Struts Users Mailing List'
Subject: RE: URGENT: Null Strings in Websphere


We had a similar problem.  Although we were actually getting spaces back
from our DB, we were seeing "null" displayed on our jsp's.  We fixed it by
explicitly initializing our String fields in our result beans to " " rather
than letting them default to null.  I don't know *why* this worked, since
you'd think the original null values would be overlaid when a field's setter
was called, but for whatever reason, it solved the problem...
George Phillips
University of Miami
ghp@miami.edu

> -----Original Message-----
> From: Dave J Dandeneau [mailto:Dave.Dandeneau@viant.com]
> Sent: Tuesday, February 12, 2002 10:39 AM
> To: Struts Users Mailing List
> Subject: URGENT: Null Strings in Websphere
> 
> 
> Whenever we have a String value in our forms, and the value 
> is not set (""), it is getting sent back to the jsp as 
> "null". By "null" I mean the actual string, and not an empty 
> object. This is making validation of these fields fail. Has 
> anyone seen this and found a work around.
> 
> Thanks,
> Dave Dandeneau
> 
> --
> To unsubscribe, e-mail:   
> <mailto:struts-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: 
> <mailto:struts-user-help@jakarta.apache.org>
> 

--
To unsubscribe, e-mail:
<mailto:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:struts-user-help@jakarta.apache.org>

--
To unsubscribe, e-mail:   <mailto:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@jakarta.apache.org>


Mime
View raw message