JCH
Java Community | Help. Code. Learn.•2mo ago
bambizas19

does jpa repository use varchar(10) somewhere?

hey guys. i have this DB table: 
CREATE TABLE public.sales_orders (
    id serial4 NOT NULL,
    customerid int4 NULL,
    amount int4 NULL,
    status varchar(30) NULL,
    order_time int4 NULL,
    order_name varchar(255) NULL,
    product varchar(255) NULL,
    product_id varchar(30) NULL,
    amount_paid int4 NULL,
    pay_time int4 NULL,
    order_data text NULL,
    ref1 int4 NULL,
    payment_data text NULL,
    ref2 varchar(255) NULL
);
CREATE TABLE public.sales_orders (
    id serial4 NOT NULL,
    customerid int4 NULL,
    amount int4 NULL,
    status varchar(30) NULL,
    order_time int4 NULL,
    order_name varchar(255) NULL,
    product varchar(255) NULL,
    product_id varchar(30) NULL,
    amount_paid int4 NULL,
    pay_time int4 NULL,
    order_data text NULL,
    ref1 int4 NULL,
    payment_data text NULL,
    ref2 varchar(255) NULL
);
and i get this error: ERROR: value too long for type character varying(10). The thing is that theres no column that has data type varchar(10). Im getting error here: 
SalesOrder salesOrder = new SalesOrder();
        salesOrder.setCustomerId(Long.valueOf(paymentInformationRequest.getClientId()));
        salesOrder.setTransactionId(paymentInformationRequest.getTransactionId());
        salesOrder.setAmount(paymentInformationRequest.getAmount().longValue());
        salesOrder.setStatus("NEW");
        salesOrder.setOrderTime(System.currentTimeMillis()/1000);
        salesOrder.setOrderName("Pay Balance");
        salesOrder.setProduct("Pay Balance");
        salesOrder.setProductId("BALANCE SO");
        salesOrder.setAmountPaid(paymentInformationRequest.getAmount().longValue());
        salesOrder.setPayTime(System.currentTimeMillis()/1000);
        salesOrder.setPaymentData(paymentData);
        salesOrdersRepository.save(salesOrder)
SalesOrder salesOrder = new SalesOrder();
        salesOrder.setCustomerId(Long.valueOf(paymentInformationRequest.getClientId()));
        salesOrder.setTransactionId(paymentInformationRequest.getTransactionId());
        salesOrder.setAmount(paymentInformationRequest.getAmount().longValue());
        salesOrder.setStatus("NEW");
        salesOrder.setOrderTime(System.currentTimeMillis()/1000);
        salesOrder.setOrderName("Pay Balance");
        salesOrder.setProduct("Pay Balance");
        salesOrder.setProductId("BALANCE SO");
        salesOrder.setAmountPaid(paymentInformationRequest.getAmount().longValue());
        salesOrder.setPayTime(System.currentTimeMillis()/1000);
        salesOrder.setPaymentData(paymentData);
        salesOrdersRepository.save(salesOrder)
can smb help me out debug this thing? I dont understand whats wrong
5 Replies
JavaBot
JavaBot•2mo ago
⌛ This post has been reserved for your question.
Hey @Fragmented friends! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically marked as dormant after 300 minutes of inactivity.
TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.
ayylmao123xdd
ayylmao123xdd•2mo ago
well you could just try to comment out each field where it sets a string value and see which one might be causing the issue or integer field too
Peter Rader
Peter Rader•2mo ago
Does any reference in the SalesOrder-entity have a cascade-persist? Maybe PaymentData?
0x150
0x150•2mo ago
full error? some more context as to which field it is? also look at the generated ddl
JavaBot
JavaBot•2mo ago
💤 Post marked as dormant
This post has been inactive for over 300 minutes, thus, it has been archived. If your question was not answered yet, feel free to re-open this post or create a new one. In case your post is not getting any attention, you can try to use /help ping. Warning: abusing this will result in moderative actions taken against you.

Did you find this page helpful?