Skip to content
Advertisement

Tag: java

Complex SQL Query For Counting and Listing

I need to write complex sql for counting distinct names popularity and sorting them with descending order. I’ll do this with hibernate @Query(“SELECT * FROM …”) parameter. First I tried to do it on SQL then implement it to my spring boot project but I’m stuck while writing it. Sorted version: Answer I think you are looking for group by.

Socket closed inside XWM

I have an SQL exception inside a piece of code that works under and scheduled process every day. The patch of code is as follows: There should be no connection problems with this but today i have a socket closed exception in my log in: Here is my log: Any thoughts about why this could happen? First time this schedule

Schema-validation: wrong column type encountered in column

Error: Schema-validation: wrong column type encountered in column [curr_step] in table [risk_workflow]; found [varchar2 (Types#VARCHAR)], but expecting [number(19,0) (Types#BIGINT)] Please let me know how can we solve this? Column declaration in entity class “risk_workflow” WorkflowTaskRoleMapping entity: Answer The id of WorkflowTaskRoleMapping is a long and Hibernate maps it on the db with a column of type number(19,0). Hibernate expects the

Unknown column sql error while using jooq

Query: Error: Database: MYSQL, Database Name: ‘users’, JOOQ Version: 3.16.6 Answer Correlating derived tables isn’t supported in MySQL 5.7. Support has been added only in MySQL 8.0.14: https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html jOOQ currently can’t work around this limitation, see: https://github.com/jOOQ/jOOQ/issues/12045 The solution is either: Upgrade your MySQL version Use a MULTISET_AGG based approach instead

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

Java to SQL Server using Windows Authentication

I am trying to connect to a remote SQL Server DB from a Java application without success. I am able to successfully connect to that SQL Server instance from a SQL client for Mac called SQLPro for MSSQL However, if I try to connect from the Java application using those same credentials, I always get a Login failed error, this

ERREUR : Unknown column ‘Accessoires’ in ‘where clause’

My query is throwing up this error while i have column Accessoires in table categorie Can anyone see why? I FIXED IT LIKE THIS: Answer Using bound parameters with a prepared statement likely fixes your bug and also solves the severe security issue. The likely reason your code has failed is that test was “Accessoires”, so the resulting SQL statement

Advertisement