Jun-17-2021, 06:45 PM
Greetings,
The connection works with just a single user connection, but I get a HTTP 404 error, when creating a Session Pool connection??
I used this cx_Oracle example:
https://cx-oracle.readthedocs.io/en/late...tion-state
Any suggestions or pointers, would be appreciated.
The code is:
The connection works with just a single user connection, but I get a HTTP 404 error, when creating a Session Pool connection??
I used this cx_Oracle example:
https://cx-oracle.readthedocs.io/en/late...tion-state
Any suggestions or pointers, would be appreciated.
The code is:
def service_response(): responsepool = cx_Oracle.SessionPool(user="user", password="password", dsn="server/dbt", min=2, max=5, increment=1, encoding="UTF-8") connection = responsepool.acquire() cursor = connection.cursor() for responsesql in cursor.execute("SELECT * FROM table"): responsedata = list(cursor.execute(text(responsesql))) print(responsedata) responsepool.release(connection) responsepool.close() return render_template('/index.html', service_response= responsedata)