Tag: mysql

Execute query with MySQL GET_LOCK function in Hibernate

My application uses Hibernate as ORM. I am trying to execute few mysql locking function within my application like GET_LOCK, IS_FREE_LOCK, RELEASE_LOCK (https://dev.mysql.com/doc/refman/5.6/en/locking-functions.html). However I am running into following issue: Here is my Dao code: I am not sure how to execute locking functions using Hibernate. Any help/pointer is appreciated. Thanks in advance. Answer I found the problem. It was

JDBC4 syntax error, but MySQL accepts the query

I’ve tried running the following query with JDBC4, which leads to a syntax error: SELECT m.* FROM schema.table m INNER JOIN ( SELECT :id0 as id, :from0 as date_from, :to0 as date_to UNION …

Error starting ApplicationContext in Spring when add @OneToOne Annotation

: I am a beginner in Java Spring MVC and I want to create a simple program using spring boots. But I have a problem: When I add @OneToOne and @JoinColumn to my model class, the project doesn’t start! …

how do i fetch derived/calculated column from database view or Procedure in Spring Boot using JPA/Hibernate and use it along with predefined columns?

I am working on a project as am learning Spring Boot with JPA,Hibernate with Mustache as for templates. i managed to create a view with one calculated column which calculates an remaining days from …

Strange date error between Development and Production environment

I have a strange date error that I can’t solve for days and ask for your help. I have developed in Java/Spring/Vaadin/Hibernate an app that creates a sport training every day by a user. The problem …

UnsupportedOperationException with DriverManager.getConnection() on Android

I am unable to connect JDBC to my database, getting following error Answer According to the stacktrace, the MySQL Connector/J version you are using is using a java.util.regex.Matcher feature not supported on Android (probably named groups). The workaround is to use a 5.1.x version of MySQL Connector/J instead of a 8.0.x version. However, you shouldn’t use JDBC from Android applications.

Insert data when selecting a dropdown option, MySQL, JAVA, JSP

well my english is not so good, but i will try to explain me, I have a question about how to make an INSERT query when selecting an option from my dropdown, I explain myself, I have a section to insert a user on my website, and an option to select a profile enter image description here It should be