I have Spring JPA. I have a query like this in sql oracle: I have a CrudRepository in which I use the above query in native mode, like this: I get ORA-00933: Passing myValue as integer between quotes I get ORA-01867 Passing myValue as integer without quotes I get ORA-00933 How to do it? Answer See comments on…
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: mapList.stream().collect(Collect…
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 …
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 m…
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 <= en…
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. Anyo…
Spring SQL: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement “; expected “identifier”, when using INSERT INTO
I am working on a Spring Web Application. I am using mysql database, but for my unit tests, I want to run them in H2 database. Test specific application properties: As you can see, my database is in MODE=MYSQL, since my data.sql is in MySQL dialect. But during initialization of of data.sql I get this error: I…
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 p…
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 int…