#898 Insert Row tries to insert values into generated columns

Core (462)

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


  • Rob Manning

    Rob Manning - 2010-08-14

    If the metadata for the column doesn't indicate that the column is auto-generated, then there is not much we can do. Check the columns for the table using the "Columns" tab and see if your column has "AUTOINCREMENT: start 1 increment 1" (or something like that) for COLUMN_DEF value. Let us know what you find out.

  • Comment has been marked as spam. 

    You can see all pending comments posted by this user  here

    Anonymous - 2010-08-15

    discount jordan 3 isviuaehh online jordan 1 sale luisciget jordans Discount bdthby jordan 7 Sale sllmrnnrj Jordan Fly Wade tzgfyfeygeb Nike Free Run 2 chaussures oftgjf buy jordan 1 sneakers jyfxriy jordan 9 online iqseist cheap jordan retro sale

    Last edit: Anonymous 2015-07-10

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks