-
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.Servlet.What are the differences between GenericServlet and HttpServlet?
🧠 First: What are GenericServlet and HttpServlet? Class Meaning GenericServlet An abstract class designed for any type of protocol (not just HTTP). HttpServlet A concrete class specifically for HTTP protocol (GET, POST, PUT, DELETE, etc.). Both help you avoid writing … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What are the differences between GenericServlet and HttpServlet?
Java.Servlet.Examples of listeners
🧠 Full List of Important Servlet Listeners + Examples Listener Interface Purpose Example Event It Catches ServletContextListener App startup and shutdown Server starts your app, or app is undeployed HttpSessionListener Session creation and destruction User opens a session (new visit) … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Examples of listeners
Java.Servlet.Difference between Filters and Listeners
🧠 Main Differences Between Filter and Listener Feature Filter Listener What it is Interceptor of requests and responses Event handler for lifecycle events When it runs Every time a matching request comes in When a specific event happens (like app … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Difference between Filters and Listeners
Java.Servlet.What servlet wrapper classes do you know?
🧠 What Are Servlet Wrapper Classes? Wrapper classes are special decorators that wrap around the original HttpServletRequest, HttpServletResponse, or ServletInputStream/ServletOutputStream. They allow you to: Intercept or modify behavior Read, change, or log request/response data Implement security, compression, caching, etc. In … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What servlet wrapper classes do you know?
Java.Servlet.How can I get the client’s IP address on the server?
🧠 How to Get the Client’s IP Address in a Servlet ✅ The basic way: request.getRemoteAddr() returns the IP address of the client making the request. Example: If you’re testing locally ➔ might be 127.0.0.1. If a real client ➔ … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.How can I get the client’s IP address on the server?
Java.Servlet.How can I get server information from a servlet?
You can easily get server information from inside a servlet using the ServletContext and HttpServletRequest objects. Let’s go step-by-step: 🛠️ Ways to Get Server Info in a Servlet 1. Get Server Info using ServletContext ✅ serverInfo will return something like: … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.How can I get server information from a servlet?
Java.Servlet.How can I get the actual location of a servlet on the server?
🧠 If you want to get the real file system path (actual location) of a servlet or a resource on the server, you don’t get it directly from the servlet class itself. Instead, you use the ServletContext object, which represents … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.How can I get the actual location of a servlet on the server?
Java.Servlet.How can I allow a deadlock in a servlet?
🧠 First, can a servlet have a deadlock? Yes.Because servlets are multithreaded: One servlet instance is usually shared between many threads (one thread per request). If you mess with shared resources (like instance variables or external locks) incorrectly, you can … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.How can I allow a deadlock in a servlet?
Java.Servlet.What are servlet attributes used for and how do I work with them?
Attributes are key-value pairs you can attach to an object like: ServletRequest HttpSession ServletContext They are used to share data between: Different parts of your servlet (methods, filters) Different servlets Requests across time (session)
Posted in Без рубрики
Comments Off on Java.Servlet.What are servlet attributes used for and how do I work with them?
Java.Servlet.What is the difference between sendRedirect() and forward()?
Feature forward() (RequestDispatcher) sendRedirect() (HttpServletResponse) Who handles it Server Browser (client) How it works Server internally forwards the same request to another resource (another servlet, JSP, HTML, etc.) Server tells browser: “Hey, go make a new request to a different … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is the difference between sendRedirect() and forward()?