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)
