struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Newton <>
Subject [OT] Re: General error message from server : "Field 'firstname' doesn't have a default value"
Date Fri, 12 May 2006 15:48:48 GMT
rajan pahuja wrote:
> java.sql.SQLException: General error message from server: "Field 'firstname' doesn't
have a default value"

Well, looks like you're trying to insert a null/blank value into a table
that's not-null and specifies no default value, but I'm no
MySQL/ConnectorJ guru. You might want to try asking MySQL-related
questions on a MySQL group or list.

> private static final String QUERY2 = "CREATE TABLE ?_user_business(CompanyName VARCHAR(20),
SharesHeld INT, ShareBuyingPrice FLOAT);";

Are you creating a new table for every user?


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message