> For the complete documentation index, see [llms.txt](https://4wsplatform.gitbook.io/user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://4wsplatform.gitbook.io/user-guide/modules/sql-errors-management.md).

# SQL errors management

When working with a database, it is possible to bump into SQL errors fired by a specific database, when writing data (insert, updates, deletes).

Each database has its own error codes and meanings.

Platform provides a feature within the AppDesigner, focused on showing a more user friendly error message, instead of the one provided by the database.

Through **Administration -> SQL Errors**, you can define the error codes and corresponding error messages, for each supported language.

![](/files/-M2saLBUfyaEFwFlxnBv)

These messages must be defined starting from:

* **database type** (DB2, Oracle, MS SqlServer, MySQL, PostgreSQL)
* **error code**, i.e. a numeric value provided by the database, specific for an error; you can figure out which value it has by looking at the server-side log, when a SQL error is fired by the database; check out for "SQL error" patterns in the server log
* optionally you can also specify a **SQL message**, which will be searched by Platform in the original SQL error message: it is matches inside the original error, then the corresponding error message will be shown

Each time Platform finds an error code defined in this feature, for the specific database in use, it will replace the original error message with the one (translated) provided through this feature.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://4wsplatform.gitbook.io/user-guide/modules/sql-errors-management.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.