RE: Using the Data Import Handler with SQLite

[Dheeraj Kumar Karnati]

Hi Zac,
  I think you have added entity closing tag 2 times. that might be
causing an issue. It been a long time . not sure whether you are still
working on it or not. 



--
View this message in context: 
http://lucene.472066.n3.nabble.com/Using-the-Data-Import-Handler-with-SQLite-tp2765655p4336690.html
Sent from the Solr - User mailing list archive at Nabble.com.

RE: Using the Data Import Handler with SQLite

[Zac Smith]

I was able to resolve this issue by using a different jdbc driver: 
http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC


-Original Message-
From: Zac Smith [mailto:z...@trinkit.com] 
Sent: Friday, April 01, 2011 5:56 PM
To: solr-user@lucene.apache.org
Subject: Using the Data Import Handler with SQLite

I hope this question is being directed to the right place ...

I am trying to use SQLite (v3) as a source for the Data Import Handler. I am 
using a sqllite jdbc driver (link below) and this works when using with only 
one entity. As soon as I add a sub-entity it falls over with a locked DB error: 
java.sql.SQLException: database is locked.
Now I realize that you can only have one connection open to SQLite at a time. 
So I assume that the first query is leaving a connection open before it moves 
onto the sub-query. I am not sure if the issue would be in the jdbc driver or 
the DIH. It works fine with SQL Server.

Is this a bug? Or something that just isn't possible with SQLite?

Here is a sample of my data config file:
dataConfig
  dataSource type=JdbcDataSource 
  driver=org.sqlite.JDBC
  url=jdbc:sqlite:SolrImportTest.db /
  document
entity name=locations
pk=id
query=select * from locations
field column=Id name=Id /
field column=Name name=Name / 
field column=RegionId name=RegionId /
entity name=regions
pk=id
query=select * from regions where id = 
'${locations.RegionId}'
field column=Name name=RegionName /
/entity
/entity
  /document
/dataConfig

sqllite jdbc driver : http://www.zentus.com/sqlitejdbc/