gt;> Sent: Thursday, December 30, 2010 7:04 PM
>> To: solr-user@lucene.apache.org
>> Subject: Re: UPDATE query in deltaquery
>>
>> Hi Ephraim! Thanks for the answer!
>>
>> Actually the user has permissions to make UPDATE queries.
>>
>> I
day, December 30, 2010 7:04 PM
> To: solr-user@lucene.apache.org
> Subject: Re: UPDATE query in deltaquery
>
> Hi Ephraim! Thanks for the answer!
>
> Actually the user has permissions to make UPDATE queries.
>
> I changed the configuration to
>
: Thursday, December 30, 2010 7:04 PM
To: solr-user@lucene.apache.org
Subject: Re: UPDATE query in deltaquery
Hi Ephraim! Thanks for the answer!
Actually the user has permissions to make UPDATE queries.
I changed the configuration to
and I still get the same results.
Cheers!
Juan M.
On Thu
Hi Travis!
I am executing a function in de DB that has two queries: an UPDATE and
a SELECT, and I am getting the select results ok, but the update has
no effects, so it seems that that approach is not working.
Cheers!
Juan M.
On Thu, Dec 30, 2010 at 11:26 AM, Travis Low wrote:
> If you are gett
nal 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:
>
>
>
> url=&q
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:
I have tried
If you are getting a null pointer exception here:
colNames = readFieldNames(resultSet.getMetaData());
Then that implies the DIH code is written to expect a select statement. You
might be able to fool it with some SQL injection:
update blah set foo=bar where id=1234; select id from blah
But
Erick:
Thanks for the quick response.
I can't use the timestamp for doing DIH, so I need to use a custom
field that I need to update one for each delta-import, so that is why
I need to execute an UPDATE on the deltaQuery.
Cheers!
Juan M.
On Thu, Dec 30, 2010 at 10:07 AM, Erick Erickson
wrote:
WARNING: DIH isn't my strong suit, I generally prefer doing things
in SolrJ. Mostly I asked for clarification so someone #else# who
actually knows DIH details could chime in...
That said, I'm a bit confused. As I understand it, you shouldn't
be UPDATEing anything in DIH, it's a select where docume
Hi Erick!
Here is my DIH configuration:
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
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 wrote:
> Hi! I would like to ask you a question about using a deltaQuery in DIH.
> I am syncing with a PostgreSQL database.
>
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 calli
12 matches
Mail list logo
