Error report for check..

Everything about DB Sanity

Error report for check..

Postby TomaszN » Tue Feb 22, 2011 11:52 am

I'm looking for software, that i could use in (automated) testing of my SQLite database (loaded locally). So far i didn't find anything except DB Sanity - seemed to be a good solution but as I've noticed probably it doesn't support SQLite, at least i get an error:

java.lang.RuntimeException: Error in query: select AttributeEntryId from frm_AttributeEntry where AttributeId = 12
at org.databene.jdbacl.QueryIterator.createSource(
at org.databene.jdbacl.QueryIterator.(
at org.databene.jdbacl.ArrayResultSetIterator.(
at org.databene.dbsanity.model.query.DefectQueryCheck.query(
at org.databene.dbsanity.model.SanityCheckFile.perform(
at org.databene.dbsanity.model.SanityCheckFolder.perform(
at org.databene.dbsanity.model.SanityCheckFolder.perform(
at org.databene.dbsanity.DbSanity.execute(
at org.databene.dbsanity.DbSanity.main(
Caused by: java.sql.SQLException: SQLite only supports closing cursors at commit
at org.sqlite.Conn.checkCursor(
at org.sqlite.Conn.createStatement(
at org.databene.jdbacl.QueryIterator.createSource(
... 8 more

I added lib for sqlite, file, everything seemed to be ok... Is there any way to force closing cursors?
Posts: 2
Joined: Tue Feb 22, 2011 10:59 am

Re: Error report for check..

Postby Volker Bergmann » Wed Feb 23, 2011 3:16 pm

Hi TomaszN,

this seems to be a limiting concept of SQLite or the JDBC driver you are using.

I can try to work around it. Are you severely interested in using DB Sanity? Then I would try to get around the limit and provide you with a snapshot release for Beta Testing. Unfortunately I do not yet have experience with SQLite and its JDBC drivers, so I would need to rely on your feedback.

Volker 'databene' Bergmann

Need faster response times? phone support? onsite support? training? custom extensions? immediate bug fixes? Support Benerator evolution by buying services from Volker Bergmann!
User avatar
Volker Bergmann
Posts: 654
Joined: Sat Nov 10, 2007 2:40 pm

Re: Error report for check..

Postby TomaszN » Fri Mar 11, 2011 10:41 am

Hello Volker,

Sorry I didn't reply - I wasn't at work for a few days. Actually I've solved my problem - I have found another tool to test my database, so I don't want You to bother finding solution. Besides - DBSanity was just a try and as far as I understood - it performs test only by checking if particular reusult of a query is NULL, so I can't describe an expected result (correct me if I'm wrong) - for me it's poor validation. However - thanks for Your response..

Tomasz N.
Posts: 2
Joined: Tue Feb 22, 2011 10:59 am

Return to DB Sanity

Who is online

Users browsing this forum: No registered users and 0 guests