When trying to import data using the JsonLoader into MSSqlServer 2012 like
this :
Table<? extends TableRecord> table = tables.get(tableName);
LoaderJSONStep<? extends TableRecord> loaderJSONStep =
create.loadInto(table)
.onDuplicateKeyIgnore()
.onErrorAbort()
.commitNone()
.loadJSON(jsonDataFiles.get(table.getName()).getInputStream());
I get
Cannot insert explicit value for identity column in table 'stamm_daten'
when IDENTITY_INSERT is set to OFF.
errors. I tried to set
create.execute("SET IDENTITY_INSERT " + stringTableEntry + " " + onOff);
Without success.
The generated insert statements contains the column names, so this should
also not be a Problem.
Any ideas?
Thanks
Johannes
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
