The SQL Server database is used as a web project: the column id cannot be inserted with NULL values, and the weibo. dbo. myfriend Column cannot have NULL values. INSERT failed. Error message: com. microsoft. sqlserver. jdbc. SQLServerException: atcom. microsoft. sqlserver. jdbc. SQLServerException. makeFro
The SQL Server 2005 database is used for web projects: the column id cannot be inserted with NULL values, and the weibo. dbo. myfriend Column cannot have NULL values. INSERT failed. Error message: com. microsoft. sqlserver. jdbc. SQLServerException: at com. microsoft. sqlserver. jdbc. SQLServerException. makeFro
SQL Server 2005 databases are used for web projects: the 'id' Column cannot be inserted with NULL values, and the 'weibo. dbo. myfriend' Column cannot have NULL values. INSERT failed.
Error message:
Com. microsoft. sqlserver. jdbc. SQLServerException:
At com. microsoft. sqlserver. jdbc. SQLServerException. makeFromDatabaseError (Unknown Source)
At com. microsoft. sqlserver. jdbc. SQLServerStatement. getNextResult (Unknown Source)
At com. microsoft. sqlserver. jdbc. SQLServerPreparedStatement. doExecutePreparedStatement (Unknown Source)
At com. microsoft. sqlserver. jdbc. SQLServerPreparedStatement $ prep;texeccmd. doExecute (Unknown Source)
At com.microsoft.sqlserver.jdbc.TDSCommand.exe cute (Unknown Source)
At com.microsoft.sqlserver.jdbc.SQLServerConnection.exe cuteCommand (Unknown Source)
At com.microsoft.sqlserver.jdbc.SQLServerStatement.exe cuteCommand (Unknown Source)
At com.microsoft.sqlserver.jdbc.SQLServerStatement.exe cuteStatement (Unknown Source)
At com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.exe cuteUpdate (Unknown Source)
Error cause:
Creating myfriend in SQL Server 2005 does not set the id to "yes"
Solution:
For example, set its Id to "yes"