Login via MySql client:$ mysql -u XXXXX -pXXXXX db_nameCreate a new user:CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';GRANT ALL ON *.* TO 'user1'@'localhost';CREATE USER 'user1'@'%' IDENTIFIED BY 'pass1';GRANT ALL ON *.* TO 'user1'@'%';List users:select host, user, password, Create_priv from mysql.user;List databases and tables:show databases;show tables;Rename column:ALTER TABLE Article change article_id id bigint(20);Make column non-null:ALTER TABLE Person MODIFY firstName varchar(255) NOT NULL;Make column unique:ALTER TABLE Person ADD...
-
Getting the java.sql.Connection object using Session: --------------------------------------------------------------------------- org.hibern...
-
In this post, we are going to learn how to integrate Spring4 MVC with Hibernate4 application with Maven build tool and will perform CRUD o... -
Example 1: given the below input the output will be 2+13+8+22=45 Given Input [2GSD#13x8xU343%^DGF1@22@] Expected output 45 Example 2: given ...
-
Exception in thread "main" java.lang.UnsupportedOperationException: The application must supply JDBC connections. Problem: whi... -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: No data...
-
The major differences between Spring framework and Struts framework are : Spring Struts Spring is an application framework in which Spring ...
-
Creating a Custom Dialect in Hibernate: In order to create any new Dialect class we need to extends org.hibernate.dialect . Dialect class....
-
This post demonstrates the how to get the all table names using Hibernate. Configuration configuration = new Configuration () ; configura...
-
Setting the Classpath in Intellij IDEA: Way1 : Open Project Structure (either Ctrl+Alt+Shift+S or File > Project Structure) Select ...
-
In hibernate , there are two ways to get the org.hibernate. Session object. Using openSession() method Using getCurrentSession() method 1...