diff options
author | Joachim Puhr <jpuhr@gmx.de> | 2018-01-08 16:50:30 +0100 |
---|---|---|
committer | Joachim Puhr <jpuhr@gmx.de> | 2018-01-09 16:35:58 +0000 |
commit | 50deb8cf70f61e21fb0c35182341477af11adbc1 (patch) | |
tree | afd410852b990518e26a05b45e50e278b8560da2 | |
parent | af1a179cc8b599523ca858b1b9f55c93a734d047 (diff) |
doc: Hints for using SAP HANA database
As the HANA ODBC driver does not provide scrollable
results per default, the connection has to be established
with a specific option.
Change-Id: I14751a94f61d6fffd6d56c39076c24ec4d1f88ef
Reviewed-by: Edward Welbourne <edward.welbourne@qt.io>
Reviewed-by: Joachim Puhr <jpuhr@gmx.de>
Reviewed-by: Andy Shaw <andy.shaw@qt.io>
-rw-r--r-- | src/sql/doc/snippets/code/doc_src_sql-driver.cpp | 12 | ||||
-rw-r--r-- | src/sql/doc/src/sql-driver.qdoc | 6 |
2 files changed, 18 insertions, 0 deletions
diff --git a/src/sql/doc/snippets/code/doc_src_sql-driver.cpp b/src/sql/doc/snippets/code/doc_src_sql-driver.cpp index 7983386642..9fdb49eb45 100644 --- a/src/sql/doc/snippets/code/doc_src_sql-driver.cpp +++ b/src/sql/doc/snippets/code/doc_src_sql-driver.cpp @@ -95,3 +95,15 @@ QSqlDatabase: available drivers: QMYSQL //! [34] column.contains(QRegularExpression("pattern")); //! [34] + + +//! [35] +QSqlDatabase db = QSqlDatabase::addDatabase("QODBC3"); +QString connectString = QStringLiteral( + "DRIVER=/path/to/installation/libodbcHDB.so;" + "SERVERNODE=hostname:port;" + "UID=USER;" + "PWD=PASSWORD;" + "SCROLLABLERESULT=true"); +db.setDatabaseName(connectString); +//! [35] diff --git a/src/sql/doc/src/sql-driver.qdoc b/src/sql/doc/src/sql-driver.qdoc index 025cd43ef7..44acb79c46 100644 --- a/src/sql/doc/src/sql-driver.qdoc +++ b/src/sql/doc/src/sql-driver.qdoc @@ -299,6 +299,12 @@ e.g., the SQLSTATEs. Before setting this connect option, consult your ODBC documentation about behavior differences you can expect. + When using the SAP HANA database, the connection has to be + established using the option "SCROLLABLERESULT=TRUE", as the + HANA ODBC driver does not provide scrollable results by default, e.g.: + + \snippet code/doc_src_sql-driver.cpp 35 + If you experience very slow access of the ODBC datasource, make sure that ODBC call tracing is turned off in the ODBC datasource manager. |