RE: Problem with DIH delta-import on JDBC

2010-04-29 Thread cbennett
Hi, It looks like the deltaImportQuery needs to be changed you are using dataimporter.delta.id which is not correct, you are selecting objected in the deltaQuery, so the deltaImportQuery should be using dataimporter.delta.objectid So try this: entity name=test pk=objectid query=select *

RE: Problem with DIH delta-import on JDBC

2010-04-29 Thread safl
Hi, I did a debugger session and found that the column names are case sensitive (at least with Oracle). The column names are retreived from the JDBC metadatas and I found that my objectid is in fact OBJECTID. So now, I'm able to do an update with the following config (pay attention to the

Re: Problem with DIH delta-import on JDBC

2010-04-29 Thread Jon Baer
All that stuff happens in the JDBC driver associated w/ the DataSource so probably not unless there is something which can be set in the Oracle driver itself. One thing that might have helped in this case might have been if readFieldNames() in the JDBCDataSource dumped its return to debug log

Re: Problem with DIH delta-import on JDBC

2010-04-28 Thread Jon Baer
You should end up w/ a file like conf/dataimport.properties @ full import time, might be that it did not get written out? - Jon On Apr 28, 2010, at 3:05 PM, safl wrote: Hello, I'm just new on the list. I searched a lot on the list, but I didn't find an answer to my question. I'm

Re: Problem with DIH delta-import on JDBC

2010-04-28 Thread safl
Jon Baer wrote: You should end up w/ a file like conf/dataimport.properties @ full import time, might be that it did not get written out? - Jon That's right. I get the dataimport.properties in conf directory after full import and the deltaQuery looks like: select objectid from table