I’m new to Android Studio having only worked with it for two months and been coding with Java for a year. Currently I’m working on a pet adoption application where the goal is to have the user answer four questions about ...
databaseanswers.net Latest Questions
I need to retrieve distinct LocalDate from LocalDateTime in database. I can use Spring data JPA or SQL native query.
Seems I’m rusty at my sql and could use some help. I’m running into an issue on the search query below: SELECT COUNT(1) as totalITCount FROM it_table JOIN i_table on i_table.key = it_table.item_key WHERE (key IN ...
I am new to Spring Boot and I saw a concept of DAO or JPA that helps us to use Relational databases. But in my case I want to use mongo-DB so is there a particular design pattern with spring ...
What is the best way to use ElasticSearch to search exact partial text in String? In SQL the method would be: %PARTIAL TEXT%, %ARTIAL TEX% In Elastic Search current method being used: { "query": { ...
I have an entity called "dog" with the column type "color", which can be BROWN, BLACK or WHITE and I need to return the DECRESCENT order of predominant colors. Example: BROWN(3 dogs)>WHITE(2 dogs)>BLACK(1 dogs) I did this on SQL: select color, count(color) ...
In my entity class, I want to change the data type of a field but it’s not updating in the database. I am using PostgreSQL. I have also tried adding this: spring.jpa.hibernate.ddl-auto=update in application properties and still, it doesn’t work I don’t ...
I have a map with data I got from my database and I am having trouble to find an optimal way to check if the value of one of my fields is empty. The thing is like this. I got 4 ...
I have a high-frequency ingestion system that ingests the IoT data into the system. Approximately 6000 messages, with an average message size of 4KB, are being received each second. Primarily, data is being ingested to Kafka, the spring-boot application will ...
Can i use something like $loockup or $unionWith for comparing two fields from 2 mongodb collections mit @Query in SpringBoot(Repository))?