Versions Compared

Old Version 1

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

compared with

New Version 2

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space WBRIDGE and version 21.1c
Div
Classe2e-refDiv
Rp

Children Display

...

The Bridge uses a generic SQL Database Management System (DBMS) adapter that works with the following DBMSs:

  • DB2

  • Informix

  • InterBase

  • MySQL

  • Oracle

  • PostgreSQL

  • SQLBase

  • SQLite

  • SQLServer

  • Sybase

...

Multiexcerpt include
MultiExcerptNamesql_adapter
nopaneltrue
PageWithExcerptINTERNAL:_examples_BRIDGE

The Bridge also supports MongoDB with a dedicated adapter. See MongoDB Adapter for more details.

Preliminary Notes

Info

Additionally, the Bridge supports the ODBC protocol. Note, that some ODBC drivers have the constraint that only one BLOB is allowed per table. Additionally, the blob type may be defined as last column only. To evade such constraints, use native database drivers whenever possible (see example model odbc.xml referenced below).

...

iconfalse

To use the SQL adapter, you need to install the client tools or the ODBC drivers of the related database. Second, the adapter itself has to be configured. Read more about this topic in chapter Installing and Configuring Database Access.

It is of crucial importance to note that all these databases are accessed via the same adapter. The actual database configuration is described in the component only (see chapter SQL Deployment). This facilitates the management and redirecting of logically equivalent SQL statements to different databases.

...

Info
iconfalse
titleDatabase Interchangeability

...

In order to have the option

...

to switch between DBMSs smoothly, it is strongly recommended to only use ANSI SQL in

...

database queries.

...

If using proper ANSI SQL, all databases served by the SQL adapter are able to communicate with the Bridge. However, if you introduce special commands (like Oracle SQL dialects) into your queries, you are bound to the Oracle DBMS and cannot switch freely.

ODBC Support

Additionally, the Bridge supports the ODBC protocol. Note, that some ODBC drivers have the constraint that only one BLOB is allowed per table. Additionally, the blob type may be defined as last column only.

...

To evade such constraints, use native database drivers whenever possible (see example model odbc.xml referenced below).

Otp
Floatingfalse

Rp
Rde

...