Skip to main content

Difference between SQL and HQL quiries in HIBERNATE

 




SQL: SQL is a standardized language used to interact with relational databases.

πŸ‘‰ SQL queries focus on the structure and data within the database tables.

πŸ‘‰ Developers interact directly with database tables and columns.

πŸ‘‰ SQL queries are typically static and written explicitly.

πŸ‘‰Example: SELECT * FROM table_name WHERE condition;


HQL:HQL is specific to Hibernate, which is an ORM tool for Java.

πŸ‘‰HQL operates at a higher level of abstraction, treating database tables as Java objects.

πŸ‘‰ HQL queries focus on Java entities mapped to database tables

πŸ‘‰ HQL queries are more dynamic and flexible compared to static SQL queries.

πŸ‘‰ Example: FROM EntityName(ClassName) WHERE condition


Comments

Popular posts from this blog

Exploring Data Formats: JSON, XML, CSV

  ➡ JSON, XML, and CSV are commonly used for data interchange! in RESTAPI's ok but what is data interchange!?? ⤵ ➡ data interchange format like a language that computers use to talk to each other. Just as people use different languages to communicate, like English, Spanish, or Chinese, computers use specific formats to exchange information. These formats make sure that data is structured in a way that both computers can understand, whether they're sharing data over the internet, saving it to a file, or passing it between different parts of a program. JSON(JavaScript Object Notation) : it used for representing structured data in RESTful APIs, particularly in Spring Web applications. Spring provides excellent support for JSON processing through libraries like Jackson, ➡ It is like writing down information in a way that's easy for both humans and computers to understand. It's a simple and readable format that's often used for transmitting data between a web server ...

Logging in SpringBoot

  Hey Connections πŸ‘‹ Let's learn and grow together πŸ“ˆ 🌟 What is logging ??? ➡ loggers are like reporters for your application. They keep track of what's happening while your application runs, like noting down important events, errors, or just general information. πŸ“©There are different Logging Levels ⤵ πŸŒ† Events: Loggers record events, like when someone signs in or a new feature is added. ❌ Errors: They also note down errors, like when something goes wrong or an unexpected problem occurs. ⚠ Warnings: Sometimes, they give warnings if they see something that could be a problem later, like a traffic jam forming up ahead. πŸ‘¨‍πŸ’» Debugging: And if you need to figure out why something isn't working as expected, loggers can help by showing detailed information, like a detective piecing together clues. These logging levels help developers and operators understand the severity and importance of different log messages and prioritize them accordingly when troubleshooting or monitor...

Unlocking the Power of HIBERNATE

  ⭐ Configuration: πŸ‘‰ The main use of Configuration in Hibernate is to provide all the necessary information about your database πŸ‘‰ It specifies the details of your database connection, such as the URL, username, password, and driver class in XML file. This allows Hibernate to establish a connection to your database. πŸ‘‰ Once we done configuration we can use it to create a SessionFactory. Example: Configuration config=new Configuration( ); ⭐ SessionFactory: πŸ‘‰The SessionFactory is like a factory it produces Session objects πŸ‘‰ SessionFactory is a heavyweight object that's created once, usually during the startup of your application πŸ‘‰ When your application needs to interact with the database, it requests a Session from the SessionFactory. The Session acts as a gateway to the database, allowing you to perform database operations such as saving, updating, or querying data. Example: SessionFactiory sf=config.buildSessionFactory( ); ⭐ Session: πŸ‘‰ In Hibernate, a Session is a crucial com...