hi, we are still experiencing trouble with our postgres db and connections hanging "idle in transaction".
we debugged the postgres driver and found out that he starts a transaction on every select-query but does not close it. cayenne does not seem to bother and re-uses these connections for the next query, but other apps have trouble with the transactions, cause they lock the used tables. funny thing is that we cannot reproduce this failure with our test-environment wich has the exact same setup as our live-servers... currently we are doing a commitChanges() after every select-query as a workaround. setting autoCommit to true would have the same effect, but i dont like that idea... kind regards, peter
