turtle

update ="UPDATE TT_WORK SET IS_YN = 'Y' WHERE SEQ_NO= ?" cur.execute(update,(best_no)) cur.commit() cur.close() cur.execute(update, ( best_no ) ) ->  cur.execute(update, [ best_no ] )

https://sqlitebrowser.org/dl/

h2database URL : http://www.h2database.com/ log4J.xml <appender name="jdbcAppender" class="org.apache.log4j.jdbc.JDBCAppender"> <param name="URL" value="jdbc:h2:file:~/db/oasis" /> <param name="Driver" value="org.h2.Driver" /> <param name="User" value="oasis" /> <param name="Password" value="" /> <layout class="org.apache.log4j.EnhancedPatternLayout">             <param name="ConversionPattern"               value="INSERT INTO OASIS_LOG (SYSTEM_NAME, LOG_DATE, LOG_LEVEL, MESSAGE, THROWABLE) VALUES ('%C', '%d{yyyy-MM-dd HH:mm:ss.SSS}', '%p', '%m', '%throwable{10}');"             />         </layout> </appender> log file name : oasis.h2.db