conn = cx_Oracle.connect('test/test@192.168.137.3/serv')
def testconnect(request):
xsql="select 'aaa' from dual"
cur=conn.cursor()
cur.execute(xsql)
result = cur.fetchall()
return HttpResponse(json.dumps(result), content_type="application/json")
OperationalError: ORA-03114: not connected to ORACLE
[04/Jul/2020 18:59:56] "GET /testconnect/ HTTP/1.1" 500 71092
Internal Server Error: /testconnect/
Traceback (most recent call last):
File "/usr/local/python27/lib/python2.7/site-packages/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/usr/local/python27/lib/python2.7/site-packages/django/core/handlers/base.py", line 187, in _get_res
cx_oracle 没有重连机制
最新推荐文章于 2022-06-13 16:08:47 发布
当cx_Oracle在数据库连接断开后,没有自动重连机制。为解决此问题,开发者需要手动实现心跳检测或者捕获异常并重新建立连接。本文将探讨如何在Python中优雅地处理这个问题。
摘要由CSDN通过智能技术生成