Write to Database node erroring out.

Question

Hello All, 
 I have a write to database node that is erroring out and cannot figure out why. The error is as follows... 
 type=REV_organization (id=11692)] (data store: Reviewer Tables). Details: org.hibernate.exception.GenericJDBCException: could not insert: [REVOrganizationDT6093]: java.sql.SQLException: Field 'ORGANIZATION_ID_PK' doesn't have a default value Data: TypedValue[it=11692,v={3241,... 
 
 What is strange is that the CDT I am attempting to save has a value for that field ORGANIZATION_ID_PK as you can see in the error itself it is set to 3241. So, I can rule out that it is trying to save a <NULL>. The CDT's XML for that column is defined as @Id @GeneratedValue @Column(name="ORGANIZATION_ID_PK") but it already has a value of 3241 so it shouldn't need an auto generated value, and the column in the database is set up as a INT(11), primary key, with the default set to "None". 
 I've checked the Jboss logs and there are no more details into what the error is than what I've provided above. 
 In short I'm trying to save a numerical value of 3241 to a column and it's erroring out and telling me that column has no default value. 
 
 I'd appreciate if anyone had anymore insight into this issue. 
 
 Thanks, 
 Brenden

Colton Beck · Accepted Answer

There is likely a discrepancy between the AUTO_INCREMENT configuration in your CDT and table. Ensure that they match.

Puspendu Pal · Answer

Hello, 
 
Looks like it is trying to insert rather than update. If you are trying to insert the row, then the PK column should not be populated with a value since it auto generated.

BrendenH · Answer

I added AUTO_INCREMENT to the DB Column to match the @GeneratedValue of the CDT and it wrote to the database successfully. Looks like if the two are mismatched it'll throw that "doesn't have a default value" error. Good Call Colton Beck ! Looks like you were also on the right track Puspendu Pal .