Skip to content

Tag: sql

How to get list of Map data using JDBCTemplate.queryForMap

How I can get proper return type of List<Map<String, Object>> mapList = jdbctemplate.queryForList(query)); Where my query is “SELECT * FROM table_name;”. Can anyone help me? Answer You can use the following snippet to get the required map from the list: -> (Integer) k.get(“id”), k -> (String) k.get(“name”))); this is used to extract the exact data alone from the whole

why does my sql table treat 1000 as a middle number?

When I try to sort by a value descending my SQL table does it correctly, but if it sees for example “1000” it always puts it in the middle? for Example: this even happens when I reference it in spigot (I’m using it for a plugin) it outputs it the same way this is how I’m calling it in my

Spring boot – org.postgresql.util.PSQLException: FATAL: password authentication failed for user “postgres” [closed]

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 8 months ago. Improve this question

Check if any value in list satisfies a condition

Suppose I have the following table called Seasons: … start_month end_month … 2 6 … 3 4 … … … I need to write a query which, for a given list of months, returns all the Seasons that satisfy the condition where at least 1 month in the list is: start_month <= month <= end_month. I’ve written this query as

Get the max value using kotlin-exposed

I want to simulate this query using kotlin exposed framework: I tried the next one query: But this query just results in: and the max value is selected in the code. How to perform finding max value on the side of the database and map it to Int? Answer I tried similar query and I believe it fits your need.

near “”: syntax error in SQL with android studio

I’m working on a SQL databse on java (android studio project) but i have a weird mistake. Basically, everytime i have I have tried like this My DBS is And i really don’t see where is the mistake. Because they’re saying “syntax error”, but for me, it’s look pretty OKAY. Anyone have a clue ? I’m just trying to insert

how do i save a new student that contains entities, but don’t create these entities because they already exist in the database?

I want to save a student and a student has a TargetAudience object as an attribute. These target audiences are allready hardcoded in my database. (targetaudience = campus + major). Now when i post like this: it doesnt work because everythime it creates a new object for the campus and because i use name as a primary key it throws

Create a table “ca” as a statement using values of another tables but while inserting new values, the values of “ca” doesn’t change

I want to calculate turnover like in new table called ca ‘ I have tables article (idarticle, priceBuying, priceSale, quantity), and table command have (idarticle, quantity, dateSale), I want to calculate turnover automatically everyday and insert into ca , but the problem is when I insert new values into command the values of ca not updating using oracle db. Answer