> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-docs-fix-500-query-results.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Dameng DM8

> Dameng DM8 over its native wire protocol, with no DM client stack to install

export const name_0 = "Dameng DM8"

export const plugin_0 = "Dameng Driver"

Host, port, username, password. The plugin speaks the DM8 wire protocol itself, so no part of the DM client stack has to be on your Mac and no DM8 version is ruled out.

<Warning>
  A `CLOB` or `BLOB` that DM8 stored outside the row reads as an empty cell. Nothing marks it as truncated, so it looks exactly like an empty column. Cast `CLOB` values to `VARCHAR`, or wrap binary columns in `RAWTOHEX`, when you need the contents.
</Warning>

<Frame caption="The Dameng DM8 connection form">
  <img className="block dark:hidden" src="https://mintcdn.com/ngquct-docs-fix-500-query-results/hA72m8tSnRe3b-ew/images/dameng-connection-form.png?fit=max&auto=format&n=hA72m8tSnRe3b-ew&q=85&s=8e2a9961b99adde488b3234e4ed1a455" alt="Dameng DM8 connection form" width="1560" height="960" data-path="images/dameng-connection-form.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-docs-fix-500-query-results/hA72m8tSnRe3b-ew/images/dameng-connection-form-dark.png?fit=max&auto=format&n=hA72m8tSnRe3b-ew&q=85&s=cb980da29e9627c1dff355bf981c7ba2" alt="Dameng DM8 connection form" width="1560" height="960" data-path="images/dameng-connection-form-dark.png" />
</Frame>

The {name_0} driver is not in the app. Picking {name_0} in the **Choose a Database** sheet offers the
download before the form opens, and opening a saved {name_0} connection installs it without asking.
**Settings > Plugins > Browse > {plugin_0}** installs it up front. See [Plugins](/features/plugins).

## Quick setup

Click **Create Connection…**, choose **Dameng DM8**, fill in host, port, and credentials, and click **Save & Connect**.

## Connection settings

| Field        | Default     | Notes                                                                                                 |
| ------------ | ----------- | ----------------------------------------------------------------------------------------------------- |
| **Host**     | `localhost` | DM8 server or tunnel endpoint                                                                         |
| **Port**     | `5236`      | Default DM8 listener port                                                                             |
| **Database** | -           | Optional, and it picks a schema, not a database. Left empty, the driver uses your username uppercased |
| **Username** | -           | DM username, such as `SYSDBA`                                                                         |
| **Password** | -           | Stored in the macOS Keychain                                                                          |

One DM8 instance holds one database, so there is nothing to switch between; use the schema picker instead, which switches without reconnecting. `SYS`, `SYSDBA`, `SYSAUDITOR`, `SYSSSO`, and `CTISYS` are marked system schemas. An open tab stays on the schema it started with. See [Tabs](/features/tabs#where-a-tab-points).

## Connection URL

```text theme={null}
dm://user:password@host:5236/schema
```

The path is a schema, not a database. See [Connection URL Reference](/connections/urls).

## SSL/TLS

None. Native DM8 TLS is not implemented, the SSL pane is hidden, and the connection is unencrypted. Reach a server outside a private network through an [SSH tunnel](/connections/ssh-tunneling), [SOCKS proxy](/connections/socks-proxy), or [Cloudflare tunnel](/connections/cloudflare-tunnel).

## Limitations

* Stopping a query drops its connection. The driver reconnects on your next query, back on the schema you were using: a read reruns, an open transaction is gone, and a write is reported rather than retried. Check whether the write landed before running it again. A query timeout does the same.
* The server finishes the statement you stopped. A heavy query keeps running there, and a stop can take a few seconds to show up.
* A view definition longer than 8188 bytes is refused. The DDL tab reports the length instead of showing truncated text you could save back. Read the full definition on the server.
* Username and password are the only authentication, and there is no trigger editor. Write trigger DDL in the SQL editor.

## Troubleshooting

**The Dameng connection is closed.**: The server, a tunnel, or the network dropped the connection. The driver rebuilds it on the next query; rerun the statement.

**The Dameng connection was lost, so the open transaction was rolled back.**: Nothing in that transaction committed. Run its statements again.

**Dameng did not switch to the requested schema.**: The schema does not exist or your user cannot reach it. List the schemas visible to your user with `SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'SCH'`.

**Switch away from a schema before dropping it.**: A schema cannot drop itself out from under the session. Move to another one first.

If a server value fails to decode, include the DM8 version and the column type in a [GitHub issue](https://github.com/TableProApp/TablePro/issues).