nvm, I figured out that I have to use
insertQuery.getSQL(ParamType.INLINED);
to get the actual output.
Thanks.
On Wednesday, June 20, 2018 at 4:41:48 PM UTC-7, Felix Gao wrote:
>
> 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.
