Thank you very much for your message. Could you show the stack trace that is producing this error? Also, if you turn on debug logging ( https://www.jooq.org/doc/latest/manual/sql-execution/logging/), what is the generated SQL string that is sent to the JDBC driver by jOOQ?
2017-05-28 12:11 GMT+02:00 Вячеслав Бойко <[email protected]>: > > 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. > -- 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.
