...
There are two possibilities how to use a database connection. For the one hand, you can create a persistent connection and reuse this connection in other queries. On the other hand, you can directly create a connection for each query. First, we show how to create and drop persistent connections and show how to use them in PQL and StreamSQL(CQL). Afterwards, we show how to directly setup a connection using PQL.
| Table of Contents |
|---|
Important Notices
For Oracle: There was a bug (the Oracle driver said: "Locale not found") that was fixed in Version 1.0.0.14252. However,notice that this bug cannot be fixed by simply updating the Odysseus Studio application. So, you may have to install a fresh and new version of Odysseus Studio to fix the "Locale-Bug".
Open and drop persistent database connections
...
| Code Block |
|---|
CREATE DATABASE CONNECTION con1b AS oracle TO test CREATE DATABASE CONNECTION con1c AS postgresql TO test |
Note for oracle: the last token ("test" in this example) is the SID. Furthermore, there was a bug (the Oracle driver said: "Locale not found") that was fixed in Version 1.0.0.14252. However,notice that this bug cannot be fixed by simply updating the Odysseus Studio application. So, you may have to install a fresh and new version of Odysseus Studio to fix the "Locale-Bug": the last token ("test" in this example) is the SID.
You may also define the host and/or the port you want to connect to:
...