Crawler DatabaseDataStore AS400 DB2

English:Fess
1

Hi,

is it possible to create a FESS Crawler on db2 database (as400)?
How can I do it?

Best Regards
Diego

2

Fess can crawl data in DB2.

  1. Upload JDBC driver(Jar file) for DB2 on Plugin page
  2. Create a DataStore setting with the JDBC driver on the DataStore page
1 Like
3

I tried to configure the Datastore Crawler with JDBC jt400 driver and these parameters:

driver=com.ibm.as400.access.AS400JDBCDriver
url=jdbc:as400://srvlab01.smeup.com/P_003733
username="urrazi"
password={cipher}06407a32b96e5e1d75698f3c0b7c1d6c
sql=select * from WS_1700F

But FESS fails to crawl data in DB

org.codelibs.fess.exception.DataStoreException: Failed to crawl data in DB.
at org.codelibs.fess.ds.db.DatabaseDataStore.storeData(DatabaseDataStore.java:187)
at org.codelibs.fess.ds.AbstractDataStore.store(AbstractDataStore.java:121)
at org.codelibs.fess.helper.DataIndexHelper$DataCrawlingThread.process(DataIndexHelper.java:216)
at org.codelibs.fess.helper.DataIndexHelper$DataCrawlingThread.run(DataIndexHelper.java:202)
Caused by: java.awt.HeadlessException
at java.desktop/java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:166)
at java.desktop/java.awt.Window.<init>(Window.java:553)
at java.desktop/java.awt.Frame.<init>(Frame.java:428)
at java.desktop/java.awt.Frame.<init>(Frame.java:393)
at com.ibm.as400.access.ToolboxSignonHandler.setupPasswordDialog(ToolboxSignonHandler.java:573)
at com.ibm.as400.access.ToolboxSignonHandler.handleSignon(ToolboxSignonHandler.java:496)
at com.ibm.as400.access.ToolboxSignonHandler.connectionInitiated(ToolboxSignonHandler.java:50)
at com.ibm.as400.access.AS400.promptSignon(AS400.java:2412)
at com.ibm.as400.access.AS400.signon(AS400.java:3684)
at com.ibm.as400.access.AS400.connectService(AS400.java:1107)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3133)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1373)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1210)
at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:351)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:252)
at org.codelibs.fess.ds.db.DatabaseDataStore.storeData(DatabaseDataStore.java:111)

Thanks

4

According to Getting HeadlessException with jt400.jar driver, it needs prompt=false.
So you need to set it as below.

url=jdbc:as400://srvlab01.smeup.com/P_003733;prompt=false
1 Like
5

Problem solved.
Thanks