Python Forum

Full Version: HTTP 404 error with Session Pool
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

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:

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)))


    return render_template('/index.html', service_response= responsedata)