Hmmmm.... I thought I had an MSSQL installation here to test on, but it is still hypersonic. Clearly the DBMS is configured to not allow a null user_id, so the two things that come to mind are:
A) Why is the user_id null? B) What would happen if you went into SQL Enterprise Manager and set the "allow nulls" to true on the USER_ID field on the TURBINE_USER table. That would certainly "fix" this problem, although another problem might show up down the road. Good luck, RB Twenty Years | One Mission | Accelerating Business Processes Richard Berger Action Technologies, Inc. VP, Product Management 510.748.1017 (Office) 510.769.0596 (Fax) www.actiontech.com NOTE: The opinions expressed herein are those of the writer and not necessarily those of Action Technologies, Inc. or its employees or its affiliates. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 26, 2004 5:19 AM To: [EMAIL PROTECTED] Subject: MSSQL adding users When trying to add a new user to my MSSQL database, I always get the following error: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC] [SQLServer]Cannot insert the value NULL into column 'USER_ID', table 'webfmp2.dbo.TURBINE_USER'; column does not allow nulls. INSERT fails." Can anyone help me? [EMAIL PROTECTED] --------------------------------------------------------------------- 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]
