-
MY PROJECTS
-
Recent Posts
- SQL.How can you compare two nullable values safely, and how does IS DISTINCT FROM differ from <>?
- SQL.How are NULL values ordered by ORDER BY, how do defaults differ between databases, and how can you control their placement?
- SQL.How does NULL propagate through arithmetic expressions, and how can COALESCE and NULLIF help handle missing values and division by zero?
- SQL.How does NULL affect join conditions, and why can filtering the right-hand table in WHERE remove unmatched rows from a LEFT JOIN?
- SQL.How do GROUP BY and DISTINCT treat NULL values, even though NULL = NULL evaluates to UNKNOWN?
- SQL.How do aggregate functions handle NULL, and what is the difference between COUNT(*), COUNT(column), and COUNT(DISTINCT column)?
- SQL.How does NULL affect IN and NOT IN, and why can NOT EXISTS be a safer choice when a subquery returns nullable values?
- SQL.How do WHERE, HAVING, and CHECK constraints treat conditions that evaluate to UNKNOWN?
- SQL.Why do column = NULL and column <> NULL not work as expected, and when should you use IS NULL and IS NOT NULL?
- SQL.What is SQL’s three-valued logic (TRUE, FALSE, UNKNOWN), and how do AND, OR, and NOT behave with UNKNOWN?
- ChromeDevTools.Watch all failed requests
- SQL.What are domain types (or constraints on data types), and how do they help enforce data correctness?
- SQL.How does SQL handle comparisons between different data types (for example, string vs number), and why is this dangerous?
- SQL.What is the difference between DATE, TIME, TIMESTAMP, and TIMESTAMPTZ, and which one should be used for business events?
- SQL.How do numeric types like INTEGER, BIGINT, DECIMAL, and FLOAT differ in terms of precision and use cases?
- SQL.What problems can arise from implicit type casting in SQL, and how can it affect indexes?
- SQL.How does NULL differ from 0, an empty string, or FALSE in SQL?
- SQL.What is the difference between CHAR, VARCHAR, and TEXT, and when would you choose each?
- SQL.What is MVCC ?
- SQL.What is AutoVacuum Postgres ?
Categories
- Aptana
- Azure
- C#
- DataSnap
- DBExpress
- Delphi
- Delphi и сети
- Delphi. Язык программирования
- ExtJS
- FastReport
- FireDAC
- FireMonkey
- GIT
- ICS
- IDE
- IIS
- Indy
- InnoSetup
- javascript
- jQuery
- JSON
- LiveBindings
- MSHTML
- MySQL
- PHP
- REST
- Ribbons
- SMS
- SQL инструкции
- SVN
- TRichView
- UniGui
- WebBroker
- WinAPI
- Windows
- Алгоритмы
- Без рубрики
- Деревья
- Ищу ответ
- Компонентостроение
- Мои компоненты
- Начальный уровень
- Обработка исключений
- Парсинг
- Потоки(Threads)
- Регулярные выражения
- Тестирование приложений
Author Archives: Stanislav_Panteleev
Java.Hibernate.Beginner.Explain what means bidirectional ? What’s difference to unidirectional ?
🔹 Bidirectional relationshipA bidirectional relationship means both entities know about each other in your Java model: You can navigate the relationship from either side in your code. Both entities have fields referencing each other. Example: User has a UserProfile field, … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.Explain what means bidirectional ? What’s difference to unidirectional ?
Java.Hibernate.Beginner.OneToOne.Bidirectional
A User entity has exactly one UserProfile, and each UserProfile belongs to exactly one User. 🔹 Entity 1: User 🔹 Entity 2: UserProfile 🔹 What happens here:✅ The UserProfile table has a foreign key column user_id referencing users.id.✅ UserProfile owns … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.OneToOne.Bidirectional
Java.Hibernate.Beginner.What is one-to-one mapping in Hibernate?
A one-to-one mapping in Hibernate represents a relationship where one entity instance is associated with exactly one instance of another entity, and vice versa. It models a real-world scenario where two tables have a one-to-one relationship (e.g., User ↔ UserProfile). … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What is one-to-one mapping in Hibernate?
Java.Hibernate.Beginner.How can you use native SQL queries in Hibernate?
You can execute raw SQL queries directly against the database using Hibernate’s native query API, which lets you write standard SQL (not HQL/JPQL) — useful when you need database-specific features or want maximum control. 🔹 How to create a native … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.How can you use native SQL queries in Hibernate?
Java.Hibernate.Beginner.How can i understad that i use HQL or JPQL ?
🔹 1️⃣ Context of your project JPQL is used if you’re working with JPA (javax.persistence / jakarta.persistence), e.g.: Your project uses JPA annotations (@Entity, @Id, etc.). You create queries using EntityManager.createQuery(). You rely on JPA-standard features like @PersistenceContext, @Transactional. HQL … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.How can i understad that i use HQL or JPQL ?
Java.Hibernate.Beginner.What is the difference between HQL and JPQL?
🔹 HQL (Hibernate Query Language)✅ Hibernate’s own object-oriented query language.✅ Introduced before the JPA standard existed.✅ Very similar to JPQL in syntax, but includes Hibernate-specific features, like: Support for querying Hibernate-specific features (e.g., some collection mappings). Functions that might not … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What is the difference between HQL and JPQL?
Java.Hibernate.Beginner.What is the difference between HQL and SQL?
🔹 HQL (Hibernate Query Language)✅ Object-oriented query language → queries are written against Java entities and their properties, not database tables or columns.✅ Portable → Hibernate translates HQL into database-specific SQL, so you can switch databases without changing your queries.✅ … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What is the difference between HQL and SQL?
Java.Hibernate.Beginner.Explain how can i change criteria api in run time, what does it mean ?
Answer:Changing Criteria API at runtime means you can build queries dynamically based on conditions only known during execution (e.g., user input, UI filters, request parameters) instead of writing fixed, hardcoded queries. 🔹 Why is this important? In real apps, search … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.Explain how can i change criteria api in run time, what does it mean ?
Java.Hibernate.Beginner.What is the Criteria API in Hibernate?
The Criteria API in Hibernate is an object-oriented, programmatic way to build dynamic queries — instead of writing HQL or SQL strings manually, you construct queries using Java objects and method calls. 🔹 Why use Criteria API?✅ Useful when you … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What is the Criteria API in Hibernate?
Java.Hibernate.Beginner.Explain Polymorphic queries and give examples
Polymorphic queries in Hibernate mean you can query a superclass entity and automatically retrieve instances of all its subclasses — without explicitly mentioning each subclass.This happens because Hibernate maps your Java inheritance hierarchy, and HQL supports it natively. 🔹 When … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.Explain Polymorphic queries and give examples