|
From: Robert M. <rob...@gm...> - 2008-04-27 22:32:41
|
On Mon, Apr 21, 2008 at 5:14 AM, Exemplar <pe...@ex...> wrote: > Hi Rob, > > The database is HSQLDB 1.8.0 and this is the script: > > create table Air_interface_modes > ( > ai_mode_id identity > ,jdoversion integer > ,jdoclass varchar(255) default > 'com.ea.albt.domain.model.comms.impl.BaseAirInterfaceMode' not null > ,ai_standard_id integer not null > ,modulation_scheme_id integer not null > ,coding_scheme_id integer not null > ,ideal_es_no real > ,per_symbol_efficiency real > ); > > The two numeric values go in the last two columns. Peter, By looking at the stack trace and running your input myself, I was able to get it to work. The trick is to not use the "Auto Increment" setting for your AutoIncrement column. You should use the "Skip" setting for that column. Here is a screenshot of the setup that I used that worked with your first quoted string example: http://squirrel-sql.sourceforge.net/downloads/data_import_setup.png The AutoIncrement setting will cause the plugin to attempt to "simulate" an auto-increment column. Since your table's column values is managed via the database (AutoIncrement datatype), you can just skip this column and the insert should work fine. Rob |
