I have a table which includes an INT column the values of which are generated always by calling a stored Java function. When I right-click the table content and choose Insert Row, then try to enter a new row, I always end up with the error: "You may not override the value of generated column '<column-name>' ", whether I leave this column as <null> or try to enter a value. I can only enter numeric values and not DEFAULT which may have overcome it.
It appears that SQuirreL doesn't identify the column as a generated one - the table also has an identity column which is marked in the Input New Row Data dialog as "(auto-incr)", and before ading the new generated column I could add rows with auto-generated identity values without problem.
I'm using SQuirreL SQL client v3.1.2 on Windows XP SP3 with JRE 1.6.0_20. The DB is Derby 10.6.1.0.
Log in to post a comment.