-
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)
- Регулярные выражения
- Тестирование приложений
Category Archives: Без рубрики
Java.Servlets.How do I call another servlet from one servlet?
In Java servlets, if you want to call another servlet from within your current servlet, you have a few options depending on what exactly you mean by “call”: 1. Forward the request (internal call, no redirect visible to the client) … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlets.How do I call another servlet from one servlet?
Java.Servlet.What is Request Dispatcher?
The RequestDispatcher is a Servlet API tool that lets you forward or include one web resource (like a servlet, JSP, or static file) from another servlet. 📦 What is RequestDispatcher? It’s an interface in the javax.servlet package that allows one … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is Request Dispatcher?
Java.Servlets.What Is ServletRequest?
The ServletRequest interface is your main gateway to reading incoming data from a client (browser, mobile app, etc.) in a Java web application. It lets you extract everything about the request — like parameters, headers, body, input streams, and metadata. … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlets.What Is ServletRequest?
Java.Servlet.What is the ServletResponse interface for?
The ServletResponse interface is used to build and send the response from a servlet back to the client (usually a browser or an HTTP client). 📦 What Is ServletResponse? It’s a core part of the Servlet API: It represents the … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is the ServletResponse interface for?
Java.Servlet.If i have 2 servlets, will i have 2 instances of ServletConfig ?
If you have two servlets, the servlet container will create two separate ServletConfig instances — one for each servlet. 🧠 Why? Because ServletConfig is meant to hold configuration specific to one servlet, such as: Init parameters defined in <servlet> tag … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.If i have 2 servlets, will i have 2 instances of ServletConfig ?
Java.Servlet.What is the difference between ServletContext and ServletConfig?
Both ServletContext and ServletConfig are part of the Servlet API, but they serve different scopes and purposes. Let’s break them down side by side 👇 🧠 Core Difference Feature ServletConfig ServletContext Scope One servlet only Entire web application Purpose Passes … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is the difference between ServletContext and ServletConfig?
Java.Servlets.What is ServletContext?
If ServletConfig is like a servlet’s private config, then ServletContext is like a global shared workspace for the entire web application. 🌍 What Is ServletContext? ServletContext is an object provided by the servlet container that: ✅ Represents the web application’s … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlets.What is ServletContext?
Java.Servlet.What is ServletConfig?
ServletConfig is a special interface in the Servlet API that allows the servlet container to pass configuration information to a servlet at initialization time. You can think of it as the servlet’s own private config object, defined in web.xml (or … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is ServletConfig?
Java.Servlet.How to handle exceptions thrown by another servlet in an application?
Handling exceptions thrown by other servlets is crucial for building robust, user-friendly web applications. There are multiple ways to handle exceptions in a Java servlet-based application, and it all depends on how centralized and graceful you want the handling to … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.How to handle exceptions thrown by another servlet in an application?
Java.Servlet.What is 1 in loadOnStartup = 1 ?
The 1 in loadOnStartup = 1 (or <load-on-startup>1</load-on-startup>) is an integer priority that tells the servlet container: 👉 “Load this servlet when the application starts — and do it in this order relative to other servlets.” 🔢 What Does the … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is 1 in loadOnStartup = 1 ?