I have error descibed in subject.
Having simple table into PostgreSQL 9.6 database:
CREATE TABLE public.products_new
(
id bigint NOT NULL DEFAULT nextval('products_new_id_seq'::regclass),
provider_id bigint NOT NULL,
name character varying NOT NULL,
vendor_code character varying,
manufacturer character varying,
min_count numeric NOT NULL DEFAULT 0,
count numeric NOT NULL DEFAULT 0,
price numeric NOT NULL DEFAULT 0,
date_loaded character varying,
is_processed boolean NOT NULL DEFAULT false,
CONSTRAINT pri_products_new_id PRIMARY KEY (id),
CONSTRAINT fk_products_new_provider_id FOREIGN KEY (provider_id)
REFERENCES public.providers (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.products_new
OWNER TO priceprocessoruser;
using simple insert:
public static class Product {
public Long providerId = 0L;
public String vendorCode = "";
public String name = "";
public String manufacturer = "";
public BigDecimal minCount = new BigDecimal(0);
public BigDecimal count = new BigDecimal(0);
public BigDecimal price = new BigDecimal(0);
}
/* initializing Product skipped */
DSL.using(ctx)
.insertInto(Products.PRODUCTS)
.set(Products.PRODUCTS.PROVIDER_ID, productData.providerId)
.set(Products.PRODUCTS.NAME, productData.name)
.set(Products.PRODUCTS.VENDOR_CODE, productData.vendorCode)
.set(Products.PRODUCTS.MANUFACTURER, productData.manufacturer)
.set(Products.PRODUCTS.COUNT, productData.count)
.set(Products.PRODUCTS.MIN_COUNT, productData.minCount)
.set(Products.PRODUCTS.PRICE, productData.price)
.set(Products.PRODUCTS.DATE_UPDATED, dateFormat.format(dateNow))
.execute();
made using jOOQ from maven:
<dependency>
<groupId>org.jooq</groupId>
<artifactId>jooq</artifactId>
<version>3.9.2</version>
</dependency>
*What's wrong???*
--
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.
