Getting error on calling commit() method about ifxpy HOT 8 OPEN

Did you create the database with logging (e.g., "create database test with log")?
Any transaction op (like commit) will fail if you are connected to a non-logged database

from ifxpy.

@jsagrera can i found if current database is logged or not by using ifxpy

from ifxpy.

You can run the following SQL:

> select name,is_logging,is_buff_log from sysmaster:sysdatabases where name='stores7';



name         stores7
is_logging   1
is_buff_log  0

1 row(s) retrieved.

>

from ifxpy.

is there any direct method/function in ifxpy

from ifxpy.

An Informix database needs to have logging to be able to support transactions. You can change the mode (logging) of the database with the ondblog command (but will require a backup). More info here: https://www.ibm.com/support/pages/how-change-database-logging-mode-using-ondblog-command

from ifxpy.

Ok thank you so much sir @jsagrera

from ifxpy.

@jsagrera why InformixAlchemy is not publish on Pypi ??

from ifxpy.

I guess because it is still on the "development" phase.

from ifxpy.