I need statistics about alert tagged by codes. Alerts are visible for users with group based restrictions. In case when some tag code is only in alerts which are invisible for user then 0 should be displayed in statisitics. Tables structure: I’m using Blaze-Persistence and try to make GROUP BY in LEFT JOIN SUBQUERY with COALESCE in root query. Reason
Tag: java
Query Java doesn’t execute
I’m trying to execute a query on eclipse at my Java program, but it always exit with a exception and don’t execute the query, I read a lot of posts here but no one of them could help me with this. …
How to import data from one table to another – SpringBoot JPA /MySQL
I recently created a vehicle management system The system is derived from MySQL database and server side in spring I want to create another table (automatically at runtime) that will display only 2 of the columns of the existing table. And the question is what am I doing wrong? Final goal – when adding / deleting / editing a vehicle,
How to get Ignite Cache SQL Query to Return Value Object
I have a Postgres database configured as my persistence layer and would like to execute SQL queries against the Postgres tables cached in Ignite. Ideally, I’d like to execute a query on these caches and be returned the Value objects represented by these tables. SqlQuery gives me the functionality that I am looking for but is deprecated. SqlFieldsQuery would work,
how to make search bar without having to type double quotation?
hello everyone i am trying to make this search bar in java but when i search without typing double quotation i get this error search error image but when i type numbers or words with double quotation it works just fine searching with double quotation image here is my code Code image ididn’t wirte anything in the textfield Answer Change
Result of ‘File.createNewFile()’ is ignored
I’m not sure why this is but in my IDE, for file.createNewFile(); I’m getting Result of ‘File.createNewFile()’ is ignored for it which I’ve no idea what I should be doing Answer Static Code Inspection in your IDE for createNewFile might be complaining this because createNewFile returns a boolean value. This is in place so that you have a way to
Boolean value not being changed in database
Hey folks I’m having a problem with my code. For some reason when I try to change the value to false, it doesn’t reflect in my SQL Database. I debugged and it does get set via Java, but it doesn’t transfer over. I’m working on a notification service class and it sets the values on there to true no problem,
SQL code does not work when converted to JPQL code (ORA-00904 error code)
Thank you very much for looking at this post :). I have the following problem: I have a piece of SQL code that runs perfectly on the Oracle database. The problem comes when I try to run as JPQL code. I get the following error in the Eclipse IDE: Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: “THIRDTABLE”.”NAME”: invalid identifier. The SQL that works
Hibernate Table or view does not exist Oracle
I Have a problem executing an hibernate query on Oracle: my persistence.xml: my entity class com.entity.User: my java class: but when i execute my code, i obtain: Can you help me to find the error? NOTE: if a use a PreparedStatement with the same connections and query i don’t have any issue, so it is not a problem of permissions
java.sql.SQLSyntaxErrorException: ORA-01797: this operator must be followed by ANY or ALL
My query is I get the error java.sql.SQLSyntaxErrorException: ORA-01797: this operator must be followed by ANY or ALL whenever i run it, What does it mean and how can I fix it ? Answer Your code is very messy and should be cleaned up. When asking the questions here you usually should create a MRE in which the concrete problem