Hi Lucas,
Thanks for answering my question. I am able to call addRecord, but not
sure how to call the getBindValues function.
InsertQuery<ItemRecord> insertQuery =
dslContext.insertQuery(Tables.ITEM);
for(PlmItemRecord record : ITEM_RECORDS){
insertQuery.addRecord(record);
}
LOGGER.info("Insert Item Record: \n" + insertQuery.getSQL());
The output of the query looks like
INFO: Insert Item Record:~
insert into "PUBLIC"."ITEM" ("TO_NUMBER", "CREATEUSER", "CREATEDATE",
"PART_NUM", "ITEMTYPE", "LIFECYCLEPHASE", "DESCRIPTION", "PRODUCTLINES",
"REV", "EFFECTIVITYDATE", "REVRELEASEDATE", "ITEMCATEGORY", "COMMODITY",
"PAGE02LIST01", "PAGE02LIST02", "PAGE02LIST03", "PAGE02LIST04",
"PAGE02LIST05", "PAGE02LIST06", "PAGE02LIST07", "PAGE02LIST08",
"PAGE02LIST09", "PAGE02LIST10", "PAGE02LIST11", "PAGE02LIST12",
"PAGE02LIST13", "PAGE02TEXT01", "PAGE02TEXT02", "PAGE02TEXT03",
"PAGE02TEXT04", "PAGE02TEXT05", "PAGE02TEXT06", "PAGE02LIST15",
"PAGE02LIST14", "PAGE02LIST16", "PAGE02LIST17", "PAGE02LIST18",
"PAGE02LIST19", "PAGE02LIST20", "PAGE02LIST21", "PAGE02LIST22",
"PAGE02LIST23", "PAGE02LIST24", "PAGE02LIST25", "PAGE02TEXT13",
"UPC_PROCESS_FLAG") values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?...¬
which does not contain the data that I added. How can I get SQL that can
be used by a DBA to complete the load?
Thanks,
Felix
--
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/d/optout.
