Re: DIH - Closing ResultSet in JdbcDataSource

2011-01-12 Thread Shane Perry
I have found where a root entity has completed processing and added the logic to clear the entity's cache at that point (didn't change any of the logic for clearing all entity caches once the import has completed). I have also created an enhancement request found at https://issues.apache.org/jira/

Re: DIH - Closing ResultSet in JdbcDataSource

2011-01-11 Thread Shane Perry
By placing some strategic debug messages, I have found that the JDBC connections are not being closed until all elements have been processed (in the entire config file). A simplified example would be: ... field list ... ... field list ...

Re: DIH - Closing ResultSet in JdbcDataSource

2011-01-10 Thread Shane Perry
Gora, Thanks for the response. After taking another look, you are correct about the hasnext() closing the ResultSet object (1.4.1 as well as 1.4.0). I didn't recognize the case difference in the two function calls, so missed it. I'll keep looking into the original issue and reply if I find a ca

Re: DIH - Closing ResultSet in JdbcDataSource

2011-01-08 Thread Gora Mohanty
On Sat, Jan 8, 2011 at 1:10 AM, Shane Perry wrote: > Hi, > > I am in the process of migrating our system from Postgres 8.4 to Solr > 1.4.1.  Our system is fairly complex and as a result, I have had to define > 19 base entities in the data-config.xml definition file.  Each of these > entities execu

Re: DIH - Closing ResultSet in JdbcDataSource

2011-01-07 Thread Adam Estrada
This is my configuration which seems to work just fine. >From there it's just a matter of running the select statement and mapping it against the correct fields in your index. Adam On Fri, Jan 7, 2011 at 2:40 PM, Shane Perry wrote: > Hi, > > I am in the process of migrating our system

DIH - Closing ResultSet in JdbcDataSource

2011-01-07 Thread Shane Perry
Hi, I am in the process of migrating our system from Postgres 8.4 to Solr 1.4.1. Our system is fairly complex and as a result, I have had to define 19 base entities in the data-config.xml definition file. Each of these entities executes 5 queries. When doing a full-import, as each entity comple