mwild1 / luadbi

Multi-backend SQL database library for Lua
MIT License
41 stars 15 forks source link

Oracle support for UTF-8; server ping; RAC/TAF #47

Closed JorjBauer closed 5 years ago

JorjBauer commented 6 years ago

Tested on RHEL7, Lua 5.1.4, Oracle 12c w/RAC; Debian 9, Lua 5.3.4, Oracle 12c (no RAC).

UTF-8 and server ping are straightforward. RAC (Real Application Clusters)/TAF (Transparent Application Failover) requires a different logon methodology (which works for non-RAC instances as well), which is a more substantial change.

Failover tested during a RAC node outage with SELECT-type failover; TAF did fail over correctly.