Connecting to adhoc SQLite database from Jython?

Ignition
11 
session = IgnitionGateway.get().getPersistenceInterface().getSession()

try:
    session.rawQueryMaps("SELECT * FROM SYSPROPS")
finally:
    session.close()

You could try this; see SSessionJdbc. Make very sure you close the session, or this will hose a running gateway until restarted.

1 Like