I have solr 9.8.0 running the data import handler in standalone mode.
All the documented steps fail in zoo keeper mode (bummer).
I can import data from MySQL and Postgres but when I try oracle it
fails. The output in the solr log looks like it is going to connect and
then it just does nothing.
Here is the log output when doing a Full Import in 8.4.1
2025-02-04 13:39:13.301 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.h.d.DataImporter Loading DIH Configuration: data-config.xml
2025-02-04 13:39:13.337 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.h.d.c.DIHConfiguration The field :clientName present in DataConfig
does not have a counterpart in Solr Schema
2025-02-04 13:39:13.337 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.h.d.DataImporter Data Configuration loaded successfully
2025-02-04 13:39:13.360 INFO (Thread-24) [ ] o.a.s.h.d.DataImporter
Starting Full Import
2025-02-04 13:39:13.360 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.c.S.Request [rat_11] webapp=/solr path=/DmeImport
params={commit=true&clean=true&wt=xml&command=full-import} status=0 QTime=65
2025-02-04 13:39:13.389 WARN (Thread-24) [ ]
o.a.s.h.d.SimplePropertiesWriter Unable to read: DmeImport.properties
2025-02-04 13:39:13.637 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
Creating a connection for entity asset_core with URL:
jdbc:oracle:thin:@rat:52689:dme1
2025-02-04 13:39:14.183 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
Time taken for getConnection(): 545
2025-02-04 13:39:14.331 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
Creating a connection for entity asset_dmeaccount with URL:
jdbc:oracle:thin:@rat:52689:dme1
...
After here the rest of my tables connect and import
Here is the log output for solr 9.8.0
2025-02-04 15:04:57.366 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.h.d.DataImporter Loading DIH Configuration:
data-config.xml
2025-02-04 15:04:57.429 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.h.d.c.DIHConfiguration The field :clientName
present in DataConfig does not have a counterpart in Solr Schema
2025-02-04 15:04:57.429 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.h.d.DataImporter Data Configuration loaded
successfully
2025-02-04 15:04:57.451 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.c.S.Request webapp=/solr path=/DmeImport
params={commit=true&clean=true&wt=xml&command=full-import} status=0 QTime=86
2025-02-04 15:04:57.451 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.h.d.DataImporter Starting Full Import
2025-02-04 15:04:57.475 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.h.d.SimplePropertiesWriter Read DmeImport.properties
2025-02-04 15:04:57.623 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.h.d.JdbcDataSource Creating a connection for entity asset_core
with URL: jdbc:oracle:thin:@rat:52689:dme1
2025-02-04 15:04:57.838 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.u.p.LogUpdateProcessorFactory webapp=/solr path=/DmeImport
params={commit=true&clean=true&wt=xml&command=full-import} status=0
QTime=86{deleteByQuery=*:* (-1823169888949108736)} 0 474
It just stops here.
I used a lib directory parallel with the conf directory and I put:
data-import-handler-9.7.0.jar
ojdbc6.jar
Anybody got any suggestions?
