# Jruby sqlite3 INSERT problem

**URL:** <https://www.ruby-forum.com/t/jruby-sqlite3-insert-problem/160775>\
**Category:** Ruby\
**Created:** [February 19, 2009, 4:40pm UTC](https://www.ruby-forum.com/t/jruby-sqlite3-insert-problem/160775 "2009-02-19T16:40:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kenneth\_McDonald](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/dc4da7/32.png) [@Kenneth\_McDonald](https://www.ruby-forum.com/u/Kenneth_McDonald)\
**Post date:** [February 19, 2009, 4:40pm UTC](https://www.ruby-forum.com/t/jruby-sqlite3-insert-problem/160775/1 "2009-02-19T16:40:13Z")

</div>

The following statement:

> ```
> @db.execute("INSERT INTO log_files VALUES (NULL, ?)", @filename)
> 
> ```

is not resulting in a persistent insert into the database (although it  
is apparently resulting in a temporary insert). The problem is not a  
transactional one, because if I issue a “commit” statement afterwards,  
I get an error message stating that no transaction is active. Anyone  
have any ideas what might be happening here? The corresponding code  
from Python works just fine.

Thanks,  
Ken