I’m trying to write a PL-SQL query to return records from multiple table and using decode to allow null value comparison, The result is returning only where DeptName is exactly matching to the database values, but I want a query to return something e.Department like ‘%DeptName%’ Answer No ne…
Tag: java
How to return deleted rows using jdbi?
How do I return the deleted rows using jdbi? For example, I’d like to do something like this: Answer Postgresql has a returning keyword… https://dbfiddle.uk/?rdbms=postgres_13&fiddle=25d284309745e40c8ea29945481d1aa2 You can then execute that query in the same way as you would a normal SELECT s…
How can I pass a parameter in an sql query without making it explicit in the query itself?
I’m testing my ignite cache, inserting a simple User in the cache and then through a query I get the User entered previously returned I have a problem writing the query. I noticed that writing like …
JPA query is throwing a ‘not found’ error for column that isn’t in query
I’m trying to call for only specific columns in my DB but the query is throwing an error saying that the next column is not found (even though it’s not in the query) Is there a problem in the join that’s doin this? I’m a bit perplexed as to this problem. JPA Query from ConnectionReques…
Remove Null from For loop of ArrayList
I am currently converting an ArrayList to a String to send it to a DB so I can retrieve it on the other end and convert it back to an ArrayList later. My thought process is to convert it to a string …
Jooq insert one2one and one2many relational data into 2 tables at once. How to deal with issues and rollback
F.e. model How to insert it at once in jooq? How to deal with rollback if some query will fail? Is it has to be programated on my side? I can not find a word about such case in documentation 🙁 Should Id do it manually like: find author id in db by name if author not exist insert new
Java sql error when trying to update database
I am having a sql syntax issue when I am trying to update my databse through my update method which is trigured by a button here is the button code The update method code And the error Answer You missed the commas in the UPDATE statement. It should look like:
SQLite Database not getting updated
So Ive created an app where the user can input details about the movies he has watched such as name,cast,rating…ect and the details are stored in a database inside a table names which is initialized in the DataBaseHelper class as in the below segment of code Ive created a list view and displayed the nam…
MySQL Java prepared statement Syntax error
I need to select rows from mysql table based on various criteria, for example Colour= Black, or size= L. The code works without the preparedstatement and the question marks, but whenever I attempt to use the question marks the code does not run. I have read something about typing the question mark like ‘…
Spring Data Jpa to get data which doesn’t have entity representation
I’m trying to find the best way to map my data on ORM. I have a query which gets me data from MySQL database which look like What would be the most optimal way to get these data with Spring boot and Spring data?? Should I use @Query annotation and execute this or somehow create entities for Equipment an…