I am trying to save the information to the database in the following way: But I get the following error: Using next data: UPD: Check for data and types, get next UPD2: If I use next code, it’s work: But I want to change table Answer Issue resolved, it works:
Tag: sql
C# invalid column name problem but is different from others
Hello i have a table called Card_tbl with a cell CardID. The problem is that when i insert only numbers like 12345 they are uploaded in the database, but when i use mix letters like Q1234R it will say INVALID COLUMN NAME Q1234R I tried many things to fix it but no success. THE CELL IS ON VARCHAR(50) this is
Adding elements in the end to a json array of objects in Oracle
I have a json column named “configuration” in an Oracle database with a data like- How can add elements to the “sections” array inside the CLOB? for example, add this object to the CLOB- {“active”:false, “code”:”page.body”} I tried to do this- but I …
About Containers scalability in Micro service architecture
A simple question about scalability. I have been studying about scalability and I think I understand the basic concept behind it. You use an orchestrator like Kubernetes to manage the automatic scalability of a system. So in that way, as a particular microservice gets an increase demand of calls, the orchestr…
Undefined filter parameter in Hibernate
I am trying to map a LocalDate to a SQL Date, but am receiving this error: java.lang.IllegalArgumentException: Undefined filter parameter [afterDateLocal] I can’t provide a reproducible example, but here’s the code of the ListingRepositoryImpl: And the filters defined on the entity listing: I am u…
Keep variables in the SELECT list which are not used in the GROUP BY nor aggregated
I have 2 tables: table1 (including id, title, and abstract) and table2 (including id, pubdate, and family_id). Each id is unique but multiple rows can have the same family_id. My goal is to display the id, title and pubdate only for the MIN(pubdate) of each family_id so that I should get: I tried this: I get …
How to return results from a subquery greater than a value
I’m trying to find measuring component ids that show up at least 3 times. At this time it is throwing the Oracle Error “ORA-00936: missing expression.” I have tried putting in an existing statement to possibly satisfy the missing expression error, to no avail. It either returned too many val…
Calculating daily volumes from total volume
I have the following data: ID Date Total A 2021-09-03 0 A 2021-09-04 12 A 2021-09-05 37 A 2021-09-06 40 B 2021-08-03 20 B 2021-08-04 43 B 2021-08-05 75 And from this data, I would like to get the following table: ID Date Total Daily A 2021-09-03 0 0 A 2021-09-04 12 12 A 2021-09-05 37 25 A 2021-09-06 40
How to group rows by the date part of a timestamp column?
There is a table having timestamp column : I want to get all rows and the sum of the duree_seconde column based on the date part of the connexion column ; that means I want to sum all the duree_seconde column values for each same day, for example if there are data like this : how can I get the
SQL query subtable in columns from main query
I have 2 tables with a main table with a unique UUID as index and a sub-table containing the languages of 1 row of the main table. E.g. table_1 uuid code 111-etc 123 222-etc 321 table_1_lang uuid lang_code title 111-etc en english 123 111-etc de deutch 123 222-etc en english 321 222-etc de deutch 321 I want t…