This may sound silly, but are you sure the user you're using has permissions to do the updates you want? Not sure about postgres but I think some jdbc's require that the connection be defined as rw, maybe you should try adding readOnly="false" to your jdbc definition.
Ephraim Ofir -----Original Message----- From: Juan Manuel Alvarez [mailto:naici...@gmail.com] Sent: Thursday, December 30, 2010 2:52 PM To: solr-user@lucene.apache.org Subject: Re: UPDATE query in deltaquery Hi Erick! Here is my DIH configuration: <dataConfig> <dataSource name="jdbc" driver="org.postgresql.Driver" url="jdbc:postgresql://${dataimporter.request.dbHost}:${dataimporter.req uest.dbPort}/${dataimporter.request.dbName}" user="${dataimporter.request.dbUser}" password="${dataimporter.request.dbPassword}" autoCommit="false" transactionIsolation="TRANSACTION_READ_UNCOMMITTED" holdability="CLOSE_CURSORS_AT_COMMIT"/> <document> <entity name='myEntity' dataSource='jdbc' pk='id' query=' ..... ' deltaImportQuery=' ..... ' deltaQuery=' ..... ' > </entity> </document> </dataConfig> I have tried two options for the deltaQuery: UPDATE "Global"."Projects" SET "prj_lastSync" = now() WHERE "prj_id" = '2'; <---- Throws a null pointer exception as described in the previous email The second option is a DB function that I am calling this way: SELECT "get_deltaimport_items" AS "id" FROM project.get_deltaimport_items(2, 'project'); The function inside executes the UPDATE query shown above and a SELECT query for the ids. The ids are returned ok, but the UPDATE has no effect on the database. Cheers! Juan M. On Thu, Dec 30, 2010 at 1:32 AM, Erick Erickson <erickerick...@gmail.com> wrote: > Well, let's see the queries you're sending, and your DIH configuration. > > Otherwise, we're just guessing... > > Best > Erick > > On Wed, Dec 29, 2010 at 9:58 PM, Juan Manuel Alvarez <naici...@gmail.com>wrote: > >> Hi! I would like to ask you a question about using a deltaQuery in DIH. >> I am syncing with a PostgreSQL database. >> >> At first I was calling a function that made two queries: an UPDATE and a >> SELECT. >> The select result was properly returned, but the UPDATE query did not >> made any changes, >> so I tried calling the same function from a PostgreSQL client and >> everything went OK. >> >> So I tried calling a simple UPDATE query directly in the deltaQuery >> and I receive a >> NullPointerException that I traced to the line 251 of the >> JdbcDataSource.java >> colNames = readFieldNames(resultSet.getMetaData()); >> >> The question is: is there a way I can make the update query work in >> the deltaQuery >> or am I doing something wrong? >> >> Happy new year!!!! >> Cheers! >> Juan M. >> >
