summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJoachim Puhr <jpuhr@gmx.de>2018-01-08 16:50:30 +0100
committerJoachim Puhr <jpuhr@gmx.de>2018-01-09 16:35:58 +0000
commit50deb8cf70f61e21fb0c35182341477af11adbc1 (patch)
treeafd410852b990518e26a05b45e50e278b8560da2
parentaf1a179cc8b599523ca858b1b9f55c93a734d047 (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.cpp12
-rw-r--r--src/sql/doc/src/sql-driver.qdoc6
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.